In datagridview auto generate its value

Question

0.00/5 (No votes)

See more:

Hi, Its possible for auto generate specific column values in datagridview?
Example: There are two tables(first,second) to link with separate forms. First and second table some fields may equal values. Second table can be connect with datagridview. In datagridview specific fields(same) values can be automatically generated (values from first table).
Its possible in datagridview ?

Posted 27-Nov-11 23:19pm

ckulasekaran

Add a Solution

Comments

[no name] 28-Nov-11 5:32am

please clarify the question so we could help immediately.

ckulasekaran 28-Nov-11 7:51am

how to retrieve data from other database table to datagridview

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anuj Banka · Answer 1 · 2011-11-28T02:38:00

Solution 1

While fetcing the data from database you can use joins to get data from diffrent tables.

Or in datalayer you can create the data source using LINq or creating whatever datatable structure values you want

Posted 28-Nov-11 2:38am

Anuj Banka

**Manoj K Bhoir** · Answer 2 · 2011-11-28T03:59:00

You can not automatically generate values in DataGridView.
You can achive this by writting some queries releted your database.

Check this :

VB

Public Function AutoID(ByVal fieldname As String, ByVal table As String)
        objda.SelectCommand.CommandText = "select max(cint(mid(" & fieldname & ",4,len(" & fieldname & ")))) as maxval from " & table
        Try
            Dim maxId As Object = objda.SelectCommand.ExecuteScalar
        Catch ex As Exception
            MessageBox.Show(ex.ToString)
        End Try
        If maxID Is DBNull.Value Then                       'If Database Table is Empty
            Return 1                                        'Set Enquiry Id 1
        Else
            Try
                dr = objda.SelectCommand.ExecuteReader      'Execute Query
            Catch ex As Exception
                MessageBox.Show(ex.ToString)                'Providing Error Message
            End Try
            If dr.Read Then                                 'Read dr
                If dr(0) Is DBNull.Value Then               'Converting dr value to String
                    Return 1                                'Set Id to 1
                Else
                    Return (dr(0) + 1)                      'Increasing ID by 1
                End If
            End If
            dr.Close()                                      'Closeing data reader
        End If
    End Sub

How to Use : Call it on Form_Load event

VB

txtIdFiled.Text=AutoID("FieldName", "TableName")   'Generating Auto EnrollmentId