C# Discussion Boards - CodeProject

Tamimi - Code4-Jun-06 22:26

4-Jun-06 22:26

hi:

DataTable objTable = new DataTable();

DataColumn col1 = new DataColumn("id");
DataColumn col2 = new DataColumn("Name");
objTable.Columns.Add(col1);
objTable.Columns.Add(col2);

DataRow objRow = objTable.NewRow();
objRow["id"] = "1";
objRow["Name"] = "Tamimi";

objTable.Rows.Add(objRow);

Tamimi - Code

Re: Data Table Problem

foysal mamun4-Jun-06 22:51

foysal mamun

4-Jun-06 22:51

Actualy want to put the values of DataGrid into a DataTable.how is it possible.plz help me.

Re: Data Table Problem [modified]

ranandbe4-Jun-06 23:05

ranandbe

4-Jun-06 23:05

Hi foysal cool,

I think you want to build the data table with only selected data's from datagrid ok, if it is true then you have to get the datagrid row(cell's) value by travelling through whole datagrid.

To get the datagrid cell value:
Create obj for datagrid item for that datagrid then get the value of that particular row.

foreach(DataGridItem dgi in DataGrid1.Item)
{ string name=dgi.cells["column name1"].ToString();
............
..........
}

Best Regards.,
ranandbe

-- modified at 5:06 Monday 5th June, 2006

Re: Data Table Problem

Tamimi - Code4-Jun-06 23:33

Tamimi - Code

4-Jun-06 23:33

lets say datatable1 and datagrid1 ...
put the the datasource for datagrid1 = datatable
then whatever you change in the grid will reflect
on the datatable1 , then use datarow.rowstatus or
datatable.getchanges to get all the changed rows

Tamimi - Code

[Message Deleted]

Rahul.RK4-Jun-06 21:14

Rahul.RK

4-Jun-06 21:14

[Message Deleted]

Re: New Line in Textbox

Daniele Ferrero4-Jun-06 21:24

Daniele Ferrero

4-Jun-06 21:24

You must set the Multiline property to true.

Re: New Line in Textbox

stancrm4-Jun-06 21:27

stancrm

4-Jun-06 21:27

Use RichTextBox instead of TextBox.
For new line, use "\n"

Re: New Line in Textbox

Rahul.RK4-Jun-06 21:32

Rahul.RK

4-Jun-06 21:32

Thanks..It Works Properly

Rahul Kulkarni

Re: New Line in Textbox

S. Senthil Kumar5-Jun-06 0:55

S. Senthil Kumar

5-Jun-06 0:55

\n would work fine on Windows, but if your program is expected to be platform independent, use System.Environment.NewLine instead.

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Re: New Line in Textbox

malikjhangirahmed@hotmail.com4-Jun-06 22:26

malikjhangirahmed@hotmail.com

4-Jun-06 22:26

Set the MultiLine property to true, then \n will work.

Wasif Ehsan

Re: New Line in Textbox

Gazoline Speed4-Jun-06 23:09

Gazoline Speed

4-Jun-06 23:09

Set the MultiLine property to true and to create a new line, you can use \r\n.

Mini toolbar in C#

hschutte4-Jun-06 21:13

hschutte

4-Jun-06 21:13

How can I get my app to display as a mini toolbar in Windows? (Like the one Windows Media Player uses)

It must be fixed to the toolbar on the bottom of the screen.

"generating rprts through c#"

ravikiranreddydharmannagari4-Jun-06 21:00

ravikiranreddydharmannagari

4-Jun-06 21:00

i want gene a rpt for c# file using crystal reports database:sqlserver

Re: "generating rprts through c#"

Guffa4-Jun-06 22:23

Guffa

4-Jun-06 22:23

Good luck with this.

If you run into any problem with this and have any questions, feel free to ask them here in the forum.

---
b { font-weight: normal; }

concurrency + ms access

g00fyman4-Jun-06 20:07

g00fyman

4-Jun-06 20:07

hi all,

just wondering the best approach to the following situation:

I have a third party product that uses MS Access as backend and I am developing an application to enhance that program but I will use SQL database.

What is the best approach to obtain a readonly copy of the third party access database?

Do I just copy the database file then read that into my own application, then delete the copied file?
or
Can i open a read only connection to the MS Access database without disturbing the hosting applications access to the database?

There is no way that I can incorporate the functionality of the existing program into my own [clients budget does not allow for this], although this would be the ideal situation.
I also cannot write to the Access database as the host application fails whenver I change any fields within the database.
I would like to ensure that no data corruption comes about from my application accessing the MS Access databse file.

kind regards,
g00fy

Calling UnManaged Code

satsumatable4-Jun-06 19:50

satsumatable

4-Jun-06 19:50

Hi,

I have an activex control which is written in UnManaged code with the following prototype

void CSimpleAdditionAtxCtrl::VarMethod(VARIANT* VarParam)
{
AFX_MANAGE_STATE(AfxGetStaticModuleState());
}

From the C# i want to call this mwthod

[MarshalAs(UnmanagedType.AsAny)] object fieldIdSA = new string [5];
private void cmdSimpleAddition_Click(object sender, System.EventArgs e)
{
string[] myIntArray = new string[5];
fieldIdSA = myIntArray;
axSimpleAdditionAtx1.VarMethod (ref fieldIdSA); //Call UnManaged Method.
}

Which gives "Type Mismatch" whats wrong with this, please provide me alternate solution.

How to copy data from one excel workbook to another

