01.public DataTable GetRecords(string prefixText)
02. {
03. string strConn = ConfigurationManager.ConnectionStrings
04. ["ManageMentConnectionString"].ConnectionString;
05. SqlConnection con = new SqlConnection(strConn);
06. SqlCommand cmd = new SqlCommand();
07. cmd.Connection = con;
08. cmd.CommandText = "select dbo.Professor.name from dbo.Professor where dbo.Professor.name like '%'+@name+'%'";
09. cmd.CommandType = System.Data.CommandType.Text;
10. cmd.Parameters.AddWithValue("@name", prefixText);
11. DataSet objDs = new DataSet();
12. SqlDataAdapter dAdapter = new SqlDataAdapter();
13. dAdapter.SelectCommand = cmd;
14. con.Open();
15. dAdapter.Fill(objDs);
16. con.Close();
17. return objDs.Tables[0];
18. }
