Method to load data on the form

Question

0.00/5 (No votes)

See more:

Good Day,

I have created a web form for sumbmiting data to the database and it is working with no errors. It diplays on a griedview

now i have decided to add an update button. but i dont know where to start with my updating satatement. can you please help me on how to write an update statement.

I want to know if it is possible for me to click data in a griedview and it shows on the form so that i can update,is yes? can you please show me how?

You can rectify me if theres mistake i did.

I think now i have provided enough details.

Thanks.....

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;

public partial class Register : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString01"].ConnectionString);
    
        
    protected void Page_Load(object sender, EventArgs e)
    {
        
        
        conn.Open();
        
        
    }

    protected void btnregister_Click(object sender, EventArgs e)
    {
        SqlCommand comm = new SqlCommand("insert into tblreg values('"+txtuser.Text+"','"+txtPass.Text+"','"+txtFulln.Text+"','"+txtSurname.Text+"','"+txtemail.Text+"','"+dropCountry.Text+"','"+dropProvince.Text+"')",conn);
        comm.ExecuteNonQuery();
        GridView1.DataBind();
        txtuser.Text = "";
        txtPass.Text = "";
        txtFulln.Text = "";
        txtSurname.Text = "";
        txtemail.Text = "";
        dropCountry.SelectedItem.ToString();
        dropProvince.SelectedItem.ToString();
        

        //try
        //{
        //    conn.Close();
        //    Response.Redirect("Login.aspx");
        //}
        //catch(Exception ex)
        //{
        //    Response.Write("Error");
        //}
        //finally
        //{
        //    Response.Write("Executed");
        //}
    }

    private void formloaddata()
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString01"].ConnectionString);
        string strquery = "Select UserID,Username,Password,Fullname,Surname,Email Address,Country,Province";
        SqlDataReader read = new SqlDataReader(conn, strquery);
        GridView1.DataBind();


    }


    protected void btnUpdate_Click(object sender, EventArgs e)
    {
       
        
    }
}

Posted 14-May-13 3:32am

Member 10010198

Updated 14-May-13 4:16am

v2

Add a Solution

Comments

Johnny J. 14-May-13 9:34am

What have you got so far? Where are you stuck? You need to give us a more specific question. We don't write full applications for you...

Member 10010198 14-May-13 9:36am

this is what i was traying to write.

private void formloaddata()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString01"].ConnectionString);
string strquery = "Select UserID,Username,Password,Fullname,Surname,Email Address,Country,Province";
SqlDataReader read = new SqlDataReader(conn, strquery);
GridView1.DataBind();

}

[no name] 14-May-13 9:54am

You never open the connection and you never execute the query.

Member 10010198 14-May-13 9:56am

this is my coding so far......

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;

public partial class Register : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString01"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)
{

conn.Open();

}

protected void btnregister_Click(object sender, EventArgs e)
{
SqlCommand comm = new SqlCommand("insert into tblreg values('"+txtuser.Text+"','"+txtPass.Text+"','"+txtFulln.Text+"','"+txtSurname.Text+"','"+txtemail.Text+"','"+dropCountry.Text+"','"+dropProvince.Text+"')",conn);
comm.ExecuteNonQuery();
GridView1.DataBind();
txtuser.Text = "";
txtPass.Text = "";
txtFulln.Text = "";
txtSurname.Text = "";
txtemail.Text = "";
dropCountry.SelectedItem.ToString();
dropProvince.SelectedItem.ToString();

//try
//{
// conn.Close();
// Response.Redirect("Login.aspx");
//}
//catch(Exception ex)
//{
// Response.Write("Error");
//}
//finally
//{
// Response.Write("Executed");
//}
}

private void formloaddata()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString01"].ConnectionString);
string strquery = "Select UserID,Username,Password,Fullname,Surname,Email Address,Country,Province";
SqlDataReader read = new SqlDataReader(conn, strquery);
GridView1.DataBind();

}

[no name] 14-May-13 10:02am

Yes... and? As I said, you never open the connection and you never execute the query. And you need to use the Improve question widget to post your code and describe your problem.

[no name] 14-May-13 9:35am

You would write some code that updates your form and call it when you want to update your form.

Member 10010198 14-May-13 9:39am

yes but for now i want a help on writing a method that will load data

[no name] 14-May-13 9:52am

Help on what? You have not described any kind of a problem to get help with. Can you not connect to whatever database server you are using? Can you not execute commands? Do you not know how to write a query? You need to be a lot more specific than "I need help".

