System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection("connectionStringHere");
con.Open();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_Here";
System.Data.SqlClient.SqlDataReader reader;
reader = cmd.ExecuteReader();
System.Text.StringBuilder sb=new System.Text.StringBuilder()
sb.AppenedLine("<ul>");
while(reader.Read())
{
sb.AppenedFormat("<li>{0}</li>" reader.GetString(0));
}
sb.AppenedLine("</ul>");
Try with this code.
Thanks,
Mamun