C# Discussion Boards - CodeProject

How DataTable Export into Excel file?

pekhaleyogesh12-Dec-07 0:47

pekhaleyogesh

12-Dec-07 0:47

Can any one can tell me how i Export DataTable To Excel file.

Yogesh Pekhale
pekhaleyogesh@gmail.com

Re: How DataTable Export into Excel file?

Sun Rays12-Dec-07 1:23

Sun Rays

12-Dec-07 1:23

Hi,
see this link and modify if you wanna do something different,

Link[^]

Link[^]

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

DataView wont filter in loop

Scalee12-Dec-07 0:46

Scalee

12-Dec-07 0:46

I create a dataview of my dataset, then i add a rowfilter to it then when i set the datasource to a datagrid works perfectly.

But when i loop trough it so i can add it to a treeview i wont filter,
Im clueless.

DataView dataView = dataset_filter.Tables[0].DefaultView;
dataView.RowFilter = "artiestnaam like '" + tb_filter.Text + "%'";
dg_overzichtgroep.DataSource = dataView;

//loop trough dataset add names to TreeView
for(int i=0; i < dataView.Table.Rows.Count; i++)
{
string s = dataView.Table.Rows[i]["artiestNaam"].ToString();

if(tv_filter.InvokeRequired == true)
{
//use invoke to add to the treeview becuase of the seperate thread
tv_filter.Invoke(new UpdateTextCallback(this.AddToTreeView), new object[]{s});
}
else
{
tv_filter.Nodes.Add(s);
}
}

Thanks!

Re: DataView wont filter in loop

Paul Conrad23-Dec-07 9:57

Paul Conrad

23-Dec-07 9:57

Do you have this working yet?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

context menu strip on treeview sub nodes

D i x y11-Dec-07 23:47

D i x y

11-Dec-07 23:47

Hello,

I am developing an application and i want that ContextMenuStrip will appear on tree view subnodes Not on nodes.

+MasterNode
Node1
SubNode1
Node2
SubNode2
Node3
Subnode3
I want context menu strip should appear only on subnodes not on nodes.

Re: context menu strip on treeview sub nodes

DaveyM6912-Dec-07 1:11

DaveyM69

12-Dec-07 1:11

You can either
1. Set the context menu individually for each node rather than for the entire treeview
or
2. Set the nodes tag property or something to indicate whether it should display the treevies's context menu (Or create your own and inherit from System.Windows.Forms.TreeNode and add a boolean property) and check that value in the events that fire before the comtext menu is shown to disable it.

Trace

ellllllllie11-Dec-07 23:40

ellllllllie

11-Dec-07 23:40

In my project i use the system trace to trace error log.
but do someone help to know where is the path of the file that contain this trace.
best regards,

dghdfghdfghdfghdgh

Re: Trace

ChrisKo12-Dec-07 7:50

ChrisKo

12-Dec-07 7:50

The debug messages are sent to the Output window (Debug -> Windows -> Output) by default. If you want to capture those trace messages to a file, you will need to create a TraceListener and add it to the Debug Listener collection.

TextWriterTraceListener myTrace = new TextWriterTraceListener(File.CreateText(@"c:\Output.txt"));
Debug.Listeners.Add(myTrace);

Problem with DB2

User 269896711-Dec-07 22:36

User 2698967

11-Dec-07 22:36

Hello

I have the following problem. When I start my program I create an OleDbConnection to a DB2 and use this connection for different requests. But after about 8 minutes I get the following error: "OleDbException System.Data.OleDb.OleDbException: [DB2/6000] SQL0551N "xxx" does not have the privilege to perform operation "EXECUTE" on object "NULLID.yyy". SQLSTATE=42501". What does that mean???

Thanks for your help.

Greets
pkoeppe

Re: Problem with DB2

User 269896713-Dec-07 21:01

User 2698967

13-Dec-07 21:01

For a work around I open a new connection for each request and close the connection after the request. But here the connection seems not to be closed really. The connection state is closed but the database says there is still a connection. After some request I get the error "Open Connection failed System.Data.OleDb.OleDbException: SQL1226N The maximum number of client connections are already started. SQLSTATE=57030". I don't unterstand this, I close each connection after the request. When I close my program then the connections are closed "really", what is the problem??? Confused | :confused:

That's the way I do my requests:

public DataTable Request()<br />
{<br />
  try<br />
  {<br />
    using (OleDbConnection connection = new OleDbConnection(Constants.DB2_CONNECTION_STRING))<br />
    {<br />
      using (OleDbDataAdapter da = new OleDbDataAdapter(request, connection))<br />
      {<br />
        using (DataTable dtResult = new DataTable())<br />
        {<br />
          da.Fill(dtResult);<br />
          return dtResult;<br />
        }<br />
      }<br />
    }<br />
  }<br />
  catch (Exception ex)<br />
  {<br />
    MessageBox.Show(ex.ToString());<br />
  }<br />
  return null;<br />
}<br />

Hi How i bound Combo BOX

wasimsharp11-Dec-07 22:31

wasimsharp

11-Dec-07 22:31

