code for updating datatable. - C# Discussion Boards

gwithey31-Jul-09 1:27

31-Jul-09 1:27

I have tried this:

private void trackBar1_Scroll_1(object sender, MouseEventArgs m)
{
if (m.Button == MouseButtons.Middle)
{
label1.Text = trackBar1.Value.ToString();
}
}

but dont know if it will work as havent got it to compile because its complaining about the delegate

this.trackBar1.Scroll += new System.EventHandler(this.trackBar1_Scroll_1);

I dont know how to change it, it works with eventArgs but i put in mouseEventArgs which i need and it does not like it.

Re: Middle mouse click and scroll

Luc Pattyn31-Jul-09 1:38

Luc Pattyn

31-Jul-09 1:38

Hi,

you can't just change the partameter types; Scroll gives an EventArgs, not a MouseEventArgs.

you are aware of the Control.MouseWheel event? That one offers a MouseEventArgs.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Middle mouse click and scroll

Baeltazor31-Jul-09 7:35

Baeltazor

31-Jul-09 7:35

Thanks for that. You just answered my question too! lol Laugh | :laugh:

2 answers in 1!

Regards,
Jason Pezzimenti.

Re: Middle mouse click and scroll

gwithey2-Aug-09 20:51

gwithey

2-Aug-09 20:51

Thank you that was a silly thing to do.

This is the first time i have worked with events so will probably make a few mistakes along the way.

data synchronization between two client machine over the internet by Webservice?

Tridip Bhattacharjee31-Jul-09 0:41

Tridip Bhattacharjee

31-Jul-09 0:41

suppose a company has two branches in UK & US. say two windows client apps are there and they would like to transfer data to each other and their local data will be synchronozed with those data. so please guide me how can i develop a webservice which will work as a bridge and accept bulk data from client a and pass to client b vice versa. if i can get the concept then i can develop a good synchronization system by webservice. where webservice will play the role like bridge who can accept bulk data and also pass bulk data to other client.
please help me to accomplish this task.

Thanks in Advance

tbhattacharjee

Re: data synchronization between two client machine over the internet by Webservice?

Dave Kreskowiak31-Jul-09 4:51

Dave Kreskowiak

31-Jul-09 4:51

You may want to look into the MS Sync Framework[^] before you try developing your own sync services, which Web Services are not really suited for anyway.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

