[SqlException: Line 1: Incorrect syntax near ','.]
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +180
   DataTeam.user.cmdsave_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\DataTeam\user.aspx.vb:1652
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1277

Could you provide some more information??

-What is the sql string you are trying to execute?

I was trying to execute an insert command on a database. the code that i written is
Dim dbcmd1 As SqlClient.SqlCommand
Dim dbcon1 As SqlClient.SqlConnection
strfile = "Server=sos50\sos50;uid=intranetu;pwd=intranetu;da tabase=intranet"
 dbcon1 = New SqlClient.SqlConnection(strfile)
 dbcon1.Open()
 dbcmd1 = New SqlClient.SqlCommand(fsqlstr, dbcon1)
 dbcmd1.ExecuteNonQuery()
 dbcon1.Close()

Again,
I'm sure the error is in the query, but you haven't provided it.

The sql string is

Insert into hrhoovers(ID,Suffix,Company_Name,HQ_Address1,HQ_Ad dress2,HQ_City,HQ_State_Province,HQ_Postal_Code,HQ _Country,HQ_Main_Fax,Company_Type,Symbol,Exchange, Employees,Employee_Growth,Revenue_$_million,Revenu e_Growth,Primary_Industry,SIC_Code,NAICS_Code,WebA ddress,First_Name,Middle_Initial,Last_Name,Title,H Q_Main_Phone,EMAIL,ALTEMAIL) values(5758,'','Glenn O. Hawbaker, Inc.','1952 Waddle Rd.','','State College','PA','16803','United States','814-237-5348','Private','','','800','--','100','--','Commercial & Heavy Construction','1542;1611;1622;1629','236220;237310 ;237990','http://www.goh-inc.com',,'pavan','kumar','Paruchuri','Technical Lead','9845928872','[email protected]','p [email protected]')

Hello,

I think your issue is here:

'http://www.goh-inc.com',,'pavan','kumar','Paruchuri','Technical

After the web link, you have two commas. You need to have a value there, either:

,'',

or

,NULL,

Brian