how to insert values from text box while clicking add button to gridview?

Question

0.00/5 (No votes)

See more:

C#

ASP.NET

hello.
how to insert values from text boxes while clicking add button to gridview..without using datatable.????

Posted 24-Nov-11 21:47pm

ythisbug

Add a Solution

1 solution

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)

D K N T H · Answer 1 · 2011-11-24T21:51:00

Solution 1

i cant understand you question,, here's some link

http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx[^]
http://csharpcomputing.com/Tutorials/Lesson17.htm[^]
Using ADO.NET for beginners[^]

Hope it helps!

thnks.

Posted 24-Nov-11 21:51pm

D K N T H

Comments

[no name] 25-Nov-11 3:53am

Yeah right, please re-state your question so that we could help :)

ythisbug 25-Nov-11 4:43am

Name       [txtName]
NickName  [txtNickName]
Gender     [txtGender]

[addbutton]
if i click add button..from text box value have to add automatically in gridview

[gridview]

D K N T H 25-Nov-11 4:58am

are you using ado.net?

or you already finished the code, and what you want is to refresh the gridview? if that's the case the in your button click event just add:
gridview.DataSource = //something;
gridview.Databind();

hope it helps!
mark this as answer if it helps you..

thanks ^^

ythisbug 25-Nov-11 5:07am

asp.net (c#)

D K N T H 25-Nov-11 5:23am

no what i mean is, how do connect in database,

can i see your codes?

thanks

ythisbug 25-Nov-11 23:18pm

string UserID, ID;

SqlConnection cnn = new SqlConnection(ConfigurationManager.AppSettings["dbConnection"].ToString());

SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Login";

SqlParameter ParaUserName = cmd.Parameters.Add("@UserName", SqlDbType.VarChar);
SqlParameter ParaPassword = cmd.Parameters.Add("@Password", SqlDbType.VarChar);
SqlParameter ParaUserUID = cmd.Parameters.Add("@UserID", SqlDbType.BigInt);
SqlParameter ParaID = cmd.Parameters.Add("@ID", SqlDbType.Int);

ParaUserUID.Direction = ParameterDirection.Output;
ParaID.Direction = ParameterDirection.Output;
ParaUserName.Value = txtUserName.Text;
ParaPassword.Value = txtPassword.Text;

cnn.Open();
cmd.ExecuteNonQuery();

ID = ParaID.Value.ToString();
UserID = ParaUserUID.Value.ToString();
Session["UserID"] = UserID;
cnn.Close();

if (Convert.ToInt32(ID) == 1)
{
Response.Redirect("ViewUserInfo.aspx?UserID="+UserID);
}

else
{

Label3.Visible = true;
Label3.Text = "Invalid Login!!";
}

}

i used stored procedure..

ythisbug 25-Nov-11 23:20pm

hello,,
now i did tat grid view..but values showing
fahad
sh
hgl
hdkd
hala
haja

value showing in gridview like this...but i want to show tat value like
fahad haha ldkj klsdfj lkdjf
in this format i want to display..any tricks..???

ythisbug 27-Nov-11 23:42pm

hi how to give paging for gridview???