private void GetStory() { dbConnection db = new dbConnection(); DataTable Tt = db.CarryOutSqlGeDataTable( "select top 1 NiLifeStory ,NiName from [Family].[dbo].[tblNumberInfo] where LEN(NiLifeStory)>30 order by newid()"); txtStroyFamily.Text = " " + Tt.Rows[0]["NiName"].ToString() + ":" + Tt.Rows[0]["NiLifeStory"].ToString(); }
private void getListData(string sql) { dbConnection db = new dbConnection(); dgvList.DataSource = db.CarryOutSqlGeDataTable(sql); }