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

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

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.

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.

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

get value from string into textbox

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

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.

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!!

Nekshan13-Feb-07 21:57

Nekshan

13-Feb-07 21:57

thank you

virendra patel13-Feb-07 21:54

virendra patel

13-Feb-07 21:54

textbox2.text = strpwd ;

Nekshan13-Feb-07 22:02

Nekshan

13-Feb-07 22:02

thanx virendra.
whts up? hope to complete dis module in dis week.lets c.
cu soon. tc.
nekshan.

how can i send/receive data to parallel port in C#.net and windows XP

virendra patel13-Feb-07 22:04

virendra patel

13-Feb-07 22:04

i m working on xmlwebservices.i have to prepared 3 webservices in 2 days..

gpremkamal13-Feb-07 21:49

gpremkamal

13-Feb-07 21:49

hi
i sucessfully send or rteceive data to parallel port in windows 98
but i cant communicate parallel port in windows XP

Re: how can i send/receive data to parallel port in C#.net and windows XP

dipswitch@ownage4u.nl13-Feb-07 22:02

dipswitch@ownage4u.nl

13-Feb-07 22:02

I've never tryed but I think you can find your answere here

Recursive class definiton ?

The Nemesis13-Feb-07 21:44

The Nemesis

13-Feb-07 21:44

I have a class A and within this class A, I want to have an object of type A. Is this possible ? Do I need to do anything special ?

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

N a v a n e e t h

13-Feb-07 21:49

i think u can do that

Cheers
Navaneeth!!

The Nemesis13-Feb-07 21:50

The Nemesis

13-Feb-07 21:50

Thanks a lot..

Martin#13-Feb-07 22:03

Martin#

13-Feb-07 22:03

Hello,

It's working as long as you not calling " ??? = new A();".
Then you would have a invinit loop!

All the best,

Martin