TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Yasmine Amin
NA
20
0
Insert data into sql sever
Oct 29 2008 11:11 AM
Hi all i have been struggling with this for a while now.. I'm trying to add a new user to a system but for some reason nothing is being inserted. Below is my code:
My ASP form
The form is a simple admin form with 2 textboxes and a button, the user must fill their username and a password then click on the button to insert their username and password into the database... the field IDs are usernameTxt and passwordTxt
Form.aspx.cs
public
class
WebForm1 : System.Web.UI.Page
{
protected
System.Web.UI.WebControls.Button testBt;
protected
System.Web.UI.WebControls.Table addUserTb;
protected
System.Web.UI.WebControls.TextBox usernameTxt;
protected
System.Web.UI.WebControls.TextBox passwordTxt;
private
void
addUserBt(
object
sender, System.EventArgs e)
{
//to define strings to hold values entered inside a form
string
the_username;
string
the_name;
string
the_pass;
the_username = usernameTxt.Text;
the_pass = passwordTxt.Text;
//create an object to access dbconn.cs
dbConn connectTodb =
new
dbConn();
string
cmd = "INSERT INTO users (username, password, permission, active) VALUES('" + the_username + "', '" + the_pass + "', 1, 1);";
connectTodb.getConnected(cmd);
Console.WriteLine("Record Inserted");
}
//end of function
My connection class
using
System.Data.SqlTypes;
using
System.Text;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
namespace
firstForm
{
public
class
dbConn
{
public
dbConn(){
}
public
void
getConnected(
string
cmds)
{
SqlConnection sqlConn =
new
SqlConnection("Data Source = (local);initial catalog=bugsDb; User Id =sa; Password = saadmin;");
//Insert Command
SqlCommand sqlCmd =
new
SqlCommand(cmds,sqlConn);
try
{
sqlCmd.CommandText = cmds;
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
sqlConn.Close();
}
finally
{
sqlConn.Close();
}
}
//end function
}
}
Can anyone tell me why nothing is being inserted. I'm using a sql server 2005 express version..
thanks in advance
Reply
Answers (
3
)
More than half page blank in each page of report.
Re:WebControl Treeview