hi i have a stored procedure which return the value of user name and i want to populate the ComboBox whit the written value how i do that

wasim khan

Re: Hi How i bound Combo BOX

Christian Graus11-Dec-07 22:54

Christian Graus

11-Dec-07 22:54

Set the display member to the name of the column you want to show, then bind to the dataset

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: Hi How i bound Combo BOX

Paul Conrad23-Dec-07 9:58

Paul Conrad

23-Dec-07 9:58

Do you have this working yet?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: Hi How i bound Combo BOX

wasimsharp23-Dec-07 18:26

wasimsharp

23-Dec-07 18:26

yes it wrok good and sory for asking thanks Sooo late

wasim khan

Re: Hi How i bound Combo BOX

Paul Conrad24-Dec-07 4:46

Paul Conrad

24-Dec-07 4:46

Thought I'd just drop you a line to see if all was well Smile | :)

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

GridView(winroms) Sorting

VenkataRamana.Gali11-Dec-07 21:55

VenkataRamana.Gali

11-Dec-07 21:55

Hello all,

i am working on .NET 2.0 DataGridView (winforms) sorting.

I want to add checkbox in the column header & i want to implement sorting also.

if i specify automatic then it was not working.

any sounds?

Ramana

Grid with ArrayList-Binding : CurrentCell = null

baerten11-Dec-07 21:20

baerten

11-Dec-07 21:20

Hello everybody,

i set the datasource of the DataGridView to an ArrayList (with Objects)
At the beginning the list is empty, then it gets a value.
So i need to update the Grid:

I set the datasource to null and re-set it to the arraylist.
The Grid has now one row, but in this case CurrentRow and CurrentCell is <null>

How can i set CurrentCell & CurrentRow to the first line?

BTW: Grid[0,0].Selected is true if CurrentCell == null D'Oh! | :doh:

Big thanks in advance Smile | :)

asmblly and an aboutBox

barak16048711-Dec-07 20:37

barak160487

11-Dec-07 20:37

hi.
I want to build an aboutBox DLL, which get any kind of project(project assembly) and show it on the aboutBox.

how do I do it?

Re: asmblly and an aboutBox

Abhijit Jana11-Dec-07 22:13

Abhijit Jana

11-Dec-07 22:13

You Can Easily Do it using Reflection !!!

There is a Assembly Class. Usign That you can retrive all inforamtion runtime.
You can also Check Assembly Values in Solluation Explorer > Properties > Assemblyinfo.cs

If any Query You can Ask me !!!!

Good Luck !!!

Best Regards
-----------------
Abhijit Jana
View My CodeProject Articles

"Success is Journey it's not a destination"

Re: assembly and an aboutBox

dwilliss19-Dec-07 14:37

dwilliss

19-Dec-07 14:37

You can use AppDomain.GetAssemblies() to get a list of the Assemblies which have been loaded into the program.

Does anybody know how to get a list of the assemblies (dlls) which an application will use even if it hasn't loaded them yet?

MonthCalendar Control

Chandan_Kr11-Dec-07 20:21

Chandan_Kr

11-Dec-07 20:21

Hi,

I am working on a windows application in which I have a MonthCalendar Control. Basically its a Reminder application. I want all the dates should be selected on which user has set reminder. if I have set reminder for 15th Dec, 18th Dec, 25th Dec then this dates should be selected in the MonthCalendar Control.

Can any one plz let me know how can I acheive this task.

Best Regards,
Chandan Kumar Gupta

Re: MonthCalendar Control

Abhijit Jana12-Dec-07 0:37

Abhijit Jana

12-Dec-07 0:37

Hi Chandan,
Hope this link will help you !!!
Another Month Calendar[^]

Best Regards
-----------------
Abhijit Jana
View My CodeProject Articles

"Success is Journey it's not a destination"

ReadLine needs twice Return Hit after Console.TreatControlCAsInput = true; Optionen

Kerem Guemruekcue11-Dec-07 20:16

Kerem Guemruekcue

11-Dec-07 20:16

Hi,

can someone tell me why setting Console.TreatControlCAsInput = true needs two times hitting the enter button to make the Console.ReadLine work. Is this really a bug and if yes, how can i simulate a useful ReadLine function that does work?

Regards

Kerem

-----------------------
Beste Grüsse / Best regards / Votre bien devoue
Kerem Gümrükcü
Microsoft Live Space: http://kerem-g.spaces.live.com/
Latest Open-Source Projects: http://entwicklung.junetz.de
-----------------------
"This reply is provided as is, without warranty express or implied."

write a function to check if the value is in float format?

cyn811-Dec-07 19:57

cyn8

11-Dec-07 19:57

hi,
how can i write a function to check if the value is in float format?
it should return true is the value is in float format.
thanks

Re: write a function to check if the value is in float format?

Kerem Guemruekcue11-Dec-07 20:12

Kerem Guemruekcue

11-Dec-07 20:12

Hi,

see here:

http://www.thescripts.com/forum/thread230544.html[^]

Maybe there is something that you can use. If the build-in functions given in the .NET do not saticfy you applications need then you can try the examples given in the link above,...

Regards

Kerem

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