C# Discussion Boards - CodeProject

varun_mca_ju7-Aug-08 19:54

7-Aug-08 19:54

i have a C# windows application form with various controls such as textbox ,combo box,date time picker etc. i want that on clicking a button PRINT the data entered by the user in the controls should be added to particular cells of an existing Excel sheet (for e.g. i have to add the data in textBox1 to a particular cell of sheet1.xls saved on desktop)and then the sheet should be printed..i don't want the data to be saved on the sheet as i want that the next time i click the PRINT button the new data should be entered to the same cell. ...plz help and thanks in advance

Re: adding data to MS Excel in C#.net

Paul Conrad7-Aug-08 20:00

Paul Conrad

7-Aug-08 20:00

You should read up on using the Office Interop Library.

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

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

Re: adding data to MS Excel in C#.net

varun_mca_ju7-Aug-08 20:32

varun_mca_ju

7-Aug-08 20:32

thanks for the reply Paul ...it would be great if you could explain the technique to me as i am a novice in the field of C#.Net programming Sigh | :sigh:

Re: adding data to MS Excel in C#.net

Paul Conrad7-Aug-08 20:34

Paul Conrad

7-Aug-08 20:34

Do a basic google search for Office Interop Library, also, check out the link John just posted.

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

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

Re: adding data to MS Excel in C#.net

John_Adams7-Aug-08 20:31

John_Adams

7-Aug-08 20:31

Hi,

Download the VSTO(Visual Studio Tools for Office)addins, which and specifically meant for Office applications learn them, from the following location:

http://www.microsoft.com/downloads/details.aspx?familyid=F5539A90-DC41-4792-8EF8-F4DE62FF1E81&displaylang=en[^]

Hope this helps .

Regards,
John Adams
ComponentOne LLC

Regards,
John Adams
ComponentOne LLC

Re: adding data to MS Excel in C#.net

Paul Conrad7-Aug-08 20:35

Paul Conrad

7-Aug-08 20:35

I don't know what happened, your post should have gone to the OP, and for some reason came up in my email Suspicious | :suss:

Good link, and I directed the OP to your post.

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

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

Re: adding data to MS Excel in C#.net

dan!sh 7-Aug-08 20:37

dan!sh

7-Aug-08 20:37

Another way can be using OloeDB classes. You can connect to the excel file and perform insert.

how to extrack string from a sentence?

wajans7-Aug-08 19:44

wajans

7-Aug-08 19:44

I have a string stored in a variable, say
myString= <RssFeeds><link>http://www.codeguru.com/icom_includes/feeds/codeguru/rss-all.xml</link>
<title>CodeGuru.com</title>
<description>something</description></RssFeeds>
<RssFeeds>
<link>http://lifehacker.com/index.xml</link>
<title>Lifehacker</title>
<description>something</description></RssFeeds>

I want to extract the text between <link> and </link> and also the text between <title> and </title> in two different arrays.
How to do this, please help me. if anyone have code or any helpfull link please reply back.

Thanks

Re: how to extrack string from a sentence?

Paul Conrad7-Aug-08 20:01

Paul Conrad

7-Aug-08 20:01

You could alway use regular expressions.

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

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

Re: how to extrack string from a sentence?

soni uma7-Aug-08 20:07

soni uma

7-Aug-08 20:07

Try using this way

string myString = "<rssfeeds>http://www.codeguru.com/icom_includes/feeds/codeguru/rss-all.xml"
+ "<title>CodeGuru.com<description>something<rssfeeds>"
+ "http://lifehacker.com/index.xml<title>Lifehacker<description>something";
string[] test = new string[15];
myString = myString.Replace("", "#");
myString = myString.Replace("", "#");

test = myString.Split(Convert.ToChar("#"));

Re: how to extrack string from a sentence?

wajans7-Aug-08 20:26

wajans

7-Aug-08 20:26

I want to extract substring and store it in an array from to , it repeats two times in my string. How to extract it?

Re: how to extrack string from a sentence?

soni uma7-Aug-08 20:34

soni uma

7-Aug-08 20:34

You can doing it with using for loop.Check '<' in string array if array is not contain that than store that sting with ++

Re: how to extrack string from a sentence?

dan!sh 7-Aug-08 20:40

dan!sh

7-Aug-08 20:40

Dirty but seems to work.

string sFull = "this the is test for the true";
            string sToSearch = "the";
            int iFirst = sFull.IndexOf(sToSearch);
            int iSecond = sFull.IndexOf(sToSearch, iFirst + sToSearch.Length);
            string sText = sFull.Substring(iFirst + sToSearch.Length, iSecond - iFirst -sToSearch.Length);

Re: how to extrack string from a sentence?

J4amieC7-Aug-08 22:12

J4amieC

7-Aug-08 22:12

