How can I increase Datagrid row and column without binding it to a database. Again how can I bind Textbox control to datagrid such that I can Type in Datagrid cell using VB.Net

Below is a breif guide on how you can bind a textbox to a datagrid,

set your AutoGenerateColumns="False" -- eg

<asp:datagrid id="dgResult" Runat="server" AutoGenerateColumns="False">

then define the textbox:

<asp:TemplateColumn HeaderText="Period Control Begin">
	<ItemTemplate>
	                 <asp:TextBox ID="txt1"  Runat="server"></asp:TextBox>
               </ItemTemplate>
</asp:TemplateColumn>

To bind (database) table column to textbox, in the textbox definition set:

Text='<%# DataBinder.Eval(Container.DataItem,"PutNameOfColumnHere" %>'

You can reference the TextBox from the code behind as follow:

dim txtBox as TextBox
  Dim dgItem As DataGridItem
Dim str as string

'Loop through to read from each textbox on every row of datagrid
For Each oDataGridItem In Me.dgResult.Items
         txtBox = CType(dgItem.FindControl("txt1", TextBox)    
         'You can now use your texbox like you will normally do e.g
         str1 = txtBox.Text
Next

I hope this will help,
You can also search on google for more help,
Let me know if this was of any help

Thanks for ur kind help. I don't want to bind it to any database. I want to fetch data myself and put it in datagrid just like the way one can do in MSHLfexgrid of Vb 6.0 which will enable me increase the rows and columns at my own wish. They need for binding textbox to it is to enable me type into its cells.

For MSHFlexgrid if you want to add more column you just say <Name>.cols=12 or so. But have tried it in datagrid noway.

I think you now know what I need.

- Am not quite familiar with MSHFlexgrid

Let me clarify though, You are not actually binding to the database, but you are binding (including your textbox) to a dataset (or resultset returned - in memory). This means that you will not only have the textbox to input data, you can also prepopulate the textbox if needed.

For example

dim sConn as String
dim conn as SqlConnection
dim ds as DataSet
dim cmd as SqlCommand
dim da as SqlDataAdapter

sConn = "Server=yourserver;Database=db1;uid=userid;pwd=password;Connect Timeout=1000"
conn = new SqlConnection(sConn)
conn.Open
cmd  = new cmd("select * from table1", conn)
ds = New DataSet("Plans"
da = New SqlDataAdapter(cmd)
da.Fill(ds, "Table1"

Me.dgResult.DataSource = ds.Tables("Table1"
Me.dgResult.DataBind()

@rookie
If he talks about any of the flexgrid, it means he is using nothing beyond VB6 as those activeX controls are not in .Net.
He doesn't want anything to do with database, so nothing about ADO or ADO.Net should appear in the solution that addresses his problem precisely.

@LuckyCO
I've always used DataGrid in VB6 just to display read only records returned from a query and any of the flexgrid when I needed to edit on the grid.  I'm trying to find where I read (or got an indication) that Datagrid is read-only (and without that capability of flexgrid which I've tried out and found impossible too) so that I can be sure of what I'm saying. Check your installed MSDN library(online version seems different and unhelpful), I would have but I had problem with NEPA (prefer that name to PHCN ) last night. If I find anything I'll call your attention to it.
Move on to .Net (from your contributions elsewhere in this forum I believe you are already looking into it) , there you'll find all capabilities packed into a single control (datagridview).

parosky
I think you are the one that understands my posting my posting properly. I need to make that readonly property of Datagrid to be readwrite such that I can change the rows and columns anytime I want and put data in any cell . For vb6.0 I used either Msflexgrid or MSHflexgrid. But thinking of .net I dont feel ok using COM property.

That is why I want to know whther I can make the Datagrid editable
Thanks

@LuckyCO

Well, I'll let you know if I find anything concrete.

luckyCO:

But thinking of .net I don't feel ok using COM property.

That is why I want to know whther I can make the Datagrid editable
Thanks

Meanwhile, in .Net, you don't have any business with COM as regards the issue at hand, or do you mean creating and using objects (as in OOP). It may not be as cumbersome as you think. If you need any help, esp. as regards datagridview or whatsoever let's know.

Again how can I bind Textbox control to datagrid such that I can Type in Datagrid cell using VB.Net

That statement threw me off.
anyhow, sorry I wasn't of too much help, Goodluck

Don’t know if you figured a way round your problem yet, but regards to your question, what you need to first understand is a datagrids data source, which could be a database, an xml file, a dataset, datatable, or collection object. When you learn to manipulate a datagrids data source you manipulate the data the grid displays.

First of all I’m assuming you’re talking about windows application datagrid not web, and you’re working with VS02 or 03 and .net framework 1.x.

So to programmatically add create and add data to a datagrid look at the following example.
Add a datagrid on a form and add this code in the load event of the form;


        'Create DataTable
        Dim dt As New DataTable("MyFavoriteArsenalPlayers"
        'Create and add Colums
        Dim tColumn As DataColumn
        tColumn = New DataColumn("ShirtNo", System.Type.GetType("System.Int16")
        dt.Columns.Add(tColumn)

        tColumn = New DataColumn("FirstName", System.Type.GetType("System.String")
        dt.Columns.Add(tColumn)

        tColumn = New DataColumn("LastName", System.Type.GetType("System.String")
        dt.Columns.Add(tColumn)

        'Create rows and add row data
        Dim row As DataRow

        row = dt.NewRow
        row("ShirtNo" = 4
        row("FirstName" = "Cece"
        row("LastName" = "Fabregas"
        dt.Rows.Add(row)

        row = dt.NewRow
        row("ShirtNo" = 11
        row("FirstName" = "Robin"
        row("LastName" = "Van Perise"
        dt.Rows.Add(row)

        row = dt.NewRow
        row("ShirtNo" = 13
        row("FirstName" = "Aliaksandr"
        row("LastName" = "Helb"
        dt.Rows.Add(row)

        DataGrid.DataSource = dt

‘****************************************************

To Delete rows from the Datagrid use this code
dt.Rows.RemoveAt(i)

where “i” is the index of the row you want to remove. And I hope you see that I’m not maniputating the datagrid per say, but its data source.

Also you said how can I bind a textbox to a datagrid, I guess u meant how to manipulate a datagrid cell. You can do that using the following code.

Add a button control to the form and add this code in its click event;

        DataGrid1.Item(2, 1) = "Alexandra"
OR
Or you edit the cell within the datasource itself:

        Dim dt As DataTable
        dt = DataGrid1.DataSource
        dt.Rows(2)("FirstName" = "Alexandra"

To bind a datasource to a Textbox look and the following code snippet;
Add a 3 textboxes on a form and add this code in the load event of the form;

  'Create DataTable
        Dim dt As New DataTable("MyFavoriteArsenalPlayers"
        'Create and add Colums
        Dim tColumn As DataColumn
        tColumn = New DataColumn("ShirtNo", System.Type.GetType("System.Int16")
        dt.Columns.Add(tColumn)

        tColumn = New DataColumn("FirstName", System.Type.GetType("System.String")
        dt.Columns.Add(tColumn)

        tColumn = New DataColumn("LastName", System.Type.GetType("System.String")
        dt.Columns.Add(tColumn)
        'Create rows and add row data
        Dim row As DataRow

        row = dt.NewRow
        row("ShirtNo" = 4
        row("FirstName" = "Cece"
        row("LastName" = "Fabregas"
        dt.Rows.Add(row)

        row = dt.NewRow
        row("ShirtNo" = 11
        row("FirstName" = "Robin"
        row("LastName" = "Van Perise"
        dt.Rows.Add(row)

        row = dt.NewRow
        row("ShirtNo" = 13
        row("FirstName" = "Aliaksandr"
        row("LastName" = "Helb"
        dt.Rows.Add(row)

' make sure nothing is binded already
        TextBox1.DataBindings.Clear()
        TextBox2.DataBindings.Clear()
        TextBox3.DataBindings.Clear()

  ' bind the data to the textboxes
        TextBox1.DataBindings.Add("Text", dt, "FirstName"
        TextBox2.DataBindings.Add("Text", dt, "LastName"
        TextBox3.DataBindings.Add("Text", dt, "ShirtNo"
‘*************************************************************
‘Run the app

Now when you bind data to a textbox you can only view one row at a time, to move to the next row you have to move the bindingcontext position to do that you have to create a CurrencyManager Object. (odd name but it has nothing to do with money) Example;

Add a button control to the form and add this code in its click event;

   
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim PositionManager As CurrencyManager
        PositionManager = CType(Me.BindingContext(dt), CurrencyManager)
        PositionManager.Position = PositionManager.Position + 1

    End Sub
You will have to make dt a global variable for this section to work.

Now the CurrencyManager’s Position property get's and set's the row position, so you add 1 to move forward and subtact 1 to move backwards.

I hope this helps you but there are lots of other ways you can do this, but they are all easy to understand just take your time.

Thanks I shall try that.