473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

BindingSource equivalent in C#.NET?

294 256MB
Hello, all.

I'm attempting to create a search box using C#.NET. Thus far, I've got this code:

Expand|Select|Wrap|Line Numbers
  1.  protected void SearchBox_TextChanged(object sender, EventArgs e)
  2.         {
  3.             DataView DV = new DataView(dbDataSet);
  4.             DV.RowFilter = string.Format("CourseNum LIKE '%(0)%'", SearchBox.Text);
  5.             dataGridView1.DataSource = DV;
  6.  
  7.  
  8.         }
  9.  
  10.         protected void Button1_Click(object sender, EventArgs e)
  11.         {    
  12.              string error = "Error";
  13.              string constring = ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString; 
  14.             SqlConnection conDataBase = new SqlConnection(constring);
  15.             SqlCommand cmdDataBase = new SqlCommand(" select * from ASPNETDB.CourseNum ;", conDataBase);
  16.  
  17.             try{
  18.                 SqlDataAdapter sda = new SqlDataAdapter();
  19.                 sda.SelectCommand = cmdDataBase;
  20.                 DataTable dbdataset = new DataTable();
  21.                 sda.Fill(dbdataset);
  22.                 BindingSource bsource = new BindingSource();
  23.  
  24.                 bsource.DataSource = dbdataset;
  25.                 dataGridView1.DataSource = bsource;
  26.                 sda.Update(dbdataset);
  27.             }catch(Exception ex){
  28.  
  29.                 ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + error + "');", true);
  30.             }
In C#.NET, there is no such thing as "BindingSource" so I am kind of stuck in a rut. I deleted the Gridview and replaced it with a FormView, however I am not sure where to go from here as far as the code goes. Does anyone have any guidance?

Thanks.
Nov 11 '13 #1
0 984

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: silesius | last post by:
Hi All, I have two pagetabs. One pagetab is used to display a parent record and the other is suppose to display 3 related child records from another table. I can display the parent records just...
1
by: TN | last post by:
I just don't get the BindingSource class when it is bound to a class. Consider this code snip: ..... Private bSource As New BindingSource() Private dgv As New DataGridView() Public Sub New()...
0
by: Geoff | last post by:
Hi folks Calling BindingSource.ResetCurrentItem() is changing the BindingSource.Position in a way I don't understand. If I'm understanding the docs correctly, ResetCurrentItem() should simply...
5
by: Rob Dob | last post by:
Hi, I have two c# Winforms. the first form has a datagridview who's datasource is a bindingsource. when you double click on a datagridview row it then opens my second form, which has some...
4
by: shibeta | last post by:
Hello, I have problem with DataGridView and BindingSource. I have created DataSet and added TableData to it with manualy created columns (without DataAdapter - I'm not using MSSQL). On the Form I...
7
by: Mike | last post by:
i have a small difficulties with BindingSource and dataGridView bind db has properly opened and bind doesn't works. Unfortunately I didn't find any good example how to connect MS Access with...
0
nev
by: nev | last post by:
Hello all. I would like to place code when bindingsource is being filtered. I have tried placing it in the positionchanged and listchanged event. But, when I try to filter the bindingsource, it...
2
by: jehugaleahsa | last post by:
Hello: I'm working on improving some of our Windows Forms. I have created two user controls that I want to bind to the same BindingSource. I have an overview control that is used just to...
5
by: jehugaleahsa | last post by:
Hello: I am sure this question comes up a lot. I need to disable the controls on my Windows forms so that when the BindingSource is empty some the controls bound to it will be disabled. This...
2
by: TamusJRoyce | last post by:
I am working on a group project where I do not have access to a BindingSource that is being passed through a function. The BindingSource's DataSource is set to a custom IBindingListView Collection....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.