How to know toolbar got clicked through a BHO (C#)?

svt gdwl31-Jul-09 0:05

svt gdwl

31-Jul-09 0:05

In c#, How can I hook the IE wiindow.

Can I use Hooking API's in c#?

How to use these for getting the current printer settings when a print is given from an IE window?

similarly, How to know the handles of Navigation Toolbar on IE window through windows API's?

Totally, How can I hook each and every object on IE window through c#

code for updating datatable.

Omar Akhtar Sheikh30-Jul-09 23:46

Omar Akhtar Sheikh

30-Jul-09 23:46

// please anyone could help me write the update code

public DataTable GetCustomers()
                  {
                           string query = "SELECT * FROM Customer_2";
                           SqlDataAdapter da = new SqlDataAdapter(query, constr);
                           DataTable table = new DataTable();
                           da.Fill(table);
                           return table;

                  }

                  // For Inserting Customers
                  public void InsertCustomer(string customerName)
                  {
                           string query = "INSERT INTO Customer_2 (CustomerName) VALUES (@CustomerName)";
                           SqlConnection con = new SqlConnection(constr);
                           SqlCommand com = new SqlCommand(query, con);
                           com.Parameters.Add("@CustomerName", SqlDbType.NVarChar).Value = customerName;
                           con.Open();
                           com.ExecuteNonQuery();
                           con.Close();
                  }

                  // For Deleting Customers

                  public void DeleteCustomers(List&lt;int&gt; customerIDsToDelete)
                  {
                           string query = "DELETE FROM Customer_2 WHERE CustomerID = @CustomerID";
                           SqlConnection con = new SqlConnection(constr);
                           SqlCommand com = new SqlCommand(query, con);
                           SqlTransaction tr = null;

                           try
                           {
                                    con.Open();
                                    tr = con.BeginTransaction();
                                    com.Transaction = tr;
                                    com.Parameters.Add("@CustomerID", SqlDbType.Int);

                                    foreach (int item in customerIDsToDelete)
                                    {
                                             com.Parameters["@CustomerID"].Value = item;
                                             com.ExecuteNonQuery();
                                    }
                                    tr.Commit();
                           }
                           catch (Exception ex)
                           {
                                    tr.Rollback();
                                    throw ex;
                           }
                           finally
                           {
                                    con.Close();
                           }
                  }

// please anyone could help me write the update

Re: code for updating datatable.

Not Active30-Jul-09 23:51

Not Active

30-Jul-09 23:51

Write what update code? The C# or SQL? How about this[^]?

only two letters away from being an asset

Re: code for updating datatable.

Nagy Vilmos31-Jul-09 0:01

Nagy Vilmos

31-Jul-09 0:01

Wow! ur so rad man! i'd nvr thnk 2 bing!

Cool | :cool:

[NOTE THE JOKE ICON - the norm is to use google!]

Panic, Chaos, Destruction.
My work here is done.

Re: code for updating datatable.

PIEBALDconsult31-Jul-09 4:55

PIEBALDconsult

31-Jul-09 4:55

Never heard of them.

Re: code for updating datatable.

PIEBALDconsult31-Jul-09 4:54

PIEBALDconsult

31-Jul-09 4:54

Not that I use it myself, but: DataAdapter.Update

Re: code for updating datatable.

Adam R Harris31-Jul-09 8:05

Adam R Harris

31-Jul-09 8:05

Your using your DataAdapter all wrong.

It should be declared outside the scope of the GetCustomers(), so it can be accessed by all the other functions, and you should be using it to Create/Read/Updated/Delete.

How To Update a SQL Server Database by Using the SqlDataAdapter Object in Visual C# .NET[^]

NOTE: the code below has not been tested / probably wont compile because i cant spell

your code should look something like this;

// Dont know if this is going to be accessed outside of the class
// If so you might want to make a wrapper property for it
private SqlDataAdapter da;
// Should contain your data
private DataSet ds;

..... somewhere in your initialization code .....
da = new SqlDataAdapter("SELECT * FROM Customer_2", [YourConnectionString]);
da.UpdateCommand = [your update command];
da.DeleteCommand = [your delete command];
da.InsertCommand = [your insert command];

// dont return anything here, just fill the dataset
public void GetCustomers()
{
         da.Fill(ds);
}

// Saves all the changes to the database
public void SaveChanges()
{
         da.Update(ds, "[your table name]");
         // Accept the changes in the dataset
         ds.AcceptChanges();
}

Then all you need to do is Create/Update/Delete all the rows you want in the DataSet, just make sure you call SaveChanges().

Thats how your supposed to use the DataAdapters.

But if you still want to use it in the way that you are using it, your going to have to loop through all the rows in the DataTable and check if their RowState == DataRowState.Changed (i think, could be updated), then just run your update command against SQL.

If at first you don't succeed ... post it on The Code Project and Pray.

Re: code for updating datatable.

Omar Akhtar Sheikh31-Jul-09 8:27

Omar Akhtar Sheikh

31-Jul-09 8:27

Kindly would you please help me code the whole thing because it is urgent and I still want to do it my own way. Please help it is emergency, my daughter is in hospital, I have loads of tension on my mind due to her.

<code> // Dont know if this is going to be accessed outside of the class
                           // If so you might want to make a wrapper property for it
                           private SqlDataAdapter da;
                           // Should contain your data
                           private DataSet ds;

                           ..... somewhere in your initialization code .....
                           da = new SqlDataAdapter("SELECT * FROM Customer_2", [YourConnectionString]);
                           da.UpdateCommand = [your update command];
                           da.DeleteCommand = [your delete command];
                           da.InsertCommand = [your insert command];

                           // dont return anything here, just fill the dataset
                           public void GetCustomers()
                           {
                                       da.Fill(ds);
                           }

                           // Saves all the changes to the database
                           public void SaveChanges()
                           {
                                       da.Update(ds, "[your table name]");
                                       // Accept the changes in the dataset
                                       ds.AcceptChanges();
                           }
The following is the more code for deleting from my datagridview for removal not only from datagridview but also from database as well.

List<int>customerIDsToDelete = new List<int>();

            private void btnDELETE_Click(object sender, EventArgs e)
            {
                  // Iterate all the Rows in DataGridView Rows Collection
                  foreach (DataGridViewRow row in dataGridView1.Rows)
                  {
                        // Get the status of CheckBox in the current Row
                        bool deleteStatus = Convert.ToBoolean(row.Cells[0].Value);

                        // Get the CashierID of the Cashier in the current row
                        int customerID = Convert.ToInt32(row.Cells[1].Value);

                        if (deleteStatus)
                        {
                              row.Selected = true;
                              customerIDsToDelete.Add(customerID);
                        }
                  }

                  // Remove From DataGridView

                  foreach (DataGridViewRow selectedRow in dataGridView1.SelectedRows)
                  {
                        dataGridView1.Rows.Remove(selectedRow);
                  }

                  // Remote From Database

                  DALHelper dal = new DALHelper();
                  dal.DeleteCustomers(customerIDsToDelete);

                  customerIDsToDelete.Clear();

                  // Load Cashiers from Database

                  LoadCustomers();

            }

</code>

Re: code for updating datatable.

Adam R Harris31-Jul-09 9:16

Adam R Harris

31-Jul-09 9:16

Sigh ... you are never EVER EVER going to get someone to write your project for you on here.
Regardless of your situation, sorry to hear, we all have our own problems and trying to play on our hearts is probably just going to piss more people off than anything.

I would "write" this code for you, but it seems Microsoft already has.
Case in point[^]

If at first you don't succeed ... post it on The Code Project and Pray.

[Message Deleted]

Omar Akhtar Sheikh31-Jul-09 11:56

Omar Akhtar Sheikh

31-Jul-09 11:56

[Message Deleted]

Re: code for updating datatable.

Adam R Harris31-Jul-09 12:14

Adam R Harris

31-Jul-09 12:14

Go f*** yourself

If at first you don't succeed ... post it on The Code Project and Pray.

Problem in Filter Grid

SwastikInfosystems30-Jul-09 23:29

SwastikInfosystems

30-Jul-09 23:29

Hi,
I am facing a problem with GridViewExtension_Demo,the problem is that every time the page is being loaded the filter grid is shaking.
Please fix my problem as soon as possible and send me the report.
I am giving the URL from where I get GridViewExtension.

DataGrid with built-in filter functionality[^]
Piyali Chowdhury

Re: Problem in Filter Grid

OriginalGriff30-Jul-09 23:54

OriginalGriff

30-Jul-09 23:54

Two things:
1) Try being a little more patient. Posting the same request every twelve minutes is a sure way to get people annoyed with you.
2) At the bottom of the article is a list of messages associated with just that article. Trt posting your question there; the author will then (probably) get an email describing your problem.

