-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: thajeer
Message 3 in Discussion



Hi Anjali,



        u
can use Environment.NewLine
as one of the arguments .. 



        for
eg String.Format("{0}{1}{2}",
"test", Environment.NewLine, "test")



Thajeer










"Anjali_Mehta_DotNet"
<[EMAIL PROTECTED]> 

06/30/2004 02:50 AM





Please respond to

"BDOTNET" <[EMAIL PROTECTED]>






To
"dotNET User Group Hyd"
<[EMAIL PROTECTED]>


cc
"AhmedabadUserGroup"
<[EMAIL PROTECTED]>, "PuneUserGroup" <[EMAIL PROTECTED]>,
"DOTNETSIG" <[EMAIL PROTECTED]>, "kolkatanet"
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>,
"MS Dot Net Indore" <[EMAIL PROTECTED]>, "BDOTNET"
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, "Chennai
NET User Group" <[EMAIL PROTECTED]>, "MumbaiUserGroup"
<[EMAIL PROTECTED]>


Subject
String formatting help

















New Message on BDOTNET





String
formatting help





Reply





 
Reply
to Sender   Recommend


Message 1 in Discussion







From:
Anjali_Mehta_DotNet




May sound silly,  i have a silly test
program that add a record in db ..input is from webform

iam using string.format to create my Sql
string, it works fine, what i want to put this sql string in multiple lines,
currently whole string is in one line, please some one..

 

Guys dont get bored with my stuff, just started
doing .NET .. i guess these are starting glithces that everybody experiences.

 

 

dim con as sqlconnection

     dim cmdInsert as sqlcommand

     dim strInsert as string

 

     con = new sqlconnection("server=localhost;uid=sa;pwd=*****;database=*******")

     con.open()

     

 



strInsert= string.format("insert into emp(username,password,firstname,secondname)
values('{0}','{1}','{2}','{3}')",txtusername.text,txtpassword.text,txtfirstname.text,txtsecondname.text)

 

cmdInsert= new sqlcommand(strInsert,con)

cmdInsert.ExecuteNonquery()

con.close()

 

 

 

Anjali Mehta





View
other groups in this category. 






Also on MSN:

Start
Chatting |
Listen
to Music |
House
& Home |
Try
Online Dating |
Daily
Horoscopes 









To stop getting this e-mail, or change how often it arrives, go to your
E-mail
Settings. 



Need help? If you've forgotten your password, please go to Passport
Member Services. 

For other questions or feedback, go to our Contact
Us page. 



If you do not want to receive future e-mail from this MSN group, or if
you received this message by mistake, please click the "Remove"
link below. On the pre-addressed e-mail message that opens, simply click
"Send". Your e-mail address will be deleted from this group's
mailing list. 

Remove
my e-mail address from BDOTNET.




ForwardSourceID:NT000082D6
   



-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to