Member 10010198 14-May-13 10:00am

can you please help me to write update statement together with the method that will load data when click Update button

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;

public partial class Register : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString01"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)
{

conn.Open();

}

protected void btnregister_Click(object sender, EventArgs e)
{
SqlCommand comm = new SqlCommand("insert into tblreg values('"+txtuser.Text+"','"+txtPass.Text+"','"+txtFulln.Text+"','"+txtSurname.Text+"','"+txtemail.Text+"','"+dropCountry.Text+"','"+dropProvince.Text+"')",conn);
comm.ExecuteNonQuery();
GridView1.DataBind();
txtuser.Text = "";
txtPass.Text = "";
txtFulln.Text = "";
txtSurname.Text = "";
txtemail.Text = "";
dropCountry.SelectedItem.ToString();
dropProvince.SelectedItem.ToString();

//try
//{
// conn.Close();
// Response.Redirect("Login.aspx");
//}
//catch(Exception ex)
//{
// Response.Write("Error");
//}
//finally
//{
// Response.Write("Executed");
//}
}

private void formloaddata()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString01"].ConnectionString);
string strquery = "Select UserID,Username,Password,Fullname,Surname,Email Address,Country,Province";
SqlDataReader read = new SqlDataReader(conn, strquery);
GridView1.DataBind();

}

protected void btnUpdate_Click(object sender, EventArgs e)
{

}
}

V. 14-May-13 9:38am

You need to provide more info. What database, where are you stuck? What is the exact requirement, what is the exact problem? Do you get errors? Do you have a design issue, don't you know where to start?

Don't reply to this comment, just update the question with more information.

Member 10010198 14-May-13 9:42am

i am using sql sever 2005. dont know how to write a method that will load data on the form wn i want to update the data.....i am lost dont know wr to start

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)

Maciej Los · Answer 1 · 2013-05-14T03:50:00

Solution 1

I would suggest you to start here: ADO.NET[^]

There you'll find code examples for ADO.NET: http://msdn.microsoft.com/en-us/library/dw70f090.aspx[^]

From CP Knowledge Base:
Using ADO.NET for beginners[^]
A Beginner's Tutorial for Understanding ADO.NET[^]

Posted 14-May-13 3:50am

Maciej Los

Basmeh Awad · Answer 2 · 2013-05-14T04:21:00

Solution 2

C#

private void formloaddata()
    {
 SqlDataReader read
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString01"].ConnectionString);
conn.open   //Open your Connection
        string strquery = "Select UserID,Username,Password,Fullname,Surname,Email Address,Country,Province from "Write your TableName"";
        SqlCommand cmd=new SqlCommand(strquery,conn);
        read = cmd.ExecutenonQuery();
if read.hasrows
{
read.Read();
textbox1.text=read("UserID"); // assign this reader to your respective TextBoxes
textbox2.text=read("Username");
textbox3.text=read("Password");
textbox4.text=read("Fullname");
textbox5.text=read("Surname");
textbox6.text=read("Email ");
textbox7.text=read("Address");
textbox8.text=read("Country");
textbox9.text=read("Province");
}     

    }

write the code in a try catch block so if error occurs you will come to know what the error is

Posted 14-May-13 4:21am

Basmeh Awad

Comments

Member 10010198 15-May-13 4:56am

private void formloaddata()
{
SqlDataReader read;
SqlCommand comm = new SqlCommand(ConfigurationManager.ConnectionStrings["ConnectionString01"].ConnectionString);
conn.Open();
string strquery = "select UserID,Username,Password,Fullname,Surname,Email Address,Country,Province from tblreg";
SqlCommand comd = new SqlCommand(strquery, conn);

read = comd.ExecuteNonQuery(); Error//Cannot implicitly convert type 'int' to 'System.Data.SqlClient.SqlDataReader'

if(read.HasRows)
{
while (read.Read())
{

//Errors for code below 'read' is a 'variable' but is used like a 'method'
txtuser.Text = read("Username"); Error//
txtPass.Text = read("Password");
txtFulln.Text = read("Fullname");
txtSurname.Text = read("Surname");
txtemail.Text = read("Email Address");
dropCountry.Text = read("Country");
dropProvince.Text = read("province");

}

}
// is my try catch statement ok?
try
{
conn.Close();

}
catch (Exception ex)
{
Response.Write("Error");
}
finally
{
Response.Write("Executed");
}

Member 10010198 15-May-13 4:57am

i got those 2 erros that i have commented........Thanks