VB.Net Datagridview Datasource v/s SQL Query Problem

Question

0.00/5 (No votes)

See more:

Respected Sir,

I am using

datagridview.datasource=datatable.copy
to populate data which has no linking datasource at all.

In that case, why am I unable to edit a cell ?

1) Below Query Let Not Change the VB.Net Datagridview Cell Content:

strSQL = "Select Row_Number() Over (Order By A.Id) As SN, A.Id, A.Face As [Object Name],B.Visi,B.AddNew,B.Edit,B.Del,B.Prnt,B.Reg,B. XL,B.Txt,B.Email from MSG_URightMaster A " strSQL = strSQL & "Left Join MSG_URight B On A.Id=B.RightId Where B.UserId='" & flxGroup(flxGroup.Row, 1) & "' "

2) I have also used below query which is perfect and I am able to change any cell content:

DIM strSQL as string Below Query Let Change the VB.Net Datagridview Cell Content: strSQL = "Select Row_Number() Over (Order By A.Id) As SN, A.Id, A.Face As [Object Name], " strSQL = strSQL & "(Select B.Visi From MSG_URight B Where A.Id=B.RightId And B.UserId='" & flxGroup(flxGroup.Row, 1) & "') As Visi, " strSQL = strSQL & "(Select B.AddNew From MSG_URight B Where A.Id=B.RightId And B.UserId='" & flxGroup(flxGroup.Row, 1) & "') As AddNew, " strSQL = strSQL & "(Select B.Edit From MSG_URight B Where A.Id=B.RightId And B.UserId='" & flxGroup(flxGroup.Row, 1) & "') As Edit, " strSQL = strSQL & "(Select B.Del From MSG_URight B Where A.Id=B.RightId And B.UserId='" & flxGroup(flxGroup.Row, 1) & "') As Del, " strSQL = strSQL & "(Select B.Prnt From MSG_URight B Where A.Id=B.RightId And B.UserId='" &a
mp; flxGroup(flxGroup.Row, 1) & "') As Prnt, " strSQL = strSQL & "(Select B.Reg From MSG_URight B Where A.Id=B.RightId And B.UserId='" & flxGroup(flxGroup.Row, 1) & "') As Reg, " strSQL = strSQL & "(Select B.XL From MSG_URight B Where A.Id=B.RightId And B.UserId='" & flxGroup(flxGroup.Row, 1) & "') As XL, " strSQL = strSQL & "(Select B.Txt From MSG_URight B Where A.Id=B.RightId And B.UserId='" & flxGroup(flxGroup.Row, 1) & "') As Txt, " strSQL = strSQL & "(Select B.Email From MSG_URight B Where A.Id=B.RightId And B.UserId='" & flxGroup(flxGroup.Row, 1) & "') As Email " strSQL = strSQL & "From MSG_URightMaster A Order By A.ID "

I am so confused. Could you please advise why?

Kindly suggest to me what's the problem between queries that I am not able to change cell content.

Regards-
Sanjeeb</pre>

Posted 31-Mar-14 23:02pm

Sanjeeb38

Add a Solution

Comments

Thava Rajan 1-Apr-14 6:27am

please edid your question and post in the code tag then only we will able to analyse your code

dimpledevani 1-Apr-14 9:40am

Try Datatable dt1=datatable.copy;
grid.DataSource=dt1;

1 solution

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)

Terence Wallace · Answer 1 · 2014-04-01T04:38:00

Solution 1

My question, to further understand your question, would be why are you copying the table. My experience is to just bind to a new instance.

VB

Dim dt as New DataTable
dt = datatable

grid.Datasource = dt

That should allow a read/write instance for manipulation purposes.

Posted 1-Apr-14 4:38am

Terence Wallace

Comments

Sanjeeb38 4-Apr-14 0:02am

Dear Sir,

This approach is bound mode.

And I want to work in unbound mode.

There is even a method in unbound mode i.e populating every rows one-by-one which is very slow in case of millions of records.

If possible, please help me to achieve the output I required.

Regards-
Sanjeeb