Run SQL Server script from C# code - C# Discussion Boards

Re: get ipaddress

virendra patel13-Feb-07 23:48

virendra patel

13-Feb-07 23:48

all string?

i didn't got u'r question. send me again.

Re: get ipaddress

Blue_Boy13-Feb-07 23:20

Blue_Boy

13-Feb-07 23:20

Perhaps this should help you...

public string strHostName="";<br />
public string [] args=null;<br />
public IPHostEntry ipEntry =null;<br />
IPAddress[] addr=null;<br />
.<br />
.<br />
.<br />
.<br />
.<br />
.<br />
if (args.Length == 0)<br />
{<br />
// Getting Ip address of local machine...<br />
// First get the host name of local machine.<br />
strHostName = Dns.GetHostName();<br />
//MessageBox.Show(strHostName);<br />
}<br />
else<br />
{<br />
strHostName = args[0];<br />
}<br />
<br />
// Then using host name, get the IP address list..<br />
ipEntry = Dns.GetHostByName(strHostName);<br />
addr = ipEntry.AddressList;<br />
for (int i = 0; i < addr.Length; i++)<br />
{<br />
strip = addr[i].ToString();<br />
//MessageBox.Show(strip);<br />
}

I Love SQL

User Controls [modified]

mark_w_13-Feb-07 22:50

mark_w_

13-Feb-07 22:50

I have a form with a number of user controls on, however the form seems to keep corrupting. I don’t have the problem with any forms that don’t have user controls, and another dev here has the same problems on another app (different user controls as well).

This is the error that I get when I try to load the form in the designer

http://img157.imageshack.us/my.php?image=formerroruu9.jpg

Any suggestions

I am using VS 2005

-- modified at 4:55 Wednesday 14th February, 2007

Re: User Controls

Martin#13-Feb-07 23:22

Martin#

13-Feb-07 23:22

Hello,

The designer calls the Constructor and also the setters of properties if they are set, from your usercontrol.
In your case you whant to access an object wich is not created (instanziated) yet, therefore you get this null ref Exception.

You first have to find the point in the usercontrol where the exception is thrown:

You could start a second instance of your project and then connect at youre first instance.
After that you should set a breakpoint in your controls constructor, and then open the form (designer) in the first project.

Or go threw the code and look for unsafe code (like access without a != null if statement).

Once you find your problem please don't use the "DesignMode" property (like some programers would recommend) as a workaround, make it run by changing maybe the design or use an if statement.

Hope that helps!

All the best,

Martin

Re: User Controls

mark_w_13-Feb-07 23:39

mark_w_

13-Feb-07 23:39

Thanks for your reply,

Firstly can you explain how i do this i a little more detail

"You could start a second instance of your project and then connect at youre first instance.
After that you should set a breakpoint in your controls constructor, and then open the form (designer) in the first project."

secondally, one minuate that project is fine then, i rebuild it and it breaks, why would it not be consistant?

Thanks

Mark

Re: User Controls

Martin#14-Feb-07 0:06

Martin#

14-Feb-07 0:06

Hello,

mark_w_ wrote:
Firstly can you explain how i do this i a little more detail

I answered this some time ago in this thread:
http://www.codeproject.com/script/comments/forums.asp?msg=1869677&forumid=1649&mode=all&userid=1706763#xx1869677xx[^]

mark_w_ wrote:
secondally, one minuate that project is fine then, i rebuild it and it breaks, why would it not be consistant?

You could only find that out with debugging!

There are some interesting statements in this thread, which could help you!

All the best,

Martin

Re: User Controls

mark_w_14-Feb-07 0:27

mark_w_

14-Feb-07 0:27

Thanks, Have sorted my app Smile | :)

Run SQL Server script from C# code

Sushant Duggal13-Feb-07 22:15

Sushant Duggal

13-Feb-07 22:15

Hi friends,

I want to run sql server 2000 script (abc.sql) file from my C# application.
Can you guide me??

Regards,

Sushant Duggal.

Re: Run SQL Server script from C# code

Blue_Boy13-Feb-07 22:33

Blue_Boy

13-Feb-07 22:33

read it as textfile than paste content of it in SqlDataAdapter or SqlCommand or in SqlDataSource

I Love SQL

Re: Run SQL Server script from C# code

Pete O'Hanlon13-Feb-07 22:41

Pete O'Hanlon

13-Feb-07 22:41

I would suggest that you look at using Process.Start to run osql.exe.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

Deja View - the feeling that you've seen this post before.

Re: Run SQL Server script from C# code

Sushant Duggal14-Feb-07 0:28

Sushant Duggal

14-Feb-07 0:28

Hi Pete,

Thanks for your post. Can you tell me after starting the osql process, what I need to do.

Regards,

Sushant Duggal.

Re: Run SQL Server script from C# code

Colin Angus Mackay13-Feb-07 23:59

Colin Angus Mackay

13-Feb-07 23:59

Sushant Duggal wrote:
Can you guide me??

You can run just about any SQL through a SqlCommand. Just read the file in to a string and dump the string into the SqlCommand.

NOTE: GO is not SQL. It is a preprocessor command to Query Analyzer to tell it to split the file into batches. If your file has GOs in it, you need to split it up and send them as separate SqlCommands.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Re: Run SQL Server script from C# code

Sushant Duggal14-Feb-07 0:30

Sushant Duggal

14-Feb-07 0:30

Thanks for the reply friends.

Regards,

Sushant Duggal.

richtextbox question

frossie13-Feb-07 22:03

frossie

13-Feb-07 22:03

<code>ResultForm.richTextBox1.Text += "Return Result # " + (beginResultPage + i + 1).ToString() + "\r";
ResultForm.richTextBox1.Text += gresult.resultElements[i].title + "\r";
ResultForm.richTextBox1.Text += gresult.resultElements[i].snippet + "\r";
ResultForm.richTextBox1.Text += gresult.resultElements[i].URL + "\r\r";
ResultForm.richTextBox1.Text = ResultForm.richTextBox1.Text.Replace("", "");
ResultForm.richTextBox1.Text = ResultForm.richTextBox1.Text.Replace("", "");
ResultForm.richTextBox1.Text = ResultForm.richTextBox1.Text.Replace(" ", " ");</code>

Hi
reading from the codes above, i want to bold some of the results that is recieved through the richTextBox control in the form.

For eg, if i want to make bold the title that is produced using this line of code,
ResultForm.richTextBox1.Text += gresult.resultElements[i].title + "\r";

What do i need to add in to ensure that the results is in bold?

frossie

get value from string into textbox

Nekshan13-Feb-07 21:50

Nekshan

13-Feb-07 21:50

how can i get value from a string variable into a textbox?

if (dr.Read() || checkBox1.Checked == true && tb_id.Text == "@ploginname")
{
string strpwd = (string)dr["loginpswd"];
//MessageBox.Show(strpwd);
}

i m saving 'loginpswd' from db into strpwd variable. it is coming properly.
now how can i get value of 'strpwd' into displayed into textbox2?

hoping to get a reply.
thank you.
nekshan.

Re: get value from string into textbox

N a v a n e e t h13-Feb-07 21:52

N a v a n e e t h

13-Feb-07 21:52

textbox2.text = strpwd

Cheers
Navaneeth!!

Re: get value from string into textbox

Nekshan13-Feb-07 21:57

Nekshan

13-Feb-07 21:57

thank you

Re: get value from string into textbox