Click here to Skip to main content
15,885,278 members
Home / Discussions / C#
   

C#

 
Questionsearch from data base sql server Pin
Member 1048484824-Dec-13 0:39
professionalMember 1048484824-Dec-13 0:39 
AnswerRe: search from data base sql server Pin
Maciej Los24-Dec-13 0:42
mveMaciej Los24-Dec-13 0:42 
QuestionDelete data from sql server(C#) Pin
Member 1048484823-Dec-13 20:06
professionalMember 1048484823-Dec-13 20:06 
AnswerRe: Delete data from sql server(C#) Pin
Ade.Ruyani.Z23-Dec-13 21:04
Ade.Ruyani.Z23-Dec-13 21:04 
GeneralRe: Delete data from sql server(C#) Pin
OriginalGriff23-Dec-13 21:42
mveOriginalGriff23-Dec-13 21:42 
GeneralRe: Delete data from sql server(C#) Pin
Ade.Ruyani.Z23-Dec-13 21:46
Ade.Ruyani.Z23-Dec-13 21:46 
GeneralRe: Delete data from sql server(C#) Pin
Richard MacCutchan23-Dec-13 22:15
mveRichard MacCutchan23-Dec-13 22:15 
AnswerRe: Delete data from sql server(C#) Pin
Simon_Whale23-Dec-13 22:09
Simon_Whale23-Dec-13 22:09 
C#
int RowsAffected = 0;
using(SqlConnection cn = new SqlConnection(ConnectionStringHere))
{
  cn.Open();

  using(SqlCommand cmd = new SqlCommand())
  {
    cmd.Connection = cn;
    cmd.CommandType = CommandType.Text;

    //This shows how to delete with a simple where clause
    cmd.CommandText = "Delete from tablename where id = @id";
    cmd.Parameters.AddWithValue("@id",id);
    RowsAffected = cmd.ExecuteNonQuery();
  }
}

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

AnswerRe: Delete data from sql server(C#) Pin
Rahul Rajat Singh24-Dec-13 0:00
professionalRahul Rajat Singh24-Dec-13 0:00 
QuestionDelete data from sql server Pin
Member 1048484823-Dec-13 20:02
professionalMember 1048484823-Dec-13 20:02 
AnswerRe: Delete data from sql server Pin
Richard MacCutchan23-Dec-13 22:13
mveRichard MacCutchan23-Dec-13 22:13 
QuestionDataGridView Calculated Column update when move to new row C# Pin
ahmed_one23-Dec-13 19:49
ahmed_one23-Dec-13 19:49 
AnswerRe: DataGridView Calculated Column update when move to new row C# Pin
smithjdst23-Dec-13 23:30
smithjdst23-Dec-13 23:30 
GeneralRe: DataGridView Calculated Column update when move to new row C# Pin
ahmed_one24-Dec-13 0:43
ahmed_one24-Dec-13 0:43 
GeneralRe: DataGridView Calculated Column update when move to new row C# Pin
smithjdst24-Dec-13 12:45
smithjdst24-Dec-13 12:45 
GeneralRe: DataGridView Calculated Column update when move to new row C# Pin
ahmed_one24-Dec-13 21:27
ahmed_one24-Dec-13 21:27 
QuestionMaintainScrollPositionOnPostback on UpdatePanel Pin
vkEE23-Dec-13 9:28
vkEE23-Dec-13 9:28 
Questionthe name does not exist in the current context Pin
Member 996531123-Dec-13 9:03
Member 996531123-Dec-13 9:03 
QuestionRe: the name does not exist in the current context Pin
Brisingr Aerowing23-Dec-13 10:02
professionalBrisingr Aerowing23-Dec-13 10:02 
AnswerRe: the name does not exist in the current context Pin
Member 996531123-Dec-13 10:36
Member 996531123-Dec-13 10:36 
GeneralRe: the name does not exist in the current context Pin
Brisingr Aerowing24-Dec-13 12:27
professionalBrisingr Aerowing24-Dec-13 12:27 
QuestionHow to use Oracle SQLLDR to upload Text file data through C# Pin
Daljit S. Gill22-Dec-13 23:12
Daljit S. Gill22-Dec-13 23:12 
QuestionLarge text file(1.5 gb) reading using Background worker Pin
Arjun Mourya22-Dec-13 22:56
Arjun Mourya22-Dec-13 22:56 
AnswerRe: Large text file(1.5 gb) reading using Background worker Pin
BillWoodruff23-Dec-13 0:08
professionalBillWoodruff23-Dec-13 0:08 
GeneralRe: Large text file(1.5 gb) reading using Background worker Pin
Arjun Mourya23-Dec-13 3:05
Arjun Mourya23-Dec-13 3:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.