how i can insert more than one rows into more than one tables?? ( in one mehtod ) when user click 'Send Message Button'

Question

hi all , i want to know how i can insert many rows into many tables in one method , such as the following Scenario : 1 - if u want to send compose message to more than one Receiver , u select more than receiver( Receiver table) , and attach more than Files ( File Table) ...... etc , in one method . how ?? any example? plz im new programmer

Kirtan Patel · Answer

Hi , You can do it Using Store forexample usernames retrieved from database in Array or generic collection like List like below code is what i have coded as per your requirement. in Most of code i have explained what the code does but if you still not get you are welcome to ask Question :) .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: Consolas, "Courier New", Courier, Monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; } private void button1_Click( object sender, EventArgs e) { List string > UsersList = new List string >(); SqlConnection con = new SqlConnection( @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True" ); con.Open(); SqlCommand comm = new SqlCommand( "select Username from Users" , con); SqlDataReader reader = comm.ExecuteReader(); //Clear the UserList before Filling new UsersList.Clear(); //Loop through all The users and Add Them to list For Sending while (reader.Read()) { UsersList.Add(reader[ "Username" ].ToString()); } // Now Execute insert Query on All Usernames in List foreach ( string user in UsersList) { comm = new SqlCommand( "Insert into Users(Username,Message) values('" + user + "','testmsg')" , con); comm.ExecuteNonQuery(); } //Finaly Close the Connection con.Close(); }

abas shahen · Answer

thank u aloooooooooooooooooooooot :) ur great man thank u again , i dont know how i can make u happy ?

Kirtan Patel · Answer

you are welcome my friend :) It depends on situation what to use From DataReader , Dataset Data Reader just Goes into One Direction when iterating through record and need Database Connection Open when Performing Operation while data set has several advantages over data reader like it can move in both direction in records Forward and backward and no need Database Connection once after data set is filled But When you have to do small task like no more operation that can round trip the Database you can use DataReader But When Performing Search on Database You should avoid using DataReaders Thank you :)

abas shahen · Answer

Really , ur answer was very very help ful and clear thank u alot , man i have another and final question : u advice me to use Data Reader or DataSet in ur example ?? and whic Better Dataset or xml ?? i dont like to use xml , its good to use dataset?