Delete button coding for C#

Question

0.00/5 (No votes)

See more:

Hi,
I have created the form, in that added four buttons namely Add,Edit,Delete,Block.If i'm clicking the add button the add form is diplayed.If i'm clicking Edit button the empty form is displayed for me it should open the form with all details.The same process for edit,delete and block...

Regards
Balamurugan

Posted 4-Oct-12 0:53am

bala1989

Add a Solution

Comments

[no name] 4-Oct-12 7:05am

When i'm clicking the edit button it should bind all the values.For that i need coding...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

iyalarasi · Answer 1 · 2012-10-04T02:01:00

you can write everything is same to edit,delete but the only changes in cmd line

In page load you have to reterive the data's from table.

C#

SqlCommand cmd=new SqlCommand("select * from UserCreation");

and for edit something you need to update your database with cmd as

C#

SqlCommand cmd=new SqlCommand("update UserCreation set columnname2= '"textbox2.Text'",columnname3='"textbox3.Text'" where columnname1= '"textbox1.Text'" ");

similarly for delete something you also need to delete from database with cmd as

C#

SqlCommand cmd=new SqlCommand("delete from UserCreation where columnname1= '"textbox1.Text'" ");

This is simple model I think you may get some ideas.

solanki.net · Answer 2 · 2012-10-04T00:58:00

Solution 1

On click of Edit button its displyainng empthy form because page is post back .so on click of Edit button u should bind your data with controls .

Posted 4-Oct-12 0:58am

solanki.net

Comments

[no name] 4-Oct-12 7:05am

When i'm clicking the edit button it should bind all the values.For that i need coding...

solanki.net 4-Oct-12 7:14am

can i show your code what r u writing on click of Add button ?

solanki.net 4-Oct-12 7:32am

k, Now on Edit button click event u should hit database for getting result(select * from tableName) and from front end u will have to send id(id of record that u want to edit ) .according to that id u will get datatable .
then u can bind your controls with table columns.

[no name] 4-Oct-12 7:36am

I can't get ur answer could u explain clearly...

[no name] 4-Oct-12 7:41am

could u explain with the coding....

solanki.net 4-Oct-12 7:59am

same thing u will have to do .
change here only
SqlCommand cmd = new SqlCommand(" write query here for selecting data " );
sqlDataAdapter sda=new sqlDataAdapter (cmd);
DataTable dt=new DataTable();
sda.fill(dt);
then u can bind your controls
ex: textbox1.Text= dt.Rows[0][0].ToString();

[no name] 4-Oct-12 7:23am

Ya sure the code follows,

private void button1_Click(object sender, EventArgs e)
{
try
{
string movies = "";

if (checkadmin.Checked)
{
movies = checkadmin.Text;
}

else if (checkuser.Checked)
{

movies = checkuser.Text;
}

string nam;
DataminingProject.Class1 obj = new DataminingProject.Class1();
nam = obj.get();
SqlConnection con = new SqlConnection(nam);
con = new SqlConnection("Data Source=NAREN;Initial Catalog=DataminingProject;User Id=sa; Pwd=saadmin");
con.Open();
SqlCommand cmd = new SqlCommand("Insert into UserCreations Values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + movies + "')", con);
cmd.ExecuteNonQuery();
MessageBox.Show("User Created Successfully");
con.Close();
this.Close();

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

fjdiewornncalwe 4-Oct-12 9:58am

Please refrain from using textspeak in your answers. Use full words, please.