Chong

I'm populating my datagrid with a dataset in design time. Is there a way I can use or call the UpdateCommand to update my database without rewriting the update sql query to update my database file? Many thanks in advance! ljCharlie

Is there a way I can access another form's objects or instances without passing them through a function or sub routien? Here's my situation. I have a frmMain form that contains all my objects: buttons, panels, text boxes, datagrid, dataset and dataadapter etc.. Then I added a another class component, clsEvent, to my project. In this class, I want to be able to access all those objects in the frmMain form without passing them through a public shared sub. Is there a way? If there is way, mind give me a hand on this issue? Any help is greatly appreciated! ljCharlie

Thank you very much. It works! That's exactly what I'm looking for. ljCharlie

Will anyone show me how to delete a .rtf file in a folder for me? When I click the Delete button on the form, I like the to program to go into a folder which I specified the path and delete a file that matches a criteria. I'm using the SaveFileDiaglog to save the file, but I don't know how to delete it. Many thanks for any help! ljCharlie

Thank you very much for the response. I think I like your first idea better. However, how do I load the string plus the text file both into the RTB? The string variable is not store in any database or file....it's created during run time. ljCharlie

Is there a way to add texts before a RichTextBox file load? Here's my situation. I have a string variable that holds a bunch of data in it. Below is how I load the file into the RichTextBox. richTextBox1.LoadFile(filePath & strFileName, RichTextBoxStreamType.RichText) However, I want to add the string variable to the RichTextBox along with the data that comes from the file load. Another word, I want to combine the two and store into one richtextbox. Is there a way to do this? Any help is greatly appreciated! ljCharlie

Thank you very much for the help. I like to the idea of keeping the image out of the database; however, how do I keep the text and the image synchronize when I'm loading them back? ljCharlie

I need help with storing images in database. In my mdb file, one of the fields is declared as memo. Back in the vb.net program, I have a box declared as RichTextBox. When I paste an image into this RichTextBox and insert that into the mdb file, there is no error occure....but when I went back to the datagrid to load that entry into the datagrid, I found out that the image wasn't stored. In fact, the variable that holds the RichTextBox with the image shows nothing in between the quotes. So the question I have is, how do I store images with texts in the RichTextBox and store that somehow into a database file? One other concern is, once I am able to store the images into the database file, is the VB.NET datagrid able to show the images when populating the datagrid? I appreciate any help with this problem. ljCharlie

Thank you very much for the reponse. The Xtragrid is not free, right? I'll take a look at it. Again, thanks! ljCharlie

Is there a way to save the currently display datagrid into an excel file? If so, mind helping me with the steps? Thank you very much. Greatly appreciated! ljCharlie

Thank you very much for the help. I found out that I have a veriable name called "Name" which is a reserved word. It's working now. Thanks! ljCharlie

I'm getting an error when I run the program with the following message: And when I look at line 1107, there's this code: Me.Name = "mainForm" If I delete this line or comment it out then the program runs fine but with a warning about conflict variable name. However, after a couple of runs, the program will generate the same exact above error again. And this time, if I look at the line, 1107, again, the code Me.Name = "mainForm" is back. Does anyone have any suggestion why this happened? If anyone wish to see my whole project to help me diagnose, I'm willing to attach it in here or send it to you. I'm greatly appreciate for any help I can get. Thank you, ljCharlie

I have three datasets that uses one datagrid to display the data. I need to format this datagrid to fit each dataset. However, I couldn't figure out how. Here's what I found out so far. In the DataGridTableStyle Collection Editor, I have created three members: 0, 1, 2. In each of these members, I have defined a GridColumnStyles collection in DataGridColumnStyle Collection Editor their properties. The problem I have right now is how do I call the DataGridTableStyle member at run time. I have three datasets that uses the same datagrid that is why I have three members in the DataGridTableStyle. But I can not figure out how to call the member that will correspond with a dataset that it is bind to the datagrid. Any help to do this task is greatly appreciated! ljCharlie

Thank you very much for taking your time to help me with this problem. I'll give this a try. I'm greatly appreciated! Thanks again, ljCharlie

Thanks for the offer. The form that I need help with is mainform.vb in sub rountine tlbrMenu. By the way, I forgot. When you run the program, the password and user form pop up first. Just lick OK. Currently there is no user name and password. Click any of the first three toolbar menu from left to right. The datagrid will be populated with some data. In the tool bar menu, you'll see a red X icon. This is to delete the row. ljCharlie computers.zip