I'm trying to read items from a DataTable into a webpage, but getting 2 errors in the C# code: \[code\]p1.InnerHTML = dt.rows(0).Item(0);\[/code\] Errors
1 does not exist in the current content.System.Data.Datatable does not contain a definition for 'rows' and no extension method 'rows' accepting a first argument ..C#\[code\]protected void Page_Load(object sender, EventArgs e){ DataTable dt = new DataTable(); string strConnection = ConfigurationManager.ConnectionStrings["ChinatowndbConnString"].ConnectionString; SqlConnection conn = new SqlConnection(strConnection); string sql = "SELECT pagetext FROM Content where pagetag = 1"; SqlCommand cmd = new SqlCommand(sql); cmd.CommandType = CommandType.Text; cmd.Connection = conn; SqlDataAdapter sd = new SqlDataAdapter(cmd); sd.Fill(dt); p1.InnerHTML = dt.rows(0).Item(0); p2.InnerHTML = dt.rows(1).Item(0); p3.InnerHTML = dt.rows(2).Item(0);}\[/code\]HTML:\[code\]<p id="p1" class="none"></p><p id="p2" class="none"></p><p id="p3" class="none"></p>\[/code\]Any ideas how to get my code working,ThanksTea
1 does not exist in the current content.System.Data.Datatable does not contain a definition for 'rows' and no extension method 'rows' accepting a first argument ..C#\[code\]protected void Page_Load(object sender, EventArgs e){ DataTable dt = new DataTable(); string strConnection = ConfigurationManager.ConnectionStrings["ChinatowndbConnString"].ConnectionString; SqlConnection conn = new SqlConnection(strConnection); string sql = "SELECT pagetext FROM Content where pagetag = 1"; SqlCommand cmd = new SqlCommand(sql); cmd.CommandType = CommandType.Text; cmd.Connection = conn; SqlDataAdapter sd = new SqlDataAdapter(cmd); sd.Fill(dt); p1.InnerHTML = dt.rows(0).Item(0); p2.InnerHTML = dt.rows(1).Item(0); p3.InnerHTML = dt.rows(2).Item(0);}\[/code\]HTML:\[code\]<p id="p1" class="none"></p><p id="p2" class="none"></p><p id="p3" class="none"></p>\[/code\]Any ideas how to get my code working,ThanksTea