Comments by Member 10010198 (Top 20 by date)

so i must convert txtPass.Text = read["Password"]; because it is a int?

Hi,

i have changed to txtuser.Text = read["Username"]; but it still gives errors or highlighting to shows that it is wrong

and lastly......i dont understand the code below

thanks i have changed

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

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");
}

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)
{


}
}

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();


}

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

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

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();


}

Thanks.....will this code works even if theres no username and password stored as a default?

Must i create a class for this

send an invoice.........joking

I do undestand just that sometimes i get lost.

E.g
private void btnexit_Click(object sender, EventArgs e)
{
Application.Exit(); // a method that exit the application
}