|
how to use rollback mysql database in asp.net.
public void RunTransaction(string myConnString)
{
MySqlConnection myConnection = new MySqlConnection(myConnString);
myConnection.Open();
MySqlCommand myCommand = myConnection.CreateCommand();
MySqlTransaction myTrans;
myTrans = myConnection.BeginTransaction();
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans;
try
{
myCommand.CommandText = "insert into Test (id, desc) VALUES (100, 'Description')";
myCommand.ExecuteNonQuery();
myCommand.CommandText = "insert into Test (id, desc) VALUES (101, 'Description')";
myCommand.ExecuteNonQuery();
myTrans.Commit();
Console.WriteLine("Both records are written to database.");
}
catch(Exception e)
{
try
{
myTrans.Rollback();
}
catch (SqlException ex)
{
if (myTrans.Connection != null)
{
Console.WriteLine("An exception of type " + ex.GetType() +
" was encountered while attempting to roll back the transaction.");
}
}
Console.WriteLine("An exception of type " + e.GetType() +
" was encountered while inserting the data.");
Console.WriteLine("Neither record was written to database.");
}
finally
{
myConnection.Close();
}
} this code is not workin
http://dev.mysql.com/doc/refman/5.0/es/connector-net-examples-mysqlconnection.html#connector-net-examples-mysqlconnection-begintransaction1
plz help....
|
|
|
|
|
Hi ,
is it giving any error to u??
Thanks ,
amit
|
|
|
|
|
it went to catch for rollback but my database got updated.
|
|
|
|
|
bhavnvyas wrote: it went to catch for rollback but my database got updated.
If it go to Exception ,then only the transaction will fails..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
bhavnvyas wrote: this code is not workin
Try this One..!
http://www.codeproject.com/KB/database/transactions.aspx
|
|
|
|
|
but i am using mysql
its not going in my catch for rollback....
|
|
|
|
|
Great ..! Then the Query may change ..!
I dont know much abt mysql..! Check tht it supports with this code..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
|
Dont get Too Confuse..!
Ask the same question to the author who wrote the article..!He May Help You..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
|
With Eval function, i am able to parse JSON string in IE and Chrome. But i am not able to parse json string using Eval function in Firefox. Can you please give the code to solve this problem.
|
|
|
|
|
Are you parsing JSON in client?
What error you are getting. Can you show the JSON string ?
Are you doing like this
var jsonOBJ = eval('(' + data + ')');
I think it works in Firefox as well..
|
|
|
|
|
this is my json string. I am using the eval function the same you have show.
Example of json string
{"Store":[{"Store_id":1325,"StoreName":"s1","StoreCode":1}]}
|
|
|
|
|
But when I try this, it works perfectly in firefox as well.. .
I used
function elemJSON() {
var elem = '{ "Store": [{ "Store_id": 1325, "StoreName": "s1", "StoreCode": 1}] }';
var jsonobj = eval('(' + elem + ')');
alert(jsonobj.Store[0].Store_id);
}
<br />
<input type="button" onclick="elemJSON();" value="JSON Parse" />
and it showed me 1325 in both the browsers(IE And FF)...
|
|
|
|
|
thanx a lot abhisekh, it worked...
|
|
|
|
|
pavankumarchakilam wrote: thanx a lot abhisekh
Here Its a Tradition to mark it as answer if it worked for u..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Hi Coders
My Problem is that Image store in database in binary format and I want to display in a gridview but unable 2 do so.
If u do this with use of LINQ that is best for me.Anyway u are free to do this with any method.
any help would be appreciated
Thanks
Amit Gautam
|
|
|
|
|
gautamamit8 wrote: f u do this with use of LINQ that is best for me.
Then You have to post in job task..!This forum is for helping to others not to do their work ..!
If You are stuck with some where then we can help you..!
What You had done until now ..?Where did you stuck..!
try this link..!
Displaying Image in Gridview from Database[^]
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Till now I store the single image in binary format in database. Even , I can show the image from database single but I dont know how to show them in Grid.
The Article Link u given to me is for display image via using path of the Image not in binary format.So that is not helpful and Secondly I'm not here to get complete my work from others I just need a help or a point where i can solve my problem.
Thanks for urs kind interest
Amit
|
|
|
|
|
|
|
|
What is the error that you are getting??
|
|
|
|
|
He did not get any error because he dont know how to start..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
//upload image
public void OnUpload(Object sender, EventArgs e)
{
int len = Upload.PostedFile.ContentLength;
byte[] pic = new byte[len];
Upload.PostedFile.InputStream.Read (pic, 0, len);
SqlConnection connection = new
SqlConnection (@"server=INDIA INDIA;database=iSense;uid=sa;pwd=india");
try
{
connection.Open ();
SqlCommand cmd = new SqlCommand ("insert into Image "
+ "(Picture, Comment) values (@pic, @text)", connection);
cmd.Parameters.Add ("@pic", pic);
cmd.Parameters.Add ("@text", Comment.Text);
cmd.ExecuteNonQuery ();
}
finally
{
connection.Close ();
}
}
//load image
private void Page_Load(object sender, System.EventArgs e)
{
MemoryStream stream = new MemoryStream ();
SqlConnection connection = new
SqlConnection (@"server=INDIA INDIA;database=iSense;uid=sa;pwd=india");
try
{
connection.Open ();
SqlCommand command = new
SqlCommand ("select Picture from Image where id"], connection);
byte[] image = (byte[]) command.ExecuteScalar ();
stream.Write (image, 0, image.Length);
Bitmap bitmap = new Bitmap (stream);
Response.ContentType = "image/gif";
bitmap.Save (Response.OutputStream, ImageFormat.Gif);
}
catch
{
string strblandImagePath = Server.MapPath("");
strblandImagePath += "NoImg.gif";
FileStream FileBlandImagestream = File.OpenRead(strblandImagePath);
Bitmap bitImage = new Bitmap(FileBlandImagestream);
Response.ContentType = "image/gif";
bitImage.Save(Response.OutputStream, ImageFormat.Gif);
}
finally
{
connection.Close ();
stream.Close ();
}
}
modified 27-May-14 5:11am.
|
|
|
|