DataGridview Problem

Question

I have three column in my datagridview .One is text ,one is Combo and another one is Text ...i dont want to use datasource want to add values on cell like datagridview.Rows[].cells[].value. Help me how i can do it? My database have several columns...How to add column value dynamically....

Answer 1

I would highly recommend to use a Repeater instead of datagridview and render as many columns as you want.

.aspx code

<tr>
    <asp:Repeater ID="rptDayHeaders" runat="server">
        <ItemTemplate>
            <td>
                <strong><asp:Literal ID="ltMonthHeader" runat="server"></asp:Literal></strong>
            </td>
        </ItemTemplate>
    </asp:Repeater>
</tr>

.aspx.vb code

rptDayHeaders.DataSource = daysList
rptDayHeaders.DataBind()

where dayslist needs to be an array of the number of columns you want.

We have used the same approach to generate a complete Gantt Chart

Answer 2

Try something along the lines of

dataGrid.Rows.Add(new object[] { "value1", 42, "value3"});

Answer 3

I just had to do the same exact type of thing...here is how you add a column.

If Not IsPostBack Then
Dim field As New TemplateField
field.HeaderText = "Name of Column"
Dim col As DataControlField = field
GridView.Columns.Add(col)

End If

**In the Gridview_rowcreated Sub

e.row.cells(cellnumber from 0 to N).controls.Add(data) you're going to have to create a connection and a connection string

here is an example...

Dim Dbconn As SqlConnection
Dim Dbcmd As SqlCommand

Dbcmd = New Data.SqlClient.SqlCommand() Dbcmd.Connection = Dbconn Dbcmd.CommandType = Data.CommandType.Text

Dbcmd.Commandtext = "select * from table" dbconn.open()

'then you need a data reader

dim dr as sqlclient.sqldatareader
dr = dbcmd.executereader
while dr.read
add each item to a list
end while

then on page load set your datasource of the grid to the list

hope this helps...if you have any questions just ask me.