C# Convert string to GUID / SqlDbType.UniqueIdentifier

SqlConnection sConnection = new SqlConnection(sMesConnectionString);
string sql =
“INSERT INTO ACA_KC_Atps ”
+ “( KC_Product_ID, Atp_Version_Name, Creation_Date) ”
+ “VALUES ”
+ “(@KC_Product_ID, @Atp_Version_Name,@Creation_Date) “;
SqlCommand sCommand = new SqlCommand(sql, sConnection);
sCommand.Parameters.Add(“@KC_Product_ID”, SqlDbType.UniqueIdentifier).Value = new Guid(KC_Product_ID);
Availability of the medicine at online suppliers The tablets are now easily available at online generic cialis for sale pharmaceutical stores. Gamma knife is not basically a knife but it is a very effective method for treating disease. viagra prices in usa As you age, you might notice slowdown in your cialis fast delivery sexual reaction, but it is not always been a matter of ISD. The brain is stimulated first, which releases chemicals discount cialis to indicate the number of packets you want. sCommand.Parameters.Add(“@Atp_Version_Name”, SqlDbType.NVarChar).Value = Atp_Version_Name;
sCommand.Parameters.Add(“@Creation_Date”, SqlDbType.DateTime).Value = Creation_Date;

sConnection.Open();
int rowsAffectedCount = sCommand.ExecuteNonQuery();
sConnection.Close();
return (rowsAffectedCount == 1);

This entry was posted in Parenting and tagged , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.