fter much reading and trying I still cant seem to get this to work:OdbcCommand cmd = new OdbcCommand("INSERT INTO User (Email) VALUES ('rusty@msn.com'); SELECT LAST_INSERT_ID();", cn);
cmd.ExecuteNonQuery();
sing (OdbcDataReader reader = cmd.ExecuteReader())
string theUserId = String.Format("{0}", reader.GetString(0));
Label10.Text = theUserId;
[code]...
I am having a problem in inserting characters such as a name into a mySql database via an Asp.net application.
If I inserted numbers, the app adds the numbers into the database and I can see them, but the case with names, the name column in the database shows no values (keeps on showing null values) along with the numbers added.
command2 = New MySqlCommand("INSERT INTO customer(Customer_id, Customer_name) VALUES (@Customer_id, @Customer_name)", Connection) // Connection String
command2.Parameters.AddWithValue("@Customer_id", SqlDbType.Int).Value = TextBox1.Text() //assign values
command2.Parameters.AddWithValue("@Customer_name", SqlDbType.VarChar).Value = TextBox2.Text() //assign values
I have an asp.net page connected to a MySql DB.When I try to insert/update values from the webpage into the DB the chars are shown in the DB as question marks (I am using SP).If i will write a query directly in the DB, It will work and the chars will be displayed correctly.
The DB default charset is utf8, and the column collation is utf8_general_ci.
is dere any way that i can store or insert images into the mysql database and retrieve them successfully just like textual data.
View 1 Replieshow can i insert special characters (appostraphe) with names into mysql database now i am getting error when i enterd.
View 3 Repliespublic void Add(IDataProvider provider){
var key=KeyValue();
if(key==null){
var newKey=_repo.Add(this,provider);
this.SetKeyValue(newKey);
}else{
_repo.Add(this,provider); //NullReferenceException was unhandled by user code
[Code]....
i was just using mysql i installed mysql and mysql net connector. its installed successfully but unable tp add to references.
View 3 RepliesWith performance counter to observe the "Sessions Total", I found the # of session stays the same after users logout. Is this expected behavior in IIS7?
Here is the logout implementation:
Session.Clear();
Session.Abandon();
FormsAuthentication.SignOut();
[code].....
with this code i get the horizontal scroll bar.. however.. the vertical scroll bar remains disabled.. and the listbox control extends till the end of the window..!
I am using the ASP.NET Ajax controls UpdatePanel and UpdateProgress. The idea of a the UpdateProgress control is to display a message while the page is performing a partial postback, then disappear when the postback completes. On Firefox and Internet Explorer, this happens correctly. However, on Safari and Chrome the UpdateProgress control remains visible after the postback completes. Is this a bug in the ASP.NET Ajax Framework, or is there another workaround?
View 1 RepliesI have come unstuck with a simple compare validation.
I have the following code
<asp:TextBox ID="tbxHowMany" runat="server"
style="z-index: 1; left: 310px; top: 385px; position: absolute; text-align: center;"
Width="75px"></asp:TextBox>[code]....
So when a user enters a figure higher than 200, the validation appears.However, when I change this figure to say, 30, the validation remains. I must be doing something really stupid, I just don't know what!
UPDATE: I have also just noticed that this validation occurs when a number greater than '20' is entered into the checkbox. I'm not very confused. I am assuming this is a type issue?
Why does a very simple script which inserts 26,000 records into a mysql database (myisam, no transactions) take 13 seconds in the php implementation, and then 35-50 seconds using mono+mysql connector? I thought asp.net was faster than php? Could the problem be the mono mysql connector is "platform independent", so the performance just stinks? or does asp.net suffer more overhead than php when it comes to executing each query? Aren't there any native linux binaries for mysql connector for mono that may be faster?
View 1 RepliesIn a page hving some textboxes and dropdownlists with every control having server side validation controls.On selecting a dropdown all the validation controls are disappear and on clicking the save button the page remains idle.
View 3 RepliesI am using ASP.NET 2.0 with VB. In design view of grid, i have one textbox in its template field. I also have one Ajax Calender Extender and FilteredTextBox Extender. I have set target controlId of both calender and filteredtextbox extender equal to that textbox. Now dynamically i dispose one of the extender from that textbox. everything works ok. But once my page reloads it takes the original design image, means both extenders are being set to that textbox.
View 1 RepliesI have used ASD.NET code using SQL Database for Transaction operation successfully. By changing the Database Code to interface with MYSQL an Error occurs. If I remove the Transaction Code from within the the application, it works OK by displaying the MYSQL data (Read Only) in the layout of the application. I am using Mysql Essential-4.1.22-win32 and MYSQL Connector ODBC-3.51.2. My objective is to EDIT the MYSQL Data.
View 8 RepliesI have a page which has menu of the items on the left and the content page on the right. Since, master page is used, there is a few content on the footer of the master page.As a default, the left menu shrinks but as you expand the menu tree, the menu items goes down and down. But the footer of the master page remains there so that its ugly looking.IS there any way to push the footer of the master page also below and below as the menu items grow and grow (moves below and below)
View 6 RepliesI have asp.net webpart page with close and minimize buttons for the webparts.
These buttons are disappering if page remains idle for 1 hour
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)
I am trying to insert html pages to MySQL with my Asp.NET project but i am getting error; 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 'de Osman patlaması', '', '<div style="text-align: center"> <img src="/i' at line 1
How can i fix that problem my server side code is;
MySqlConnection myCon = new MySqlConnection();
myCon.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = CommandType.Text;
string query = @"INSERT INTO `test`.`posts` (`id`, `author`, `title`, `description`, `content`, `ispublished`, `iscommentsenabled`, `pubDate`, `lastModified`, `raters`, `rating`, `slug`, `tags`, `categories`) VALUES (NULL, '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}')";
query = String.Format(query, p.author, p.title, p.description, p.content, p.ispublished, p.iscommentsenabled, p.pubDate, p.lastModified, p.raters, p.rating, p.slug, p.tags, p.categories);
cmd.CommandText = query;
cmd.Connection = myCon;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();..............
I am needing to have a music player (something like a strip down at the bottom of the page that goes all the way across), that remains at the bottom even when the user navigates to another page within the same site.The purpose of this is to play music on the website no matter where the user goes on the website.
View 1 RepliesI've made a membership by create user wizard. everything is good but after click on finish register button, when page redirect to index .aspx, this page thinks tht user logged in. whereas user didnt login just added to DB.here is the code:
protected void CreateUserWizard1_NextButtonClick(object sender, WizardNavigationEventArgs args)
{
try
{
Membership.CreateUser(CreateUserWizard1.UserName, CreateUserWizard1.Password, CreateUserWizard1.Email);
Response.Redirect("index.aspx");
[code]...
Â
in index.aspx just have a login name and login status control. tht's it.
is there anyway i can connect to MySql through WebMatrix using asp.net
View 3 Replies i want to populate my menucontrol with data from my mysql db. It seems hard to find anything on the net that is not in C# and mssql.
I actually want to have all my parentnodes and childnodes in one table, but i have found an example where they use 2 tables, 1 holding the parentnodes and 1 for the childnodes, so i try this way first. It was written in C# and MsSql but i have tried to convert it. Here is my code so far. The result is that the my page is blank, no errors or anything, but the menu won't show?What have i done wrong?
My 2 tables:
In my aspx page: <asp:Menu ID="Menu1" runat="server" Orientation="Horizontal">
My vb code:
Code:
Imports MySql.Data.MySqlClient
Imports System.Data
[code]....
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 want to use MySQL as database server for my ASP.net website but don't know how can I write connection string for connecting database.
View 1 Replies