ASP.NET

FirstPrevNext

How to register an assembly in asp.net web app? [modified] choorakkuttyil12-Sep-06 1:53 choorakkuttyil 12-Sep-06 1:53  How to register an assembly in asp.net web app? How to register an assembly in asp.net web app? How to re gister an assembly in asp.net web app? Syntax error in INSERT INTO statement. kirthikirthi12-Sep-06 1:28 kirthikirthi 12-Sep-06 1:28  Hi all I am trying to insert data in .mdb file I have 20 fields If i insert 6 fileds it is working But it is not working when i try to inserting 20 fileds It is giving this error "Syntax error in INSERT INTO statement." Can any one help me asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf Re: Syntax error in INSERT INTO statement. Colin Angus Mackay12-Sep-06 1:51 Colin Angus Mackay 12-Sep-06 1:51  What is the code?! Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog Re: Syntax error in INSERT INTO statement. Sathesh Sakthivel12-Sep-06 2:02 Sathesh Sakthivel 12-Sep-06 2:02  Pls check the Names of the Column in the DB and Also in ur code. With Regards Satips Re: Syntax error in INSERT INTO statement. Colin Angus Mackay13-Sep-06 7:01 Colin Angus Mackay 13-Sep-06 7:01  Satips wrote: Pls check the Names of the Column in the DB and Also in ur code. I think you replied to the wrong person. I did not ask the original question. Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog Re: Syntax error in INSERT INTO statement. Guffa12-Sep-06 3:21 Guffa 12-Sep-06 3:21  It has nothing to do with the number of fields. You have just made an error when adding the other fourteen fields. That is about as much as anyone can say without seeing the actual code. --- b { font-weight: normal; } Re: Syntax error in INSERT INTO statement. kirthikirthi12-Sep-06 19:56 kirthikirthi 12-Sep-06 19:56  Hi Sorry all of u Actiually i didnt post my second error Some times It is giving "Unspicified Error" in connection.open() Or it is giving "Syntax error in INSERT INTO statement" And i chk the insert statement also no errors in that Plz chk my code MYCODE ---------- Dim sConnectionString Dim objCmd As New System.Data.OleDb.OleDbCommand sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Some.mdb") & ";") Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objCmd.Connection = objConn objCmd.CommandText = "INSERT INTO Info(1,2,3,4,5,6,----------------20) values('" & 1.Text & "','" & 2.Text & "','" & 3.Text & "','" & 4.Text & "','" & 5.SelectedItem.Text & "','" & 6.SelectedItem.Text & "',--------------------- up to 20 fields)" objCmd.Connection = objConn objConn.Open() objCmd.ExecuteNonQuery() objConn.Close() THX asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf Re: Syntax error in INSERT INTO statement. Guffa12-Sep-06 23:00 Guffa 12-Sep-06 23:00  No, that is not the code that you are using. You can not use numbers as names of objects, so it won't even compile. Also, you can not use numbers as field names in the database like that. If you don't want to post the exact code that you are using, put together a working example that demonstrates the problem. There is no point in trying to find an error in a piece of code that is different from the code where the actual error is. --- b { font-weight: normal; } Re: Syntax error in INSERT INTO statement. kirthikirthi12-Sep-06 23:25 kirthikirthi 12-Sep-06 23:25  Hi My mean is not hide the code my fields name are to big thats y i put fields name as numbers to better understood Plz chk this MYCODE --------- Dim sConnectionString Dim objCmd As New System.Data.OleDb.OleDbCommand sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Names.mdb") & ";") Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objCmd.Connection = objConn objCmd.CommandText = "INSERT INTO Info(username,userpasswd,Name,email,try,loc,other,other1,num,yearwise,monthwise,skils,funarea,current,ug,pg,greatpg,RB,ugo ther,pgother,postother,cpr) values('" & uname.Text & "','" & pass.Text & "','" & name.Text & "','" & email.Text & "','" & c***ry.SelectedItem.Text & "','" & loc.SelectedItem.Text & "','" & other.Text & "','" & other1.Text & "','" & no.Text & "','" & yearwise.SelectedItem.Text & "','" & monthwise.SelectedItem.Text & "','" & skilsmen.Text & "','" & Label1.Text & "','" & currrent.SelectedItem.Text & "','" & ugrad.SelectedItem.Text & "','" & pggrad.SelectedItem.Text & "','" & pggreat.SelectedItem.Text & "','" & RB.SelectedItem.Text & "','" & u1.Text & "','" & p1.Text & "','" & greatpg1.Text & "','" & cpr.Text & "')" objCmd.Connection = objConn objConn.Open() objCmd.ExecuteNonQuery() objConn.Close() asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf Re: Syntax error in INSERT INTO statement. Guffa12-Sep-06 23:49 Guffa 12-Sep-06 23:49  That's better. The problem is in the information that you left out in the previous post. "Name" is a reserved keyword in Access. "Current" is a reserved keyword in SQL, Jet and ODBC. --- b { font-weight: normal; } Re: Syntax error in INSERT INTO statement. kirthikirthi14-Sep-06 0:51 kirthikirthi 14-Sep-06 0:51  HI I changed DB fileds still it is giving same ERROR Plz Chk this code MYCODE --------- Dim sConnectionString Dim objCmd As New System.Data.OleDb.OleDbCommand sConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("DB22.mdb") & ";") Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objCmd.Connection = objConn objCmd.CommandText = "insert into user(uname,pass) values(" & TextBox1.Text & "," & TextBox2.Text & ")" objCmd.Connection = objConn objConn.Open() objCmd.ExecuteNonQuery() objConn.Close() asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf Re: Syntax error in INSERT INTO statement. Guffa14-Sep-06 1:30 Guffa 14-Sep-06 1:30  User is a reserved keyword. --- b { font-weight: normal; } Re: Syntax error in INSERT INTO statement. kirthikirthi14-Sep-06 2:07 kirthikirthi 14-Sep-06 2:07  Thx I got it asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf Javscript in asp.net 1.1 anujose12-Sep-06 1:27 anujose 12-Sep-06 1:27  Hi, i want to write a javascript function in .aspx file to make a button enable property false and i want to take the value from a textbox to a javascript function and also i want to put some values in a textbox using javascript function.i tried a lot .but i didn't get the correct code.i know the same in asp .but in asp.net 1.1 that code is not working Please give me a reply. Thanks and regards anu Re: Javscript in asp.net 1.1 _AK_12-Sep-06 1:31 _AK_ 12-Sep-06 1:31  What exactly have you done? Or what error are you getting? Best Regards, Apurva Kaushal Re: Javscript in asp.net 1.1 mbbisht12-Sep-06 1:40 mbbisht 12-Sep-06 1:40  instead of making textbox enable false make it readonly Mahendra Re: Javscript in asp.net 1.1 Tony Pink12-Sep-06 19:56 Tony Pink 12-Sep-06 19:56  Is your web control or HTML control ? html Element has not property "readOnly" if use javascript to control a button enable property that I don't know Haha..,sorry,I can't help you WWF Let our word health and happy how to validate asp.net2 web page controls by javascript in master content pages zahra yousefi12-Sep-06 1:01 zahra yousefi 12-Sep-06 1:01  hi dear friends, I want to validate asp.net2 web controls (<asp:textbox>) by javascript but but it can not recognized.(document.form1.TextBox1.value) the other point is that content pages dont have form tag, this tag is just in master page while my controls are placed in content page. Please refer me to helpful sites about this case. thank you Regards yousefi Tehran-Iran zahra yousefi yousefi105@yahoo.com Re: how to validate asp.net2 web page controls by javascript in master content pages mbbisht12-Sep-06 1:38 mbbisht 12-Sep-06 1:38  actually when u use masterpage concept asp.net add pageid before each control so for accessing any control from javascript prefix pageid with control u can check pageid by viewsource of your file Mahendra start asp.net programming [modified] zon_cpp12-Sep-06 0:50 zon_cpp 12-Sep-06 0:50  hello! i have problem to create new asp.net web applicatio with VC++ or C#. what settings should be set for my project or iis service? -- modified at 7:00 Tuesday 12th September, 2006 Zo.Naderi-Iran Re: start asp.net programming Sebastien Lachance14-Sep-06 9:26 Sebastien Lachance 14-Sep-06 9:26  Are you using Visual Studio 2005 or 2003 ? My Blog Permissions to Shared folders Bhasker Pinninti12-Sep-06 0:20 Bhasker Pinninti 12-Sep-06 0:20  How can I provide permissions to shared Drive or Network Drive folders from asp.net Page? Any help plz?????????????? Thanks, Bhasker P Re: Permissions to Shared folders Britney S. Morales12-Sep-06 3:57 Britney S. Morales 12-Sep-06 3:57  at iis, there is a asp.net user running all the time, in order to share folders and files in your website, you must to modify the asp.net user access permissions. keep Learning... Re: Permissions to Shared folders Bhasker Pinninti12-Sep-06 5:15 Bhasker Pinninti 12-Sep-06 5:15  ASPNET account gives access to the users under that account. I am using impersonate. So this will identify the current user. This is working fine. How we can authorized the folders from asp.net page using impersonate? Thanks, Bhasker P Scanner in ASP .NET AzDHeX12-Sep-06 0:00 AzDHeX 12-Sep-06 0:00  I'm working on a web application and I have one really BIG problem. I'm just not able to get image from image scanner plugged in the Client computer... And I'm wondering:"Is it possible to create a web application that uses scanners plugged in the Clients, and if it is, how can I create one??"... Please help becouse it's killin' me tnx for any help and replay you post, AzDHeX

Last Visit: 31-Dec-99 18:00     Last Update: 21-Jun-24 3:21 Refresh ᐊ Prev1...5868586958705871587258735874587558765877 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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