How to learn c# and how to learn connection c# to sql database: Database Connection c# to mssql
    • Showing posts with label Database Connection c# to mssql. Show all posts
    Showing posts with label Database Connection c# to mssql. Show all posts

    Tuesday, December 24, 2019

    December 24, 2019 0
    Database Connection c# to mssql

    using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Text; using System.Threading.Tasks; namespace DIGISHOP.App_Data { public class clsDataProcess { public SqlConnection getConnection() { //string connStr = @"data source=(local);database='Database';Connection Timeout=3000;Integrated Security=True"; string connStr = @"data source=SQL14;database=Database;uid=userid;password=password"; SqlConnection conn = new SqlConnection(connStr); return conn; } public DataTable GetDataTable(string query, out string ERROR) { SqlConnection dbCon = getConnection(); dbCon.Open(); DataTable dt = new DataTable(); SqlCommand command = new SqlCommand(); command.Connection = dbCon; command.CommandType = CommandType.Text; command.CommandText = query; try { SqlDataReader dr = command.ExecuteReader(); ERROR = String.Empty; dt.Load(dr); } catch (Exception ex) { ERROR = ex.ToString(); } finally { dbCon.Close(); } return dt; } public int ExecuteSql(string query, out string ERROR) { int result = 0; SqlConnection dbCon = null; try { dbCon = getConnection(); dbCon.Open(); SqlCommand command = new SqlCommand(query, dbCon); var ret = command.ExecuteScalar(); if (ret.GetType() != typeof(DBNull)) result = Int32.Parse(ret.ToString()); else result = 0; ERROR = String.Empty; } catch (Exception ex) { ERROR = ex.ToString(); } finally { dbCon.Close(); } return result; } public string UpdateCommand(string strSQl, out string ERROR) { string rt = ""; SqlConnection dbCon = null; try { dbCon = getConnection(); dbCon.Open(); SqlCommand sqlCmd = new SqlCommand(strSQl, dbCon); sqlCmd.ExecuteNonQuery(); ERROR = String.Empty; } catch (Exception ex) { ERROR = ex.ToString(); } finally { dbCon.Close(); } return rt; } } }
    By at No comments:
    Labels: