c# sql server get first row

            SqlConnection conn = new SqlConnection(BMS_DLL.SQL.sqlConnectionSource.ConnectionString);
            SqlCommand cmd = new SqlCommand("SELECT TOP 1 * FROM BM_PDKS_PARAMETRELER WHERE TUR='CALISMASAATI'", conn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            foreach (DataRow dr in dt.Rows) {
                SE_NS.EditValue = double.Parse( dr["NS"].ToString());
                SE_HS.EditValue = double.Parse(dr["HS"].ToString());

            }

Leave a comment