Thats not a string, its called "Xml" and there is built in ability to read its node values.

Have a look at System.Xml.XmlDocument and System.Xml.XmlTextReader

Re: how to extrack string from a sentence?

PIEBALDconsult8-Aug-08 5:19

PIEBALDconsult

8-Aug-08 5:19

Yeah, XmlDocument.

Determine MDI Children Z-Order

User 127827-Aug-08 18:40

User 12782

7-Aug-08 18:40

I have a form that can optionally display several MDI children forms. I have a toolbar that when clicked, I'd like to make the child visible and bring it to the front. If the child is already visible but not in the front, I'd like to bring it to the front. Finally, if the child is visible and in the front I would like to hide the child until the button is pressed again.

I have no problem showing/hiding or bringing the form to the front, but I don't know how to determine which form is on top. Any ideas on how to do this?

Thanks

modified 12-Jul-20 21:01pm.

wpf help

lankaudaranga7-Aug-08 17:53

lankaudaranga

7-Aug-08 17:53

how to add date time picker for wpf application.please help.

Re: wpf help

Abhijit Jana7-Aug-08 19:42

Abhijit Jana

7-Aug-08 19:42

this is C# Forum. please put it on WPF Forum

cheers,
Abhijit

Re: wpf help

John_Adams7-Aug-08 20:12

John_Adams

7-Aug-08 20:12

Hi,

Please go through the following link, it explains how we can create our own DataTime Picker control. WPF does not have it's own DateTime Picker control.

http://forums.msdn.microsoft.com/en-US/wpf/thread/321593c4-8ce0-47bb-a7df-f06b59e85ca2/[^]

Hope this helps Smile | :)

Regards,
John Adams
ComponentOne LLC

Could I index controls?

blackhattrick7-Aug-08 15:31

blackhattrick

7-Aug-08 15:31

This is a feature I've seen with the picture control on VB, but could I do that with text boxes or buttons on C#?

I´m trying to change some properties of textboxes but I want to use iteration. For instance, I want to assign the for cycle counter's value to each textbox and display it. 1 for textbox1.text, 2 for textbox2.text and so on.

If anybody has another method to do this please tell me.

I hope made myself clear and excuse my english.

Regards

Ivan

Re: Could I index controls?

teejayem7-Aug-08 16:23

teejayem

7-Aug-08 16:23

You can create an array of pretty much any type (in your case text boxes).

Note: Pseudo Code

TextBox[] myTextBoxes = new TextBox[5]

for(int index = 0; index < myTextBoxes.Length; index++)
{
myTextBoxes[index] = new TextBox();
myTextBoxes[index].Text = String.Format("TextBox #{0}", index+1);
}

Don't be overcome by evil, but overcome evil with good

Re: Could I index controls?

User 66587-Aug-08 21:27

User 6658

7-Aug-08 21:27

Additionally to what teejayem said: if you want to modify the textboxes of your form, then you can do this:

foreach(Control c in this.Controls)
{
   if(c is TextBox)
      ((TextBox)c).Text = insert_your_text_here;
}

regards

modified 12-Sep-18 21:01pm.

Re: Could I index controls?

blackhattrick8-Aug-08 15:20

blackhattrick

8-Aug-08 15:20

Thank you a lot, your aid was really helpful

Ivan

Seraching in XML by LINQ ?

Mohammad Dayyan7-Aug-08 15:27

Mohammad Dayyan

7-Aug-08 15:27

Hi there.
I have a XML file like this :

<NODE15>
<BOOKMARK16 NAME="Mozilla - Home" HREF="http://en-us.www.mozilla.com/en-US/" />
<BOOKMARK18 NAME="mozillaZine Forums" HREF="http://forums.mozillazine.org/index.php" />
<BOOKMARK19 NAME="Mozilla Support" />
<BOOKMARK20 HREF="http://www.download.com/" />
<BOOKMARK21 HREF="http://firefoxplanet.ir/" />
<BOOKMARK22 HREF="http://developer.mozilla.org/en/docs/Extensions" />
<BOOKMARK23 HREF="http://forums.mozillazine.org/viewforum.php?f19" />
<BOOKMARK24 HREF="https://addons.mozilla.org/en-US/firefox/addon/5229" />
</NODE15>

I want to search in it by LINQ.
I used this code

X_Element = XElement.Load(FileName);
var searchNodes = from nodes in X_Element.Descendants()
where Regex.IsMatch(nodes.Attribute("HREF").Value, "Mozilla", RegexOptions.IgnoreCase)
 select nodes;

But there is no data in searchNodes
What's wrong with it ?

Thanks in advance

Re: Seraching in XML by LINQ ?

teejayem7-Aug-08 16:24

teejayem

7-Aug-08 16:24

Please don't crosspost.

Don't be overcome by evil, but overcome evil with good

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