Table With TextBoxes

hello i am new to this world of sql server's
and i whould like to know how to connect my Table to a TextBox

Re: Table With TextBoxes

I would suggest you start with some of these. some are short videos others are detialed walk throughs.

great resource that got me started.

http://www.asp.net/web-forms

Re: Table With TextBoxes

march11

I would suggest you start with some of these. some are short videos others are detialed walk throughs.

great resource that got me started.

http://www.asp.net/web-forms

I dont see where it tells u about Sql

Re: Table With TextBoxes

Try this one, its 43 minutes in all....

http://www.pluralsight-training.net/microsoft/players/PSODPlayer.aspx?author=dan-wahlin&name=webforms-08&mode=live&clip=0&course=aspdotnet-webforms4-intro

Re: Table With TextBoxes

Hii,

Please refer belo Links.Surely it will help u.

http://www.codeproject.com/KB/aspnet/InsertingWithGridView.aspx

http://www.codeproject.com/KB/vb/sqlcriptnet.aspx

http://www.codeproject.com/KB/database/sql_in_csharp.aspx

Re: Table With TextBoxes

This is the link I was first looking for sorry....

http://www.asp.net/general/videos

Re: Table With TextBoxes

its still doesnt answer my question :)

Re: Table With TextBoxes

There is no easier answer to your question. It depends on the datasource, and what you intend to do.

Watching the videos will give you a good understanding about how to design your solution so that it is compatible with your objective.

There are thousands of ways to connect them. You'll need to provide much more data before someone can offer more help. :)

You can also do some research on SQL data Sources. Setting up a connection, Gridview, Formview, DetialsView these are controls that are used to display data. You don't generally output SQL data directly to a textbox.

Good Luck.

Re: Table With TextBoxes

march11

There is no easier answer to your question. It depends on the datasource, and what you intend to do.

Watching the videos will give you a good understanding about how to design your solution so that it is compatible with your objective.

There are thousands of ways to connect them. You'll need to provide much more data before some can offer more help. :)

You can also do some research on SQL data Sources. Setting up a connection, Gridview, Formview, DetialsView thes are controls that are used to display data. You don't generally output SQL data directly to a textbox.

Good Luck.

1. thank you
2. i did set up my connection and i played a bit with GridView FormView and DetailsView

3.im still looking for some answers on how to connect between them...
i used the SqlDataSource from the ToolBox

Re: Table With TextBoxes

Eaxactly, the next step has to do with whether you need to Update, Edit, Delete the results. The controls handle all of this for you by default. Its based in the selection process when you set up the connection, look for the Advanced button. You clcik the check box to create Update, Delete, Select functionality. Your table will need to have key set and Identity specification for this to work.

Otherwise you can and for example, a button to your web page, and use the button click event to read the data from the gridview, formview, etc, and process it as needed.

Re: Table With TextBoxes

Ok i made it! :) but its not been added to my database i think lol.. i cant see it here this is my code
and i tried also with @username @password Etc..

Didnt work :(

SqlCommand sqlcmd = new SqlCommand("INSERT INTO TABLE2 (username, pass, repass, email, reemail , name , age) VALUES ('" + usernametb.Text + "," + passtb.Text + "," + rpasstb.Text + "," + emailtb.Text + "," + remailtb.Text + "," + nametb.Text + "," + agetb.Text + "')");
        sqlcmd.Parameters.AddWithValue("username", usernametb.Text);
        sqlcmd.Parameters.AddWithValue("password", passtb.Text);
        sqlcmd.Parameters.AddWithValue("repassword", rpasstb.Text);
        sqlcmd.Parameters.AddWithValue("email", email.Text);
        sqlcmd.Parameters.AddWithValue("reemail", remail.Text);
        sqlcmd.Parameters.AddWithValue("name", nametb.Text);
        sqlcmd.Parameters.AddWithValue("age", agetb.Text);
        Response.Redirect("~/AfterRegistreation.aspx");

Re: Table With TextBoxes

You need somthing like this in your code....

Dim command1 As New SqlCommand(sqlStmt, connection)
connection.Open()
command1.ExecuteNonQuery()
connection.Close()

You also need to have a connection established. that is also covered in the links in my previous posts.

Re: Table With TextBoxes

i did made a connection with it
didnt work

Re: Table With TextBoxes

Post the error.

Also take this line of code out until you get the page working...

Response.Redirect("~/AfterRegistreation.aspx");

Re: Table With TextBoxes

There is no error
it just doesnt get registered i tried to look a bit online and im made some changes:

SqlConnection conn = new SqlConnection();
     SqlDataAdapter da = new SqlDataAdapter();
            SqlConnection sqlcon = new SqlConnection(@"Data Source=TZAHI-PC\SQLEXPRESS;Initial Catalog=RegisterDb;Integrated Security=True");
            DataBinder ds = new DataBinder();
            sqlcon.Open();

            SqlCommand sqlcmd = new SqlCommand("INSERT INTO dbo.Table2 (username, pass, repass, email, reemail , name , age) VALUES ('" + usernametb.Text + "," + passtb.Text + "," + rpasstb.Text + "," + emailtb.Text + "," + remailtb.Text + "," + nametb.Text + "," + agetb.Text + "')");
            sqlcmd.Parameters.AddWithValue("username", usernametb.Text);
            sqlcmd.Parameters.AddWithValue("password", passtb.Text);
            sqlcmd.Parameters.AddWithValue("repassword", rpasstb.Text);
            sqlcmd.Parameters.AddWithValue("email", emailtb.Text);
            sqlcmd.Parameters.AddWithValue("reemail", remailtb.Text);
            sqlcmd.Parameters.AddWithValue("name", nametb.Text);
            sqlcmd.Parameters.AddWithValue("age", agetb.Text);
            sqlcmd.ExecuteNonQuery();

Re: Table With TextBoxes

Put this...

Dim command1 As New SqlCommand(sqlcmd, sqlcon);
connection.Open() ;
command1.ExecuteNonQuery() ;
connection.Close();

in place of this...

sqlcmd.ExecuteNonQuery();

Re: Table With TextBoxes

by the way, are you certain that you have a connection to the data source?

Can you query your DB and do you ahve write permissions on the database?

Re: Table With TextBoxes

i did it and it just says:
"

Error 7 The type or namespace name 'Dim' could not be found (are you missing a using directive or an assembly reference?)"

Error	10	The name 'connection' does not exist in the current context

Re: Table With TextBoxes

ohh and how can i veify that i have a writing option>

Re: Table With TextBoxes

Sorry I missed this in your code change this....

connection.Open() ;
command1.ExecuteNonQuery() ;
connection.Close();

to this....

conn.Open() ;
command1.ExecuteNonQuery() ;
conn.Close();