C#

FirstPrevNext

Fighting with ADO.NET Mazdak19-Mar-02 23:20 Mazdak 19-Mar-02 23:20  Its a kind of reposting,but forgive me because of that. I read some MSDN doc but I didin't get anything.When I add record to dataset for updating dataadapter I have to use Update() method,but it force me to use UpdateCommand,but I did not modify any record,I add record.so why it force for that?OleDbCommandBuilder does not make insert and update command for me automaticly Does anybody know any sample about it?Of cource not MSDN samples. Thanks Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Serialization (save and loading) BLaZiNiX19-Mar-02 14:00 BLaZiNiX 19-Mar-02 14:00  I created an application that Store an ArrayList (of file and file data) in a File using Serialization with BinaryFormater. What I want to do it's to load each filepath stored in the file I created with the Serialization and create the path. After the path is created I want to store the data of the equivalent file that is store in the file I created with the Serialization in the new file I created in the loading process. My problem is here : using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.IO; using System.Text; using System.Runtime.Serialization; using System.Runtime.Serialization.Formatters.Binary; namespace MultipleFile { /// /// Summary description for Form1. /// public class Form1 : System.Windows.Forms.Form { private System.Windows.Forms.Button button1; private System.Windows.Forms.Button button2; private ArrayList r,w,data,read,n,m; private BinaryFormatter a,b,c; private StreamReader reader; private StreamWriter sr; private string path,content,npath; private System.Windows.Forms.Button button3; private System.Windows.Forms.Button button4; /// /// Required designer variable. /// private System.ComponentModel.Container components = null; public Form1() { // // Required for Windows Form Designer support // InitializeComponent(); r = new ArrayList(); w = new ArrayList(); data = new ArrayList(); read = new ArrayList(); a = new BinaryFormatter(); b = new BinaryFormatter(); c = new BinaryFormatter(); // // TODO: Add any constructor code after InitializeComponent call // } /// /// Clean up any resources being used. /// protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows Form Designer generated code /// /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InitializeComponent() { this.button1 = new System.Windows.Forms.Button(); this.button2 = new System.Windows.Forms.Button(); this.button3 = new System.Windows.Forms.Button(); this.button4 = new System.Windows.Forms.Button(); this.SuspendLayout(); // // button1 // this.button1.Location = new System.Drawing.Point(32, 20); this.button1.Name = "button1"; this.button1.TabIndex = 0; this.button1.Text = "Open"; this.button1.Click += new System.EventHandler(this.button1_Click); // // button2 // this.button2.Location = new System.Drawing.Point(32, 52); this.button2.Name = "button2"; this.button2.TabIndex = 1; this.button2.Text = "Create"; this.button2.Click += new System.EventHandler(this.button2_Click); // // button3 // this.button3.Location = new System.Drawing.Point(32, 88); this.button3.Name = "button3"; this.button3.TabIndex = 2; this.button3.Text = "Write"; this.button3.Click += new System.EventHandler(this.button3_Click); // // button4 // this.button4.Location = new System.Drawing.Point(32, 120); this.button4.Name = "button4"; this.button4.TabIndex = 3; this.button4.Text = "Test"; this.button4.Click += new System.EventHandler(this.button4_Click); // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(128, 158); this.Controls.AddRange(new System.Windows.Forms.Control[] { this.button4, this.button3, this.button2, this.button1}); this.Name = "Form1"; this.Text = "Form1"; this.ResumeLayout(false); } #endregion /// /// The main entry point for the application. /// [STAThread] static void Main() { Application.Run(new Form1()); } private void button1_Click(object sender, System.EventArgs e) { OpenFileDialog o = new OpenFileDialog(); o.Filter = "All Files (*.*)|*.*"; if(o.ShowDialog() == DialogResult.OK) { r.Add(o.FileName); reader = new StreamReader(o.FileName); string text = reader.ReadToEnd(); data.Add(text); } } private void button2_Click(object sender, System.EventArgs e) { Stream s = File.Open("D:\\path.dat",FileMode.Create,FileAccess.ReadWrite); a.Serialize(s,r); Stream ss = File.Open("D:\\data.dat",FileMode.Create,FileAccess.ReadWrite); b.Serialize(ss,data); s.Close(); ss.Close(); } --->> private void button3_Click(object sender, System.EventArgs e) { Stream s = File.Open("D:\\path.dat",FileMode.Open,FileAccess.Read,FileShare.None); w = (ArrayList)a.Deserialize(s); foreach(string i in w) { MessageBox.Show(i); } Stream ss = File.Open("D:\\data.dat",FileMode.Open,FileAccess.Read); w = (ArrayList)a.Deserialize(ss); foreach(string d in w) { MessageBox.Show(d); } s.Close(); ss.Close(); } private void button4_Click(object sender, System.EventArgs e) { Stream s = File.Open("D:\\test.dat",FileMode.Open,FileAccess.Read); w = (ArrayList)b.Deserialize(s); read = (ArrayList)b.Deserialize(s); s.Close(); } } } can you copy this code and try it and you will see what I mean. I want to replace the button3_onclick event where the MEssageBox are with a File Creation and data transfer to the new file created... and I want to create it in ONE file (store the data and the file path in the same file not in two separate files) Thanks a lot, thanks thanks thanks Jonathan Pouliot Re: Serialization (save and loading) Andres Manggini19-Mar-02 14:34 Andres Manggini 19-Mar-02 14:34  I haven't run the code, but why don't you just do something like this ? Stream s = File.Open("D:\\path.dat",FileMode.Create,FileAccess.ReadWrite); a.Serialize(s,<<whatever>>); b.Serialize(s,<<whatever>>); Wouldn't that work ?. Andres Manggini. Buenos Aires - Argentina. Re: Serialization (save and loading) BLaZiNiX19-Mar-02 15:32 BLaZiNiX 19-Mar-02 15:32  yes that's work, the first BinFormater (a) will store the path and the second (b) will store the data of each files I'm ok for the Storing(Save) but my problem is when I want to Deserialize the file to take the data from the (a) to create file and the data from the (b) to store it to the new file I create in (a). Do you understand what I want to do ? I know it's not clear but it's the way I want this thing works Thanks Jonathan Pouliot TeckSys Developer http://www.tecksys.com Re: Serialization (save and loading) Andres Manggini19-Mar-02 16:10 Andres Manggini 19-Mar-02 16:10  Let me see if I understand correctly. You have two arrays, one contain a list of file names, the other a list of data corresponding to each file. So, you want to create as many files as the first array contains, and write the data contained in the second array to the corresponding file. is this correct ?. this sentence confuses me: /* copy */ I want to replace the button3_onclick event where the MEssageBox are with a File Creation and data transfer to the new file created... and I want to create it in ONE file (store the data and the file path in the same file not in two separate files) /* copy */ what do you mean by "(store the data and the file path in the same file not in two separate files)" ? Andres Manggini. Buenos Aires - Argentina. Re: Serialization (save and loading) BLaZiNiX19-Mar-02 16:38 BLaZiNiX 19-Mar-02 16:38  you almost got it : I want to create a file(just one file) in with I will store all the file path and each of these file DATA. this Part i'm ok. the part I don't know how : When I load the file i created with all the file path and file data in, I want to retake all the file path one by one and recreate the file corresponding to the file path with his DATA ( it's something like a copy process, but all the file path and data are store in one file and when I load the file I want to replace all the files at their place with their data) Is it more clearful now ? I hope, because I don't know very well how I can explain this. And I'm french so ... Jonathan Pouliot TeckSys Developer http://www.tecksys.com C# replacement for GetAsyncKeyState? Zombies with Coffee, LLC19-Mar-02 10:49 Zombies with Coffee, LLC 19-Mar-02 10:49  I used to see if the control key was being held down while scrolling the mouse wheel with GetAsyncKeyState( VK_CONTROL ) What is the preferred way of determining if a keystroke is currently pressed in C#/.NET? Thanks a million! Re: C# replacement for GetAsyncKeyState? Zombies with Coffee, LLC19-Mar-02 10:57 Zombies with Coffee, LLC 19-Mar-02 10:57  Found something close already... Tis funny, you rack your brain for 2 hours, post something, then find it 5 minutes later and feel like a dope. if(( Control.ModifierKeys & Keys.Control ) == Keys.Control ) Re: C# replacement for GetAsyncKeyState? ez219-Mar-02 11:27 ez2 19-Mar-02 11:27  From the docs, try this if ((Control.ModifierKeys & Keys.Control) == Keys.Control) MessageBox.Show("Control key pressed"); Updating DataSource Mazdak19-Mar-02 10:31 Mazdak 19-Mar-02 10:31  I have a dataset,and dataadapter.I add a row to dataset like this: DataRow row = dataSet11.Tables["Table2"].NewRow(); row["Username"] = str1; row["Password"] = str2; row["ID"] = 65; dataSet11.Tables["Table2"].Rows.Add(row); Now I want to make this change to datasource,so I used this: oleDbDataAdapter1.Update(dataSet11,"Table2"); But unhandled error thrown for this line,and it said no valid update command. I looked into some MSDN doc and there were talking about modifying recordsets in dataset not add new records,now how can I reflect changes and additions from dataset to datasource?Does Update() only for midifying or its for adding records too? Thanks Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Updating DataSource Andres Manggini19-Mar-02 11:34 Andres Manggini 19-Mar-02 11:34  If you're adding a new Row and then calling Update on the DataAdapter, you should assign something to the InsertCommand Property of DataAdapter. InsertCommand takes a SQL Sentence (string) or OleDbCommand. Or the alternative using OleDbCommandBuilder. This class generates the SQL Statements. See: InsertCommand DeleteCommand SelectCommand OleDbCommand OleDbCommandBuilder Andres Manggini. Buenos Aires - Argentina. Re: Updating DataSource Mazdak19-Mar-02 11:42 Mazdak 19-Mar-02 11:42  Thanks Andres,I got the point, Now if I want to add 10 Records to DataSet and want to update to DataAdapter,Should I use 10 InsertCommand ,Or is there anyway to put all of them in one InsertCommand? Thanks Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Updating DataSource Andres Manggini19-Mar-02 12:37 Andres Manggini 19-Mar-02 12:37  The same InsertCommand will be call as many times as records were added. That's the beauty of it, you can insert a few records, delete others and make a couple of changes on others, then set the three commands (InsertCommand, DeleteCommand, UpdateCommand) and let the DataAdapter do all the updates to the Database. Andres Manggini. Buenos Aires - Argentina. Re: Updating DataSource Mazdak19-Mar-02 19:39 Mazdak 19-Mar-02 19:39  hmmm,I got it.But there is another question for me here: Each time I make a change to dataset,I have to update DataAdapter,so for large database I don't think its good. Or I can update DataAdapter after all changes.What is a solution for that too? Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Updating DataSource Andres Manggini20-Mar-02 1:57 Andres Manggini 20-Mar-02 1:57  The idea is you make all the changes needed on the DataSet, once you're done and want to commit these changes to the database you call Update on the DataAdapter, and the changes will be reflected on the Database. There is no need (of course this is depending on your design) to save the dataset after each change, it works sort of a batch process. Hope that clarify a bit. If you have doubts just ask again Andres Manggini. Buenos Aires - Argentina. Re: Updating DataSource Andres Manggini20-Mar-02 2:00 Andres Manggini 20-Mar-02 2:00  One more thing.. If you're dealing with large DataSet's, there is this method: GetChanges. Doc: Gets a copy of the DataSet containing all changes made to it since it was last loaded It can be very useful in distributed scenarios. Andres Manggini. Buenos Aires - Argentina. Re: Updating DataSource Mazdak20-Mar-02 2:41 Mazdak 20-Mar-02 2:41  Thanks Andres,Now I have to write some codes to understand all this things Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Overriding simple methods... Zombies with Coffee, LLC19-Mar-02 6:02 Zombies with Coffee, LLC 19-Mar-02 6:02  I hate feeling like a newbie again. I know I can just type the line... protected override void OnPaint( PaintEventArgs e ) { ... base.OnPaint( e ); } but is there a way to get a list of override-ables and have the code generated for you? Something like ClassWizard in MFC? Thanks!! Re: Overriding simple methods... Christian Graus19-Mar-02 10:42 Christian Graus 19-Mar-02 10:42  psdavis wrote: I hate feeling like a newbie again. Me too psdavis wrote: but is there a way to get a list of override-ables I believe that you can get that in the VB type properties box in the bottom right. Christian The tragedy of cyberspace - that so much can travel so far, and yet mean so little. "I'm thinking of getting married for companionship and so I have someone to cook and clean." - Martin Marvinski, 6/3/2002 Re: Overriding simple methods... Zombies with Coffee, LLC19-Mar-02 10:46 Zombies with Coffee, LLC 19-Mar-02 10:46  HAHAHAH! Of course.. Duh!! Re: Overriding simple methods... David Wengier19-Mar-02 11:03 David Wengier 19-Mar-02 11:03  Christian Graus wrote: I believe that you can get that in the VB type properties box in the bottom right. Is this in design view? or code view? And its curious you should say "VB type" box. In VB.NET, the overridable methods are obtained from the two drop-downs at the top of the code window. (unless of course, you mean in design view, in which case i'll shut up now) I think i'll shut up anyway -- David Wengier Sonork ID: 100.14177 - Ch00k Re: Overriding simple methods... Mazdak19-Mar-02 11:19 Mazdak 19-Mar-02 11:19  Christian Graus wrote: I believe that you can get that in the VB type properties box in the bottom right. Thats not something only in VB type,its in another type too, At least,I know it exist in VC++ and VC# type too,Is there ant other type too?;) (Of cource in VC++ type,its in bottom left) Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Overriding simple methods... Christian Graus20-Mar-02 0:26 Christian Graus 20-Mar-02 0:26  In .NET yes. I'm saying the .NET IDE looks like VB6. Christian The tragedy of cyberspace - that so much can travel so far, and yet mean so little. "I'm thinking of getting married for companionship and so I have someone to cook and clean." - Martin Marvinski, 6/3/2002 DataSet Mazdak18-Mar-02 10:01 Mazdak 18-Mar-02 10:01  I have a Dataset,I want to get a spesific recordset form it. Like recordset from table1,Column3,Row2 Thanks Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: DataSet Mazdak18-Mar-02 10:40 Mazdak 18-Mar-02 10:40  Hey,I found it Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975

Last Visit: 31-Dec-99 18:00     Last Update: 24-Jun-24 7:59 Refresh ᐊ Prev1...15249152501525115252152531525415255152561525715258 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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