if (SqlClass.dsGenel.Tables.Contains(“tblMarkalar”)) { SqlClass.dsGenel.Tables.Remove(“tblMarkalar”); SqlClass.dsGenel.Tables.Remove(“tblMarkalar”); } string sqlCumle = “SELECT [MARKA] FROM [Erdemler].[dbo].[Umt_055_Markalar] ORDER BY MARKA”; SqlClass.dsGenel = SqlClass.GetDataset(sqlCumle, “tblMarkalar”);
for (int i = 0; i < SqlClass.dsGenel.Tables["tblMarkalar"].Rows.Count; i++)
{
this.checkedListBoxControl1.Items.Add(SqlClass.dsGenel.Tables["tblMarkalar"].Rows[i]["MARKA"].ToString());
}
Comments are closed