After Databind Previews record are deleted

Question

0.00/5 (No votes)

See more:

Actually now i am working in Datagrid.

i am trying to bind a records.

First time record binding properly displayed but 2 time record is binding 1st record was deleted.
I want to add 2nd record.

if i try 3 time binding need to add 3 row and i am binding through sql Query.
Query is working fine. i am getting data to datatable also.

If any one Help me..

VB

public dt As DataTable

VB

Private Sub btnADD_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnADD.Click
       Dim sql As String = "select * from court where courtid='" & ddlfromsec.SelectedValue & "'"
       dt = class.Bysql(sql)
       If dt.Rows.Count > 0 Then
           dg1.DataSource = dt
           dg1.DataBind()
       End If
   End Sub

I will Change ddlfromsec.SelectedValue. first time one value, 2nd line one value like that.

Posted 14-Mar-13 23:58pm

nane aa

Updated 15-Mar-13 23:38pm

v5

Add a Solution

Comments

frostcox 15-Mar-13 6:08am

Can you show you code so I can see whats going on

Nelek 15-Mar-13 9:23am

Question was updated with code, you can check

nane aa 15-Mar-13 6:28am

Check Now.

frostcox 15-Mar-13 10:35am

CHill60 is right, you are always only going to return 1 record with your SQL query, you need to change this and your code will be fine.

Chinmaya C 16-Mar-13 13:07pm

Dim sql As String = "select * from court where courtid='" & ddlfromsec.SelectedValue & "'"

As per my understanding form the posted code, you are applying equal operator on primarykey field (courtid), it always returns only one record, and thus shows only one record everytime.

try with the following:

Dim sql As String = "select * from court"

nane aa 18-Mar-13 2:57am

Thank You for u r Reply..
Actually After button click page is again loading that time public variable also refreshed it was not storing anything. That’s way I am taking hiddenfield in front end, After button click ddlfromsec.Selectedvalue values stored in hiddenfield. I changed query like that
select * from court where courtid in("& hiddenfield.value &")
Now i am getting all previous values also..

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)

CHill60 · Answer 1 · 2013-03-15T02:29:00

Solution 1

You're creating a new datatable each time so it will only contain a single row.
Either just add rows to the dgv instead of using databinding
or
Don't create a new datatable each time and add rows to a datatable defined outside the sub

Posted 15-Mar-13 2:29am

CHill60

Comments

nane aa 16-Mar-13 5:39am

OK.. I given dt in public now but i am getting same problem.. dt rows are deleted..

CHill60 18-Mar-13 6:48am

ADD rows to a datatable not just define the datatable outside the sub. However using the IN clause as per your last comment also works