sydney_sider4-Jun-06 18:05

sydney_sider

4-Jun-06 18:05

Hi all

Just for background information, I'm only just starting out with .NEt C# programming on Excel, which means that i'm not very good at all.. [=o))..

I am trying to write a simple C# program to open up 2 excel workbooks and copy the data from one Excel workbook to another. This process is required to be repeated for more than 20times, for 20 different set of workbooks ofcourse.

I have tried out 2 different methods but both methods take extremely long to complete. I do not understand why as if I do it manually in Excel, the selecting, copying & pasting processes takes 2 seconds to complete. While with the C# program, these processes take about 30 seconds to complete.

Method 1
Create a macro for copying & pasting. Simply pass through the Selection range for copying and pasting. These macros, when run inside Excel, is extremely fast. However when called from the C# program, these macros take forever to complete.

method 2
inside the C# program, use the Range[].Copy method. This takes forever to complete as well.

Can you guys please help me out with this one. That would be absolutely great.

Thanks guys

Kind regards

Sydney_Sider

Re: How to copy data from one excel workbook to another

Tamimi - Code4-Jun-06 19:25

Tamimi - Code

4-Jun-06 19:25

if you realy just want to copy the file try :-
System.IO.File.Copy(sourceFileName, destFileName);

Tamimi - Code

Re: How to copy data from one excel workbook to another

sydney_sider4-Jun-06 21:20

sydney_sider

4-Jun-06 21:20

Hi Tamimi

Sorry.. I was not quite precise.. I would only like to copy data from a certain number of rows from one Excel Workbook to another Excel Workbook.

For example
Copy data from Range("A1":"M159") in Workbook A and Paste the selected range to Workbook B starting at Range("B4").

Regards

[=o))

Image in PictureBox is not showing in run time. [modified]

emran8344-Jun-06 15:26

emran834

4-Jun-06 15:26

I have a picturebox that I've imported an image into using the properties window. The picture shows up fine in design mode but when I run the application the image does not show up. ? ( I made sure that the visible property was set to TRUE) Any ideas !!.

Re: Image in PictureBox is not showing in run time. [modified]

AhsanS5-Jun-06 3:51

AhsanS

5-Jun-06 3:51

You might not be having the rights to display image on web server.If you have made any settings in web.config file than allow all the users.

Ahsan Ullah.
Every problem has a solution.

Outlook context menu item

Usman Rauf4-Jun-06 10:47

Usman Rauf

4-Jun-06 10:47

i am making an outlook addin in c#. my task is to add a menuitem in a context menu whenever any stored contact is right clicked and upon clicking that menu item, call a piece of code.

i can detect whenever someone clicks on Outlook contact. but i am not finding a way to add a context menu item at this stage.

can someone please help me out on this.

.. |_|sman

ERROR_HANDLER

Bedevian4-Jun-06 9:39

Bedevian

4-Jun-06 9:39

i am trying to write this code in C#.i have a problem with Err.Number
how can i get error number in C#.
Error number is always Zero but in VB it's show the correct Error Number !!

VB.net
On Error GoTo ERROR_HANDLER
Dim TermID As Int32 = Convert.ToInt32(txtTermId.Text)
Dim EmpNum As Int32 = Convert.ToInt32(EmployeeList.SelectedItem)
objFuncs.LogIn(TermID, EmpNum, "", "")
StatusBar1.Text = "You successfully logged in with Employee " & EmpNum

ERROR_HANDLER:
MessageBox.Show(Err.Number.ToString())
Select Case Err.Number And &HFFF
Case ErrCOM_InvalidEmpPassword : MsgBox("Invalid password")
Case ErrCOM_CouldNotFindEmployeeFromId : MsgBox("Could not find employee from ID")
Case Else : MsgBox(Err.Description)
End Select

C#
try
{
int TermID = Convert.ToInt32(txtTermId.Text);
int EmpNum = Convert.ToInt32(EmployeeID.Text);
objFuncs.LogIn(TermID, EmpNum, "", "");
richTextmsg.Text += "You successfully logged in with Employee " + EmpNum;
}
catch
{

MessageBox.Show(Information.Err().Number.ToString());

switch(Information.Err().Number & 4098)
{
case ErrCOM_EmpLoggedOnOtherTerm:
MessageBox.Show("The employee is logged on to another terminal", 0, null);
break;

case ErrCOM_SomeoneAlreadyLoggedIn:
MessageBox.Show("Someone else is already logged on to this terminal", 0, null);
break;
}

Re: ERROR_HANDLER

Guffa4-Jun-06 10:21

Guffa

4-Jun-06 10:21

Get the exception object in the catch statement:

catch (Exception ex)

The exception object contains information about the exception.

You can even catch only specific exceptions, or handle different exceptions separately:

try {
   // some dangerous code...
} catch (FormatException ex) {
   // handle format exception
} catch (Exception ex) {
   // handle all other .NET exceptions
} catch {
   // handle all other exceptions
}

The Err object is a leftover from VB6, in VB.NET it's not much more than a wrapper around an exception object. You can use Try...Catch in VB.NET, just as in C#.

---
b { font-weight: normal; }

Help for serial communication.

AhsanS4-Jun-06 9:38

AhsanS

4-Jun-06 9:38

Hello dear programmers,
I am developing a project which require xml transfer from pc tp pda and vice versa over seial port.
i have no idea how to do it.can any body send me sample code
of serial communication between the two.
i'll be very greatful to you.
Regards

Ahsan Ullah

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