Introduction
As mentioned in the blog header the code is for creating WebService of retreiving Table details through Sql Database.
[System.Web.Script.Services.ScriptMethod()]
[System.Web.Services.WebMethod]
public static List<string> getSqlinfo(string prefixText)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnectionString"].ToString());
conn.Open();
// If the table name starts from UserDetails we can write User and then search for the details as the query contains a like i.e % character which will search for all the tables named with User%.
SqlCommand cmd = new SqlCommand("SELECT NAME FROM SYS.TABLES WHERE NAME LIKE @Name+'%'", conn);
cmd.Parameters.AddWithValue("@Name", prefixText.ToUpper());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
List<string> tablename = new List<string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
tablename.Add(dt.Rows[i][0].ToString());
}
return tablename;
}