I am connecting to a MYSQL database from asp.net just to see if a user exist. Sometimes this script works, other times it wont...
Code:
Imports System.Data
Imports System.Data.Odbc
Imports System.Configuration
Imports Utils
Partial Class member
Inherits System.Web.UI.Page
[code]......
I 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 was just using mysql i installed mysql and mysql net connector. its installed successfully but unable tp add to references.
View 3 RepliesWhy 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 RepliesI know this is probably a pretty easy thing to do and it is if I can upload the file and store it onto the hard drive of the server. What I need to do is read the text file into memory and then parse through it one line at a time. Anyone have any code that demonstrates that?
View 8 RepliesMy 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 developed a web site more then a year ago with .net2.0/c#/mssql 2005. it works fine but i was asked to replace mssql with mysql.
I wrote a class to complete data access works (unfortunately, I didnt use nhibernate or other data access tools :((
I edited the class to use System.Data.Odbc objects rather than System.Data.SqlClient.
It works fine in selecting data but not manipulating data. when i try to insert new data it adds null data for all fields in the table.
in debug mode, i noticed that it might be caused by OdbcParameter but not sure.
I was trying to go through this tutorial:
[URL]
but when I tried to add the service reference to the silverlight app, the Add Service Reference window would show me that there was a service file, but the node wouldn't expand to show the rest of the files that contain the services and what not. I got this error instead:
"An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately."
"Parser Error Message:There is no service behavior named 'AdventureWorks_WebServer.Service1Behavior'."
"Metadata contains a reference that cannot be resolved: 'http://localhost:55579/Service1.svc'.
The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.
If the service is defined in the current solution, try building the solution and adding the service reference again."
here's my web.config file:
[Code]....
in other words, reading the content (records that lies within) of a LinqDataSource object programatically (i.e. similar to what the GridView class does internally when binding to a LinqDataSource object).
View 4 RepliesHow get data from mysql database? I use ASP.NET and C#.Previously, I used LINQ but it does not work with mysql database
View 2 RepliesI am looking for opinions and best coding practices.I need to get info from a database with a query such as SELECT this, that FROM MyDB (returning 2 fields). Would it be wrong to use a hashtable for temporary storage?Is there a better way to accomplish the same thing? What about if I am returning more than 2 fields, would it be best to step up to a DataSet or something?
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
GetData();
[code]...
I have a databound gridview with 3 columns. I enumerate through each row to get values and put into an array. I would like to make column1 NOT visible to the user. but when I set Visible="False", it no longer can retieve that columns value as it enumerates.
Is there a way I can make the first column invisible to the user but still retrieve the values of that column when enumerating?
I have a client that provides a .xls file on their site that we have no control over that we download the file and then read it to update inventory. The first column is the SKU and in cell A2 it has the value 1028. This outputs fine but when I get to A8 the value is '1051-LV' and in my output it is blank. I am thinking in my dataset it reads A2 value and that becomes the type for the remainder of the rows. But what if that is wrong? How do I fix so it doesn't set the datetype to say int when it could be a string type?
Below is my code and works but the output of certain rows sku values are blank and are not like that in the excel file.
Code:
Protected Sub btnGetExcelFile_Click(sender As Object, e As System.EventArgs) Handles btnGetExcelFile.Click
litOutput.Text = ""
Dim ws As New WebPost
ws.URL = "http://www.domain.com/dropship/feed.xls"
'downloads excel file based on url
Dim bExcel() As Byte = ws.RequestBinaryData("", True)
[Code] ....
I am importing Excel file data into gridview control,i want to insert same grid view data into mysql database.I have plenty of excel files in my root folder, these excel files always update with new data.
View 3 RepliesI have a MySQL database, and I'm currently creating an ASP.NET website to update data in it. I'm currently having trouble changing the data with GridView. Reading through various posts on this site, i think I've got a problem with binding the data, but I'm not sure how to accomplish this with MySQL database. My c# code is as follows:
[Code]....
My asp code is as follows:
[Code]....
At the moment I'm getting an error about the "trash" data, it's an Int32 field, but I'm not sure how to handle that.
I have 13 checkbox which is consist of outlet locations, The way i store into database is converting the 13 outlet code and store in string type which is need to split it when the need to view it.
My problem now is, i would like get any releated outlet code checked into checkbox which is the outlet code store into mysql in same column and row. for example:
Outlet code store into my cLocCode column inside table itemdetail. The data inside store in string type:
|cLocCode |productcode |
|200,201,202,203,204,205 |xxxxxxxxxxxxxxxxxx |
As all of u can see the cLocCode store as string. I would like to load it into web form as checkbox which is like this:
x Checkbox200.Checked x Checkbox201.Checked x Checkbox202.Checked x Checkbox203.Checked
x Checkbox204.Checked x Checkbox205.Checked x Checkbox 206.Unchecked
this is the situation.
1)table student
studentno varchar(50)
hobby1 varchar(40);
hobby2 varchar(40);
hobby3Â varchar(40);Â
2)if record in data database such that
hobby1Â hobby2Â Â hobby3 in this maximum is one must be chose
like
here studentno hobby1 hobby2  hobby3
          1            cricket  null        null     Â
          2            null     hockey    null
          3            null      null       tennis
if i want to write function in mysql if i pass the studentno
i want to get the hobby of respective student
like select functionname(1)
your hobby is cricket
like select functionname(2)
your hobby is hockey
ike select functionname(3)
your hobby is tennis
what is the uniqueidentifier data type equivalent in mysql
View 1 RepliesI am building a webpage with a load of controls on, textbox, dropdownlist etc.
I want to be able to pass the data entered in those controls on webpage1 onto another asp page when a button on webpage2 is clicked.
I can't seem to work out how to reference the controls from webpage one, so I can read them into variables in webpage 2.
Is there anyone who can give some advice on this, I am coding in C# but can work it out from VB.
I'm curious is there any way to read xml from sql server by using LINQ TO XML,,, xml contained in xml field in sql server 2008 and i'm using VS2010.
View 5 RepliesFrom some reasons I added virtual directory to my site- e.g. the entire site running under one domain and one part from another and different folder. I need to read some data that's stored in the main root of the site in text file... but the .NET frame work (and I think iis itself) doesn't give simple access to another folder that declared as different site.
Are there is a way to read the text file? Let's say my main site is-www.domain.com and the virtual directory is-www.domain.com/newsite, (the folders are different, off course, even in different disks) can I get text data from the main root?
I am using Linq to read data from the database, the database has 5 coloumns.Here is the code that I am using to read from the database.
[Code]....
Now, I call this method as : var retrieved_Data = objDataMgrClass.ReadData();Now comes the problem that I am facing how to read each coloumn from this var retrived_Data??? I have tried using foreach loop but i keep getting an error : foreach statement cannot operate on variables of type 'object' because 'object' does not contain a public definition for 'GetEnumerator'.The foreach loop i have used as:
[Code]....
Is there any way to import XLS data into MySQL database which is have similar table structure..?
View 2 Repliesi am trying to use MySQL 5 and asp.net 4
i succeed withe the linking and display the data from MySQL DB but the problem is within the DML Commands !!
[Code]....