javagair
asked on
gridview is blank
I create a datatable with 0 in the cells, table creates just fine.
gridview shows up just fine
but the datatable numbers are blank in the gridview
can anyone see what I forgot?
gary
Function createtablevendor() As DataTable
Dim vendortable1 As New DataTable
' Create 16 typed columns in the DataTable.
vendortable1.Columns.Add(" Vendor_Id" , GetType(Integer)) '1
vendortable1.Columns.Add(" type", GetType(String)) '2
vendortable1.Columns.Add(" Name", GetType(String)) '3
vendortable1.Columns.Add(" Address", GetType(Integer)) '4
vendortable1.Columns.Add(" town", GetType(String)) '5
vendortable1.Columns.Add(" state", GetType(String)) '6
vendortable1.Columns.Add(" zip", GetType(String)) '7
vendortable1.Columns.Add(" fax", GetType(String)) '8
vendortable1.Columns.Add(" Phone", GetType(String)) '9
vendortable1.Columns.Add(" Cell", GetType(String)) '10
vendortable1.Columns.Add(" extension" , GetType(String)) '11
vendortable1.Columns.Add(" Tin", GetType(String)) '12
vendortable1.Columns.Add(" Soc_Sec", GetType(String)) '13
vendortable1.Columns.Add(" Email", GetType(Integer)) '14
vendortable1.Columns.Add(" Obsolete", GetType(String)) '15
vendortable1.Columns.Add(" Comment", GetType(String)) '16
Return vendortable1
End Function
vendortable = createtablevendor()
Dst.Tables.Add(vendortable )
For i = 1 To 10
Dst.Tables("table1").Rows. Add(i, "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", " ")
' 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Next
vendortable.DefaultView.So rt = "Vendor_Id ASC"
gvvendorname.DataSource = Dst.Tables("table1")
gvvendorname.Visible = True
gvvendorname.DataBind()
grid shows up with all of the correct headers but the datatable does not bind to it.
<asp:gridview id="gvvendorname"
autogeneratecolumns="False "
autogenerateeditbutton="fa lse"
visible = "false"
runat="server">
<columns>
<asp:TemplateField HeaderText="Vendor_ID">
<ItemTemplate>
<asp:TextBox ID="tbVendor_VendorId" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Vendor_Name">
<ItemTemplate>
<asp:TextBox ID="TextBoxVendor_name" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_address ">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_address" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_town">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_town" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_state">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_state" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_zip">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_zip" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_fax">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_fax" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_phone">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_phone" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_cell">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_cell" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_extensi on">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_extensio n" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_tin">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_tin" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_soc_sec ">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_soc_sec" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_email">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_email" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Vendor_Obsolet e" ItemStyle-Width="50px">
<ItemTemplate>
<asp:DropDownList ID="dplvendorobsolete" runat="server" >
<asp:ListItem Selected="True"
Value="0">Select</asp:List Item>
<asp:ListItem>YES</asp:Lis tItem>
<asp:ListItem>NO</asp:List Item>
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Comment">
<ItemTemplate>
<asp:TextBox ID="TextBoxfromVendor_comm ent" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</columns>
</asp:gridview>
gridview shows up just fine
but the datatable numbers are blank in the gridview
can anyone see what I forgot?
gary
Function createtablevendor() As DataTable
Dim vendortable1 As New DataTable
' Create 16 typed columns in the DataTable.
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
vendortable1.Columns.Add("
Return vendortable1
End Function
vendortable = createtablevendor()
Dst.Tables.Add(vendortable
For i = 1 To 10
Dst.Tables("table1").Rows.
' 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Next
vendortable.DefaultView.So
gvvendorname.DataSource = Dst.Tables("table1")
gvvendorname.Visible = True
gvvendorname.DataBind()
grid shows up with all of the correct headers but the datatable does not bind to it.
<asp:gridview id="gvvendorname"
autogeneratecolumns="False
autogenerateeditbutton="fa
visible = "false"
runat="server">
<columns>
<asp:TemplateField HeaderText="Vendor_ID">
<ItemTemplate>
<asp:TextBox ID="tbVendor_VendorId" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Vendor_Name">
<ItemTemplate>
<asp:TextBox ID="TextBoxVendor_name" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_address
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_address"
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_town">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_town" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_state">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_state" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_zip">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_zip" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_fax">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_fax" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_phone">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_phone" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_cell">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_cell" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_extensi
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_extensio
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_tin">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_tin" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_soc_sec
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_soc_sec"
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="vendor_email">
<ItemTemplate>
<asp:TextBox ID="TextBoxvendor_email" runat="server" ></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Vendor_Obsolet
<ItemTemplate>
<asp:DropDownList ID="dplvendorobsolete" runat="server" >
<asp:ListItem Selected="True"
Value="0">Select</asp:List
<asp:ListItem>YES</asp:Lis
<asp:ListItem>NO</asp:List
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Comment">
<ItemTemplate>
<asp:TextBox ID="TextBoxfromVendor_comm
</ItemTemplate>
</asp:TemplateField>
</columns>
</asp:gridview>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
don't know what I was thinking all of the rest of the web page has binding in it, totally spaced it.
I would also recommend explicitly building the datarow before adding to the table. It's more readable and easier to adjust as the number of columns or order changes.
dim newrow as datarow
newrow=Dst.Tables(0).newro
newrow.item("Vendor_Id")=i
newrow.item("type")="0"
Dst.Tables(0).rows.add(new