Re: export data from datagrid to excel sheet - C# Discussion Boards

Re: Enable/Disable Menuitems of MdiParent from MdiChild

25-Jul-07 21:20

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::-

ashukasama25-Jul-07 22:05

ashukasama

25-Jul-07 22:05

where you launch it

frmSignOn frm = new frmSignOn();
frm. MdiParent = this;
frm.Show();

and at the time of

private void frmSignOn_Load(object sender, System.EventArgs e)
{
frmMain fM = (frmMain)this.MdiParent;
fM.menuItem1.Enabled = false;
}

Smile | :)

Re: Enable/Disable Menuitems of MdiParent from MdiChild

zenithmaximus25-Jul-07 22:21

Re: Enable/Disable Menuitems of MdiParent from MdiChild

25-Jul-07 22:21

Thanks much! Big Grin | :-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 | :cool:

Regards

-::maximus::-

ashukasama25-Jul-07 22:26

ashukasama

25-Jul-07 22:26

you are welcome Smile | :)

export data from datagrid to excel sheet

srinivassam25-Jul-07 19:52

srinivassam

25-Jul-07 19:52

hello ,
i want to export data from datagrid to excel sheet iam getting one error,
error:
Control 'DataGrid1__ctl3__ctl0' of type 'DataGridLinkButton' must be placed inside a form tag with runat=server.
iam getting error at this line
DataGrid1.RenderControl(htmlWrite);
please give me any advice

srinivas

zenithmaximus25-Jul-07 20:22

25-Jul-07 20:22

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::-

srinivassam25-Jul-07 20:32

srinivassam

25-Jul-07 20:32

Thankyou zenithmaximus,
iam getting at savedialoguebox(SD)
iam using datagrid and also iam using paging for datagrid.

srinivas

zenithmaximus25-Jul-07 20:58

25-Jul-07 20:58

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. Big Grin | :-D

-::maximus::-

srinivassam25-Jul-07 22:53

srinivassam

25-Jul-07 22:53

iam getting error near save dialogue box C:\Inetpub\wwwroot\UserManagement\userdetails1.aspx.cs(170): The type or namespace name 'SaveFileDialog' could not be found (are you missing a using directive or an assembly reference?)

srinivas

User Control

Try25-Jul-07 19:31

25-Jul-07 19:31

Hi All,
I am new to C#. I have created a Windows Application and included a User Control in it. Now i want to use the User Control in my Form at Design Time. What is the procedure?
Thanks in advance.

Martin#25-Jul-07 19:52

25-Jul-07 19:52

Hello,

After you compiled it, you should see the UserControls in the Toolbox but not in the Standard Forms Controls.
There is a seperate region for your controls.

All the best,

Martin

Try25-Jul-07 20:21

25-Jul-07 20:21

I am unable to locate it. Could you help me out.

Martin#25-Jul-07 20:52

25-Jul-07 20:52

DumbDude.Dll wrote:
I am unable to locate it.

Do you mean the Toolbox?

Ctrl+Alt+X

All the best,

Martin

Try25-Jul-07 21:31

25-Jul-07 21:31

I am sorry. I am unable to find User Control on Toolbox.

Martin#25-Jul-07 21:41

25-Jul-07 21:41

If you see your From in the design view (not in code view), and you look at the Toolbox in the Region UserControls.
If this is empty you can rightmouseclick at the toolbox and select "Add/Remove elements".
Then you search for your "exe" file under ..\bin\debug and doubleclick it .
The List should then contain your controls.

All the best,

Martin

Try25-Jul-07 22:45

25-Jul-07 22:45

Thank you very much Martin.
It works.
Thanks once again.

Martin#25-Jul-07 22:49