Remember (1) when doing (2)!

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: Problem in Filter Grid

stancrm30-Jul-09 23:55

stancrm

30-Jul-09 23:55

???

You can download the source code, then you can fix it...
Try to contact the author...

Re: Problem in Filter Grid

Nagy Vilmos30-Jul-09 23:59

Nagy Vilmos

30-Jul-09 23:59

ASk this question in the article's forum [at the bottom], that way you have more chance of a kidly response.

Panic, Chaos, Destruction.
My work here is done.

Problem in Filter Grid

SwastikInfosystems30-Jul-09 23:17

SwastikInfosystems

30-Jul-09 23:17

Re: Problem in Filter Grid

Vimalsoft(Pty) Ltd31-Jul-09 0:06

Vimalsoft(Pty) Ltd

31-Jul-09 0:06

1) You are Rude and disrespectfull

2) We cannot do your job for you, you should be Fired with that attitude

3)In this Forum we help people who started something and get stucked, we don't do homework here

4) I wanted to swear at you , but i think the only thing i will do for you is to pray for you

God have mercy on you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

give me a code for disable keyboard functions this project............ [modified]

Member 423560130-Jul-09 22:28

Member 4235601

30-Jul-09 22:28

using c# to disable keyboard functions 2(or)x minutes, At the time of loading desktop.

(or)

disable the shortcut keys (Task manager,windows,Alt+Tab,Esc - all these) At the time of loading desktop.

After 2 minutes finished normal changes appearing for all.

Important : Anybody not able to create those top mentioned functions,used another way to give the code.

usage of project: i am security purpose to create it.It is protect copy of image typed files, and as boot partition files only.i am simply to create it.but i have no idea for this.

Anybody can help to create mentioned functions to send it. i am already posted my doubts but somebody answered,u try to create virus, malware something....

But i frankly told to for all,i don't think in my mind this type of creating. so i am repeat to briefly post my doubt.

Re: Add to disable keyboard functions this project............

OriginalGriff30-Jul-09 23:16

OriginalGriff

30-Jul-09 23:16

Read the istructions at the top - how to get an answer.
No one is going to wade through that much unformatted code (use <pre></pre> to preserve your formatting) to see if they can work out what you are going on about.
Try cutting it down to a reasonable size (not umpteen pages)
Try using meaningfull names: menuItem14 is not as description as miStartInternetExplorer - again this make it easier for us to read.

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.