public static DataTable Getafile(int id) { DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection()) { OpenConnection(con); SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandTimeout = 0; com.CommandText = "SELECT ID, Name, [Content], size, data FROM Connectivity where ID=@ID"; com.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(); com.Parameters.Add("@ID", SqlDbType.Int); com.Parameters["@ID"].Value = id; da.SelectCommand = com; da.Fill(dt); con.Close(); } return dt; }
executeMyQuery
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)