|
hi everyone,
I have a tab control with 3 tabs, A,B,C.
I have one one database "student" in which i have 4 columns.
There are two datagridviewB and datagridviewC in the two tabs B and C.
I am updating the entries of a datagridviewB by entering details in a form present in Tab A.
Now when I am working in tab C to update the datagridviewC, say for example filtering "student" database and displaying filtered results in datagridviewC; while updating datagridviewC, I noticed that datagridviewB in tab B also getting updated.
My code for filter "student" database in tab C is like this:
cmd = New SqlCommand("SELECT * FROM student WHERE [Name] <= '" + name + "'", con)
myDA = New SqlDataAdapter(cmd)
myDataSet = New DataSet()
myDA.Fill(myDataSet, "student")
datagridviewC.DataSource = myDataSet.Tables("student").DefaultView
Can someone tell me, how to update the datagridviewC in tab C without altering the entries present in datagridviewB in tab B?
FYI : my datagridviewB contains all the student data and in tab C i am filtering the database based on "Name" and displaying in datagridviewC.
|
|
|
|
|
I'd guess that they both have the same datasource. Make a copy of hte data source to bind to form C
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
So you get the same answer today as you got yesterday but from a different person.
Give each DGV its own datatable, not a copy, not a dataview filtered differently.
OR
Create a BindingSource for each DGV.
|
|
|
|
|
*sigh* how utterly frustrating. CP needs a popup that shows recent questions from the same poster.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Christian Graus wrote: CP needs a popup that shows recent questions from the same poster.
Wrong forum go here[^] please. 
Seriously tho would be nice to have that 
|
|
|
|
|
Thnaks Holmes. i am very new to this. Anyways, I dragged and added a "BindingSource" into my form and added a code like this:
cmd = New SqlCommand("SELECT * FROM client_details", con)
If con.State = ConnectionState.Closed Then con.Open()
myDA = New SqlDataAdapter(cmd)
myDataSet = New DataSet()
myDA.Fill(myDataSet, "client_details")
DataGridView1.DataSource = myDataSet.Tables("client_details").DefaultView
Can You please tell me how to add the bindingsource to this DatagridView1?
As you told , I have to create a BindingSource for each Datagridview; so if You can tell me how to bind this, then i can carry out my work for other datagridviews in my project.
thanks.
|
|
|
|
|
Set the DataSource property for each DataGridView to the corresponding BindingSource
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
You need to inject a BindingSource between the DataTable and the DataGridView
oBSClient = new BindingSource
oBSClient .DataSource = myDataSet.Tables("client_details").DefaultView
DataGridView1.DataSource = oBSClient
Then if you are using the same table you can create another BindingSource based on myDataSet.Tables("client_details") and bind that to the second DGV
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
It is throwing error as "Null object reference".
|
|
|
|
|
So debug through the code and find out which object is not being instantiated. You did remove the space I inadvertantly left in the declareation right!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have done this :
Dim myDataSet As New DataSet()
Dim newbinding As New BindingSource
newbinding.DataSource = myDataSet.Tables("clinet_details").DefaultView
DataGridView.DataSource = newbinding
while debugging i found following error in the 3rd line above:
"use the "new" keyword to create an object instance".
how to fix this?
|
|
|
|
|
Wich line - presumably when assigning the table which is not populated in this code.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
There's this dashboard application that we have, written in VB.NET. I have been given an assignment - to make the dashboard viewable from a web browser. I presume this means creating web forms to replace the Windows Forms. I think I'm pretty good with VB.NET, but I don't know the first thing about web forms. I know some very basic HTML, and I've dabbled with Tomcat & JSP, but I'm not even sure where to start reading up in order to learn what I need to accomplish the task at hand.
Can anyone point me in the right direction?
|
|
|
|
|
Buy a book on ASP.NET. Seriously, you've not going to get the background you need from a couple of forum posts and some badly written tutorials on the web.
|
|
|
|
|
why do Code project MVPs answers only easy questions or only refers books
|
|
|
|
|
You my friend are going to go far, but not as a developer, asking for a crash course in web development and then bitching that 2 MVPs point you at a book is really not the way to go.
People spend years studying and working on web development and you want it in a forum post, you even asked for a "course", what do you think a course is, idiot.
|
|
|
|
|
dont know for whom this post is
|
|
|
|
|
nowords4u wrote: dont know for whom this post is
I thought that was pretty obvious.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Actually, we just answer non-moronic questions. We like being asked hard questions. A question that requires we write a book in response is not hard, it's just lazy.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Blacklisted... Have a nice life.
Your boxx have given you a job to do. Instead of wasting your time bitching about the perfectly reasonable answers you were given, start studying an ASP.NET book. It appears you've wasted two days this weekend waiting for someone to do your research for you.
|
|
|
|
|
i_kant_spel wrote: I have been given an assignment - to make the dashboard viewable from a web browser
Why have you been given this task, if you have no clue how to do it. Does your boss know you don't know how to do it ? Is he an idiot ?
As someone else said, buy an ASP.NET book, your question is way too broad for an online forum.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I guess i knw How you become the MVP of Code project 60,000 posts hahahhahahaa , lmao 
|
|
|
|
|
It's a combination of writing articles, and helping people who ask real questions, as opposed to asking me to do their work for them. In the early days, the site only had real programmers on it. I miss those times.....
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
cool that is a very good answer i can expect from a MVP , i am clear now , i am impressed 
|
|
|
|
|
Amusingly, I could care less if you're impressed or not, but thanks all the same.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
