C# Discussion Boards - CodeProject

Re: run SQL server scripts from inside a C# code

Sabry190515-Sep-08 21:04

Sabry1905

15-Sep-08 21:04

Thanks Harvey, this is exactly what i was looking for.

Re: run SQL server scripts from inside a C# code

Harvey Saayman15-Sep-08 21:06

Harvey Saayman

15-Sep-08 21:06

Glad to help bud,
let me know if you have any troubles with it

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

Re: run SQL server scripts from inside a C# code

Sabry190516-Sep-08 4:17

Sabry1905

16-Sep-08 4:17

i have an issue in running my script
for each line in the script
i got this a message like this

Started Process --> Sqlcmd: ')': Invalid filename.
Finnished Process ---> output:

!!!

Re: run SQL server scripts from inside a C# code

Harvey Saayman16-Sep-08 4:23

Harvey Saayman

16-Sep-08 4:23

can you post what you have in scripts.txt... and is that file located on the C:\ drive?

Re: run SQL server scripts from inside a C# code

Sabry190517-Sep-08 20:38

Sabry1905

17-Sep-08 20:38

i had sent you the script through mail, yes the script lie on the C:\ partition

Changing the value of text box at run time in .net 2.0 windows application

tauras8115-Sep-08 0:38

tauras81

15-Sep-08 0:38

Hi,

I want to change the value of text box at run time in windows application with c#.net 2005.
But,I am getting the error Cross-thread operation not valid.Can anybody tell what is the reason

Re: Changing the value of text box at run time in .net 2.0 windows application

DaveyM6915-Sep-08 0:46

DaveyM69

15-Sep-08 0:46

It appears that the code that's trying to alter the textBox is running on a seperate thread. What object is trying to alter it?

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Expect everything to be hard and then enjoy the things that come easy. (code-frog)

Re: Changing the value of text box at run time in .net 2.0 windows application

tauras8115-Sep-08 0:51

tauras81

15-Sep-08 0:51

I just want to enter the value at runtime which is coming from the serial port donot have any idea about any other object

Re: Changing the value of text box at run time in .net 2.0 windows application

DaveyM6915-Sep-08 0:57

DaveyM69

15-Sep-08 0:57

show these portions of your code
1. how you create your serial port reader
2. where you get the text from the serial port and attempt to assign to the textbox's Text property.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Expect everything to be hard and then enjoy the things that come easy. (code-frog)

Re: Changing the value of text box at run time in .net 2.0 windows application

tauras8115-Sep-08 1:03

tauras81

15-Sep-08 1:03

Serial Port Declaration :
private SerialPort comport = new SerialPort();

reponse from com port : string response = comport.ReadExisting()

Changing the value : textbox1.text = response.Substring(0, 1)

Re: Changing the value of text box at run time in .net 2.0 windows application

DaveyM6915-Sep-08 1:17

DaveyM69

15-Sep-08 1:17

There's nothing using threading in the code you've posted. I assume you're using a thread to read the port, is your serial port declaration in there?

BTW, there's a simple example on MSDN[^] - it might be worth comparing to your code.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Expect everything to be hard and then enjoy the things that come easy. (code-frog)

Re: Changing the value of text box at run time in .net 2.0 windows application

Frank Horn15-Sep-08 1:59

Frank Horn

15-Sep-08 1:59

I guess you're setting the text from within the comport_DataReceived event handler, which the SerialProt object calls from another thread. Either you read up on threading, or you don't use the event but put a timer onto your form (or control) and poll the com port from the timer's Tick event.

Re: Changing the value of text box at run time in .net 2.0 windows application

tauras8115-Sep-08 18:31

tauras81

15-Sep-08 18:31

Thanks,I had get the solution for my problem I had removed the comport_DataReceived from the event handler and now I am doing it with Timer now i am able to change the text box value at run time.

Thanks again

Re: Changing the value of text box at run time in .net 2.0 windows application

Giorgi Dalakishvili15-Sep-08 0:54

Giorgi Dalakishvili

15-Sep-08 0:54

This article can help you: Beginners Guide To Threading In .NET Part 5 of n[^]

Giorgi Dalakishvili

#region signature
my articles
#endregion

Select Child Treeview Node

Programm3r15-Sep-08 0:30

Programm3r

15-Sep-08 0:30

Hi all,

I have the following method: GetNodeByName, so the thing is that I can get hold of the specific treenode but how can I select it?? Confused | :confused:

public TreeNode GetNodeByName(TreeView treeView, string key)
{
    TreeNode[] nodes = treeView.Nodes.Find(key, true);
    return nodes.Length > 0 ? nodes[0] : null;
}

Can anyone please put some light on this issue
Many thanks in advance
Regards,

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Select Child Treeview Node

Programm3r15-Sep-08 0:36

Programm3r

15-Sep-08 0:36

TreeNode nodes = GetNodeByName(tView, tStripTxtFindLog.Text);
tView.SelectedNode = nodes;

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Select Child Treeview Node

DaveyM6915-Sep-08 0:44

DaveyM69

15-Sep-08 0:44

The answer often comes to me straight after posting too! Laugh | :laugh:

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Expect everything to be hard and then enjoy the things that come easy. (code-frog)

Website IP Address??

Muammar©14-Sep-08 23:51

Muammar©

14-Sep-08 23:51

Hey,
What is the simplest way to get a website IP Address in C#??

Thanx!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Re: Website IP Address?? [modified]

Nicholas Butler14-Sep-08 23:55

Nicholas Butler

14-Sep-08 23:55

Is this what you mean?

System.Net.Dns.GetHostByName( "www..." );

edit: apparently GetHostByName is obsolete - use GetHostEntry now Blush | :O

----------------------------------
Be excellent to each other Smile | :)

modified on Monday, September 15, 2008 6:02 AM

Re: Website IP Address??

Muammar©

15-Sep-08 0:11

Thanks! I needed something as simple but I still cant see the ip address!!

I tried

public static string GetWebsiteIP(string websiteName)
{
    IPHostEntry host;
    string strIP = String.Empty;
    host = Dns.GetHostEntry(websiteName);
    foreach (IPAddress ip in host.AddressList)
        strIP += ip.ToString();

    return strIP;
}

But I still get the website name I pass Confused | :confused:

GetWebsiteIP("www.codeproject.com"); //the output is still "www.codeproject.com"

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Re: Website IP Address??

DaveyM6915-Sep-08 0:22

DaveyM69

15-Sep-08 0:22

Works fine for me : returns 69.10.233.10

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Expect everything to be hard and then enjoy the things that come easy. (code-frog)

Re: Website IP Address??

Muammar©

15-Sep-08 0:39

Did you try my very same code to get the IP address?? nothing is changed?? Unsure | :~

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Re: Website IP Address??

Muammar©

15-Sep-08 0:42

Funny! Ok, it works now, maybe I needed to clean the solution and rebuild..
Thanks for your help guys!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Re: Website IP Address??

Nicholas Butler15-Sep-08 0:23

Nicholas Butler

15-Sep-08 0:23

Just tried it and it works for me Confused | :confused:

Also, a domain name can map to multiple IP addresses, so you might want to return a string[], or maybe just pick the first one?

----------------------------------
Be excellent to each other Smile | :)

Re: Website IP Address??

Muammar©

15-Sep-08 0:45

Funny! Ok, it works now, maybe I needed to clean the solution and rebuild..
Thanks for your help!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

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