it doesnt seem to insert anything?
{
string theUserId = Session["UserID"].ToString();
OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=gymwebsite; User=x; [code].....
my webserver is in the DMZ. The Database in the intranet. For connection from webserver to database the following entry is made in the odbc connection "TCPIP BCAST=NO;HOST=Intranet.Firma.local,Intranet_Spiegel.Firma.local,Intranet_Arbiter.Firma.local;PORT=2639}"
how to get this options in the connection strings working, or how i must modify the entitiy framework connection string to use the odbc entry?
<add name="KA_Entities" connectionString="metadata=res://*/Models.KA_Model.csdl|res://*/Models.KA_Model.ssdl|res://*/Models.KA_Model.msl;provider=iAnywhere.Data.SQLAnywhere;provider connection string="UserID=user;Password=password;DataSourceName=Databasename""
providerName="System.Data.EntityClient" />
<add name="KAPortal" connectionString="UserID=user;Password=password;DataSourceName=Databasename" providerName="iAnywhere.Data.SQLAnywhere" />
I tried to use odbcfor the entity framework, but the Wizard always add the right .NET Provider and not the odbc
Disable an Insert button after the insert operation is complete.
Right now, I have onclick event for button that disables the button immediately without executing the insert code.
My code is to update a record if it already exists in database else insert as a new record. My code is as follows:
protected void Button3_Click(object sender, EventArgs e)
{
OdbcConnection MyConnection = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=testcase;User=root;Password=root;Option=3;");
MyConnection.Open();
String MyString = "select fil_no,orderdate from temp_save where fil_no=? and orderdate=?";
OdbcCommand MyCmd = new OdbcCommand(MyString, MyConnection);
MyCmd.Parameters.AddWithValue("", HiddenField4.Value);
MyCmd.Parameters.AddWithValue("", TextBox3.Text);
using (OdbcDataReader MyReader4 = MyCmd.ExecuteReader())
{
//**
if (MyReader4.Read())
{
String MyString1 = "UPDATE temp_save SET order=? where fil_no=? AND orderdate=?";
OdbcCommand MyCmd1 = new OdbcCommand(MyString1, MyConnection);
MyCmd1.Parameters.AddWithValue("", Editor1.Content.ToString());
MyCmd1.Parameters.AddWithValue("", HiddenField1.Value);
MyCmd1.Parameters.AddWithValue("", TextBox3.Text);
MyCmd1.ExecuteNonQuery();
}
else
{
// set the SQL string
String strSQL = "INSERT INTO temp_save (fil_no,order,orderdate) " +
"VALUES (?,?,?)";
// Create the Command and set its properties
OdbcCommand objCmd = new OdbcCommand(strSQL, MyConnection);
objCmd.Parameters.AddWithValue("", HiddenField4.Value);
objCmd.Parameters.AddWithValue("", Editor1.Content.ToString());
objCmd.Parameters.AddWithValue("", TextBox3.Text);
// execute the command
objCmd.ExecuteNonQuery();
}
}
}
I am getting the error as: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.51-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,orderdate) VALUES ('04050040272009',' &' at line 1
The datatype for fields in table temp_save are:
fil_no-->INT(15)( to store a 15 digit number)
order-->LONGTEXT(to store contents from HTMLEditor(ajax control))
orderdate-->DATE(to store date)
deleted old code
View 3 RepliesHow do I get the filepath out of my code and into a insert statement for mysql?
protected void UploadButton_Click(object sender, EventArgs e)
{
string theUserId = Session["UserID"].ToString();
[code]...
i have to insert a "Google Analytics Tracking Code" java script to all pages in my website, before </body> tag.There is no master pages so i could not use them. Is there any way to insert a code from global.asax into all pages? If i use application_endrequest then it goes to the very last line which is after </html> tag.
View 3 RepliesI have an Insert into function returns the error Syntax error (missing operator) in query expression when text the single quote is send to the access db from a form.
' I need to replace this with the ascii ' before the query is sent.
here is the scode
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%Response.Buffer=True%>
<!-- #include file="Conn.asp" -->
[Code].....
here I need to handle fields having the only character is the single quote
I converted code from VB that works to c# to insert a record in an SQL daTA BASE.
The VB code is as follows:
Insert a new record into Contact
Dim connectionString As String = ConfigurationManager.ConnectionStrings("aspnetdbConnectionString").ConnectionString
Dim insertSql As String = "INSERT INTO Contact(UserId, Notes) VALUES(@UserId, @Notes)"
Using myConnection As New SqlConnection(connectionString)
[Code]....
There is a DIV in my page that will be updated via AJAX calls. However, I want to make to enter the initial text into this DIV from code behind. How do I do this?
View 4 RepliesI fear this has been beaten to death, but I'm still struggling with the problem of reading Excel files in my ASP.NET application that has recently been ported to Server 2008 and 64-bit.Many posts I find point to the existence of 64-bit Microsoft drivers here:here and here. My concern is the warnings I'm also reading about these not intended "As a replacement for the Jet OLEDB Provider in server-side applications" possibly for thread-safe reasons? This IS a server-side application and while Excel uploads aren't hundreds-of-times-a-day ocurrances, they will be done by customers.I know there are also commercial libraries available and while I'm opening to considering them I do worry about the 'revision chase' and not getting burned by them going belly-up (it has happened to us before).
View 2 RepliesI am using updatepanel in aspx with master page content, required validation control. IN that updatepanel I have one datagrid through that I am trying to insert a row. When I click that linkbutton then is shows error like "sys.webforms.pagerequestmanagerparsererrorexcepti on. Error code: 405" . I tried with another project this code works fine. How to overcome this. Some times error code 12031 also appear in prompt window. Error Received: The HTTP verb POST used to access path '/PMS/Marketing/' is not allowed. Stack Trace: at System.Web.DefaultHttpHandler.BeginProcessRequest( HttpContext context, AsyncCallback callback, Object state)
at System.Web.HttpApplication.CallHandlerExecutionSte p.System.Web.HttpApplication.IExecutionStep.Execut e() at System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously)
Source:System.Web
Origin: [URL]
Target Site:System.IAsyncResult BeginProcessRequest(System.Web.HttpContext, System.AsyncCallback, System.Object)
Exception Thrown @7/26/2010 10:11:21 PM
Using sql server and trying to insert decimal values using a ASP.NET C# code. I get the value for hours from a text box through user input and I'm trying to insert it to the database.
strSQLWAUpdate = " UPDATE Project SET WAHours='" + txtWAHours.Text + "' WHERE WAProjectID='" + hidWAProjectID.Value + "' ";
What happens is it rounds off the hours to interger value. So if I insert 22.3 in the text box what i get in the database is 22 and if I insert 22.7 I get 23 in the database. I do not need any rounding but need to get the values as it is. ( that is 22.3 and 22.7 respectively)
I haven't done much C# programming in a year - now I can't remember how to insert button click event code into the code behind page for an asp.net button in the html side. I know there's a slick way to do it, bit I can't find it anywhere. I remember that it automatically created the event code from the, for example, Button1 element. The event would then be Button1_Click(...).
Actually used to use Sql server, for that I add parameters like this
com.Parameters.Add("Field1",SqlDbType.Nvarchar,50).value=TextBox1.Text.
that works fine. but while using MSaccess and the datatype for of some table is Memo than how could I use parameter for that i am using System.Data.Odbc. cos here it is easy to do SqlDbType.Nvarcha cos there is shows Nvarchar but not Memo
I'm thinking the problem here is with my SQL Syntax, but I'm not sure and need a fresh pair of eyes to check it out. This is the code I'm using to connect to and then insert into the DB:
OdbcConnection datConn = CreateDataConn();
datConn.Open();
OdbcCommand comm = new OdbcCommand();
comm.CommandText = "INSERT INTO userdata (key, secretkey, uid) VALUES ('" + token + "', '" + secret + "', '" + twitterid + "');";
comm.Connection = datConn;
comm.ExecuteNonQuery();
datConn.Close();
And here is the CreatDataConn() method:
private OdbcConnection CreateDataConn()
{
OdbcConnection dbConn = new OdbcConnection();
dbConn.ConnectionString = "Dsn=MySQL;database=twittertest;option=0;port=0;server=localhost;uid=root;pass=Red!4jedi";
return dbConn;
}
I created a DSN to the database, which is hosted on my machine. When I run the application I get this error:
ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.51-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, secretkey, uid) VALUES ('127090765-i3aZl71LPSVUCPZs9kHSYeBli0vWpbq0BaM1roYC' at line 1
But for the life of me I can't figure out what's wrong with my syntax...It's prolly something simple, but again, I need a pair of fresh eyes to look at this.
I have been developing my ASP.NET web pages to access the SQL database locally on my personal computer while using a "SqlConnection", but to access my SQL database on a host server, I must use a "OdbcConnection". I am mostly using LINQ to access data with a DataClassesDataContext, but sometimes I must use ADO with SqlConnection and SqlCommand. What must I do to convert my C# code in order to access data with ODBC 3.51?
View 2 RepliesI have a system DSN.How to connect to the database in asp.net using DSN.I wanted the Connection String
View 2 RepliesI would like to connect oracle via ODBC. I downloaded the dll and add as reference.
Here is the sample code:
Dim cn As OdbcConnectioncn = New OdbcConnection("PROVIDER=MSDAORA; DATA SOURCE=aaa; USER ID=aaa; PW=aaa;")
But getting this error "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
I am working on an asp webform that pulls from an ODBC datasource then puts the data in an sql server. Once the data is in the sql server several queries pull data from it to provide information for a report.
This is an example of what I am talking about private void ODBCpdEmployeeAb()
{ [code].....
The first part gets the data from the ODBC connection and the next part stores it in an sql server table.
I have set the primary keys on my SQL server tables already but it just loads an error page now when the app runs due to duplicate id's
Is there a way to append the most recent data from the ODBC table to the sql server ?
i want to insert some html code like
<html><body>jhguyegjh<?body></html>
but it is not inserting
I can't find my syntax error. Here is my code behind:
[Code]....
What is the correct code syntax to insert Row of Data.
How do we remove the syntax errors (i.e., '>' expected, and 'declaration expected')?
What is the correct code?
Read example, below:
[Code]....
i need some detail about ole and odbc.. what diffrence between ole and odbc
View 4 RepliesI've been trying for 3 hours to figure this out... Basically I'm trying to incorporate this script into my personal website which is built using .NET Master Pages...
The link to the demo is here [URL]
I copied this guys code and built locally on my machine to test. Works find UNTIL you convert the HTML to ASPX and add the <form runat="server"></form> tags. Is there a work around for this or a method that works better? I'm trying to understand how to properly insert such code into a .NET website for both now and future purposes.
[code]....
