delete with the use of stored procedure code in .net and sql

-
private void button4_Click(object sender, EventArgs e)
{
string constr = "Data Source=NOBEL-PC\\SQLEXPRESS;Initial Catalog=db_ecommerce;user id=rupak;password=rupak";
SqlConnection sqlcon = new SqlConnection(constr);
string query = "deleteproduct";
SqlCommand scmd = new SqlCommand(query, sqlcon);
scmd.CommandType = CommandType.StoredProcedure;
scmd.Parameters.AddWithValue("@id", myid);
try
{
sqlcon.Open();
scmd.ExecuteNonQuery();
MessageBox.Show("Data Deleted");
}
catch (SqlException se)
{
MessageBox.Show(se.Message);
}
sqlcon.Close();
}

Comments

Post a Comment

Popular posts from this blog

Opencart error: Notice: Trying to access array offset on value of type null in ..../vendor/scss.inc.php on line 1753

-
Image
If you see an error in opencart like below: Notice: Trying to access array offset on the value of type null in .../vendor/scss.inc.php on line 1753 then the solution is: Open the file  .../vendor/scss.inc.php and go to line as given in the above case it is 1753 where you will see code like below: foreach ($args as $arg) {     list($key, $value) = $arg;     $key = $key[1];     if (empty($key)) {         $posArgs[] = $value;     } else {         $keyArgs[$key] = $value;     } } Then change the line to the following, the changes done is in bold.  foreach ($args as $arg) {     list($key, $value) = $arg;     if (!empty($key[1])) {         $key = $key[1];     }     if (empty($key)) {         $posArgs[] = $value;     } else {         $keyArgs[$key] = $value;     } }    
Read more

Creating Class Templates

-
Image
Creating Class Templates Class templates are useful for creating abstract data types, which can then be used to create classes based on specific data types. For example, you can use a linked list template to parameterize the data that is held at each of the link list's nodes. You can use class templates to create collection templates, create new data types, and modify existing data types. This section includes the following topics: Class Template Syntax Class templates are composed of three elements: ® The template keyword ® A comma-delimited list of formal parameters, enclosed in angle brackets ( <> ) ® The class definition A class that is generated from a template is sometimes called a templated class. You can use class templates to modify existing classes. For example, you can define a class template that adds reference counting to an object as follows: template <class T> class TCount { int m_count; T m_type; public: TCount(
Read more

Fixed: Opencart installation error linux: warning: fopen(system/storage) failed to open stream: Permission denied

-
Image
Warning: fopen(/var/www/html/webocreation.com/system/storage/session/....): failed to open stream: Permission denied in /var/www/html/webocreation.com/system/library/session/file.php on line 29 Warning: flock() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 31 Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 33 Warning: fflush() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 35 Warning: flock() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 37 Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 39    These errors occurs because of the file permissions. In most of the forum, I found that they suggested to give full
Read more