Thanks much! :-D it really worked! got what went wrong private void frmSignOn_Load(object sender, System.EventArgs e) { frmMain fM = (frmMain)this.Parent; frmMain fM = (frmMain)this.MdiParent; fM.menuItem1.Enabled = false; } Thanks Ashu :cool: Regards

-::maximus::-

Hmmm... Im getting this error: An unhandled exception of type 'System.InvalidCastException' occurred Additional information: Specified cast is not valid. my code on the MDIChild form looks like this now private void frmSignOn_Load(object sender, System.EventArgs e) { frmMain fM = (frmMain)this.Parent; fM.menuItem1.Enabled = false; }

-::maximus::-

Thanks ashuka :-D you mean changing the frmMain fM = new frmMain(); to Form2 fr2 = (Form2)this.Parent; ? menuItem1 is already public.

-::maximus::-

Thankyou zenithmaximus, iam getting at savedialoguebox(SD) <- you mean getting confused? iam using datagrid and also iam using paging for datagrid. the save dialogue statements is where you specify the path of where you're saving the data from your datagrid to a CSV file. The code applies to a scenario where you're saving your exported data from datagrid to a CSV(excel like) file, from clicking a botton. :-D

-::maximus::-

Hi, Hope this code help private void button1_Click(object sender, System.EventArgs e) { SaveFileDialog SD= new SaveFileDialog(); SD.Filter = "csv|*.csv|Comma Seperated Files|*.csv|All Files|*.*"; SD.InitialDirectory = @"C:\"; if (SD.ShowDialog() == DialogResult.OK) { using (System.IO.StreamWriter writer = new System.IO.StreamWriter(SD.FileName)) { int Colcnt = dsResults.Tables["tbl_Master_Pol_Lst"].Columns.Count; int Rowcnt = dsResults.Tables ["tbl_Master_Pol_Lst"].Rows.Count; for(int x=0;x<=(Colcnt-1);x++) { writer.Write(dsResults.Tables["tbl_Master_Pol_Lst"].Columns[x].ColumnName.Trim()+ ","); } writer.WriteLine(); for(int x=0;x<=(Rowcnt-1);x++) { for(int y=0;y<=(Colcnt-1);y++) { if (y == 2) { writer.Write("'" + dsResults.Tables["tbl_Master_Pol_Lst"].Rows[x].ItemArray.GetValue(y)+ ","); } else { String varData = Convert.ToString(dsResults.Tables["tbl_Master_Pol_Lst"].Rows[x].ItemArray.GetValue(y)); writer.Write(varData.Replace(","," ")+ ","); } } writer.WriteLine(); } writer.Flush(); MessageBox.Show(SD.FileName + " successfully created"); } }

-::maximus::-

Hi all, I'm trying to manipulate menuitems of a MdiParent from MdiChild, here's the code that i have frmMain <- the MdiParent Form private void Main_Load(object sender, System.EventArgs e) { frmsignon fs = new frmsignon(); fs.MdiParent = this; fs.Show(); } i'm trying the below code from my MdiChild form to manipulate the menus on my MdiParent form private void frmSignOn_Load(object sender, System.EventArgs e) { frmMain fM = new frmMain(); fM.menuItem1.Enabled = false; } this code has no build errors, but it has no effect upon run time, the menuItem1 of my MdiParent form is still ENABLED. What seems to be missing? Please help me make this work. Thanks in advance:-D

-::maximus::-

Hi all, Im kinda starter in C#.net, im trying to build a system, first thing's to establish a connection to an MSAccess DB, I want to make my connection public so all forms can use it by just calling it. I'm trying to work on creating a class for it but im having hardtime making it work... How can I make a public connection in a class and call it in my forms? Thanks in advance

-::maximus::-

Hi all, I have a MS Access Database and i want to programmatically transfer it to a csv file... how can i stream the dataset that has the data from MS Access database and write it to csv file? Thanks in advance.

-::maximus::-

Office XP has Interop, but im running this application in NT... if I can have it work without installing DLLs would be much better.

-::maximus::-

Hi, I've been trying to set security password on a existing excel, and been trying these codes: Im Using COM for Excel 5.0 Public myExcel As Excel.Application Public myBook As Excel.Workbook Public mySheet As Excel.Worksheet myExcel = CreateObject("Excel.Application") xlsFilename = "C:\samp.xls" myBook = myExcel.Workbooks.open(xlsFilename) myBook.SaveAs(xlsFilename, password:=txt_password.Text) error that i'm getting is "Member not found" and points to myBook = myExcel.Workbooks.open(xlsFilename) when i try to look at the intellisense after workbooks. the only thing that appears is Gettype. Any other approach? or recommendation for this would be appreciated. Thanks.

-::maximus::-

Hi guys, Iam on deploying my application using excel interop, it worked perfectly in XP but my application intend to run on NT, just found out that NT doesnt support interop dlls. any other approach for this? or anyway that i can have the interop dll attached to my application? tnx in advance.

-::maximus::-

Hi all, Im trying to edit an existing excel file then save the changes programmatically without having the save confirmation window. im tryin this codes TargetExcel.Workbooks.Open(Dt.Rows(cnt).Item(2) & Dt.Rows(cnt).Item(1)) TargetExcel.ActiveWorkbook.Password = txt_password.Text TargetExcel.Workbooks.Close() ive even try to use TargetExcel.Application.DisplayAlerts = False it does eliminate the pop ups but will not save the changes on the file... any other codes or approach, tnx in advance.

-::maximus::-

Hi guys, I'm using DataTable, DataRow, and DataColumn on my DataGrid, and i wonder how can i programmatically set the width of a certain column on my grid. Any code on workin on these three?(Data/Table,Row,Column) to set the width of a certain column? Thanks in advance...

-::maximus::-

Hi all, I'am thinking if there's someway i can call an vb exe file when i try to access a certain folder, like at first your gonna select a folder where you're goin to bind your exe, then when u try to access that folder your exe will be launched instead of windows showing the content of that folder...

-::maximus::-

Hi guys, I'm currently working on how to lock or at least hide a certain folder, below are the codes that i'm tryin to use... renameFileName = (InputBox("Folder Name:", "Unlock", "Cycle #")) System.IO.Directory.Move(path & "\.{20D04FE0-3AEA-1069-A2D8-08002B30309D}", path & "\" & renameFileName) thing is, its working on my local folders, but when i used it to a folder on a mapped drive its just renaming it, and i still can access the folder... if you guys got another approach on how to do this... tnx in advance.

-::maximus::-

owkei... ill try this one... thanks alot

-::maximus::-

Hi all, iam havin a hard time figuring out how can i close a form which calls another form... its like a log in form calling the main form after validating the log in parameters. my code goes like this... dim form2bcalled as new form2bcalled form2bcalled.show() me.close() what happens after this codes is that the entire project close... leading me back to the design state. thanks in advance guys... Cheers. "computers are the lousy actors, and programmers are the playwright..."

-::maximus::-

ok tnx, ill try it. -::maximus::-

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll -::maximus::-

ooopppss!! sorry please disregard this message. -::maximus::-