{"id":91,"date":"2014-05-15T20:26:00","date_gmt":"2014-05-15T19:26:00","guid":{"rendered":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/15\/datamanger\/"},"modified":"2014-05-15T20:26:00","modified_gmt":"2014-05-15T19:26:00","slug":"datamanger","status":"publish","type":"post","link":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/15\/datamanger\/","title":{"rendered":"DataManger?"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>2 Minute, 19 Second <\/div>\n\n <\/div>
\n public class DataManager
\n    {
\n        string connectionString = “Data Source=(local);Initial Catalog=CompanyDb;Persist Security Info=True;User ID=sa;Password=123”;
\n        public int SqlExecuteQuery(string strQuery, int timeOut)
\n        {
\n            int returnCount = 0;
\n            SqlConnection sqlConnection = new SqlConnection();
\n            SqlCommand sqlCommand = new SqlCommand();
\n            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
\n            sqlConnection.ConnectionString = connectionString;
\n            sqlConnection.Open();
\n            sqlCommand.CommandText = strQuery;
\n            sqlCommand.CommandTimeout = timeOut;
\n            sqlCommand.Connection = sqlConnection;
\n            returnCount = sqlCommand.ExecuteNonQuery();
\n            sqlConnection.Close();
\n            return returnCount;
\n        }<\/p>\n

        public DataSet SqlSelectQuery(string strQuery, int timeOut)
\n        {
\n            DataSet ds = new DataSet();
\n            SqlConnection sqlConnection = new SqlConnection();
\n            SqlCommand sqlCommand = new SqlCommand();
\n            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
\n            sqlConnection.ConnectionString = connectionString;
\n            sqlConnection.Open();
\n            sqlCommand.CommandText = strQuery;
\n            sqlCommand.CommandTimeout = timeOut;
\n            sqlCommand.Connection = sqlConnection;
\n            sqlDataAdapter.Fill(ds);
\n            sqlConnection.Close();
\n            return ds;
\n        }<\/p>\n

        public object SqlScalarQuery(string strQuery, int timeOut)
\n        {
\n            object returnString = new object();
\n            SqlConnection sqlConnection = new SqlConnection();
\n            SqlCommand sqlCommand = new SqlCommand();
\n            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
\n            sqlConnection.ConnectionString = connectionString;
\n            sqlConnection.Open();
\n            sqlCommand.CommandText = strQuery;
\n            sqlCommand.CommandTimeout = timeOut;
\n            sqlCommand.Connection = sqlConnection;
\n            returnString = sqlCommand.ExecuteScalar();
\n            sqlConnection.Close();
\n            return returnString;
\n        }
\n    }
\n———————————————————————————————————-
\nTo generate Max Id<\/p>\n

   public void GetStudentId()
\n        {
\n            string str = “select isnull(max(id),0)+1 from student”;
\n            TextBox6.Text = Convert.ToString(dm.SqlScalarQuery(str, 1000));
\n        }
\n———————————————————————————————————–<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

 public class DataManager     {         string connectionString = “Data Source=(local);Initial Catalog=CompanyDb;Persist Security Info=True;User ID=sa;Password=123”;         public int SqlExecuteQuery(string strQuery, int timeOut)         {             int returnCount = 0;             SqlConnection sqlConnection = new SqlConnection(); […]<\/p>\n","protected":false},"author":43,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-blog"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Himanshu Namdeo","author_link":"https:\/\/debuggersspace.com\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":" public class DataManager     {         string connectionString = “Data Source=(local);Initial Catalog=CompanyDb;Persist Security Info=True;User ID=sa;Password=123”;         public int SqlExecuteQuery(string strQuery, int timeOut)         {             int returnCount = 0;             SqlConnection sqlConnection = new SqlConnection();…","_links":{"self":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/91"}],"collection":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":0,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/91\/revisions"}],"wp:attachment":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/media?parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/categories?post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/tags?post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}