insert into database from the user

Question

0.00/5 (No votes)

See more:

Hi,

i have a problem
i try to insert into database but this not happen i check my database to see value but i see nothing !!
i don't know WHY ??
can you help me
i want to create web application use C# and Asp.net;

1- first i have Table3 in Database which have 2 column [Emp_id]&[password]
with data type nchar(5) for [Emp_id], and nchar(10) for [password]
then i create Stored procedure as following:

ALTER PROCEDURE dbo.StoredProcedure1

@Emp_id nchar(5),
@Password nchar(10)
	
AS
INSERT INTO Table3 (Emp_id,password)
VALUES (@Emp_id,@Password)

RETURN

2-in my "aspx" page i drag 2 textboxes and 1 button then in "aspx.cs" page and during the button i try to write insert code into database use "Stored procedure" how i do that. Note that, the insert from the user

Thanks :)

Posted 5-Apr-11 6:26am

Cs.A M A L

Updated 5-Apr-11 19:43pm

Brijesh Kr

v2

Add a Solution

Comments

wizardzz 5-Apr-11 12:34pm

Are you simply asking how to call a stored procedure?

Cs.A M A L 5-Apr-11 20:33pm

both i want to learn how to call a stored procedure with more than one parameter and i want to create inserting button to fill database , thanks;

[no name] 6-Apr-11 1:46am

First you should use parametrize store procedure

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

Sandeep Mewara · Answer 1 · 2011-04-05T06:45:00

Solution 1

You need to know how to use stored procedure using ADO.NET.

Just pick any link from here[^], first few:
Link 1[^]
Link 2[^]
Link 3[^]

Posted 5-Apr-11 6:45am

Sandeep Mewara

Updated 5-Apr-11 6:46am

v2

Michael Bookatz · Answer 2 · 2011-04-05T07:44:00

You need to use ADO.net. You need to put some code into the event of the button. Ideally you should separate and do it in a different class so that you separate your view from your model and data access.

Sample Code you can use is.

SqlConnection sqlConnection;
SqlCommand sqlCommand;
SqlParameter sqlparameter;
DataTable dt = null;

try
{
    sqlConnection = Database.DatabaseConnection;
               
    sqlCommand = new SqlCommand();
    sqlCommand.Connection = sqlConnection;
    sqlCommand.CommandType = CommandType.StoredProcedure;
    sqlCommand.CommandTimeout = 0;
    sqlCommand.CommandText = "StoredProcedure1";

    sqlparameter = new SqlParameter();
    sqlparameter.ParameterName = "@Emp_id";
    sqlparameter.SqlDbType = SqlDbType.VarChar;
    sqlparameter.Value = Emp_id;
    sqlparameter.Direction = ParameterDirection.Input;
    sqlCommand.Parameters.Add(sqlparameter);

    sqlparameter = new SqlParameter();
    sqlparameter.ParameterName = "@Password";
    sqlparameter.SqlDbType = SqlDbType.VarChar;
    sqlparameter.Value = Password;
    sqlparameter.Direction = ParameterDirection.Input;
    sqlCommand.Parameters.Add(sqlparameter);


    SqlDataAdapter sqlDA = new SqlDataAdapter();
    dt = new DataTable();
    sqlDA.SelectCommand = sqlCommand;
    sqlConnection.Open();
    sqlDA.Fill(dt);
    sqlConnection.Close();

}
catch (Exception ex)
{
              
}

    return dt;

Cs.A M A L · Answer 3 · 2011-04-05T06:59:00

Solution 2

Thank you so much for answer
can i ask a small question, please !
it is possible to insert value into database by using button and save in database ? or not?

Posted 5-Apr-11 6:59am

Cs.A M A L

Cs.A M A L · Answer 4 · 2011-04-05T08:52:00

Thanks;

i try to create method return DataTable value as following:

public DataTable table(string e,string p)
        {
            SqlParameter sqlparameter;
            DataTable dt = null;
            
            //1)connection:
            SqlConnection cn = new SqlConnection();
            cn.ConnectionString = "server=XXX; database=Test; integrated security=true";

            try
            {
                //---------------------------------------------------//
            //2)request:
                SqlCommand cmd = new SqlCommand();
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandTimeout = 0;
                cmd.CommandText = "StoredProcedure1";
                
                sqlparameter = new SqlParameter();
                sqlparameter.ParameterName = "@Emp_id";
                sqlparameter.SqlDbType = SqlDbType.NChar; //DataType of Emp_id is nChar(5)
                sqlparameter.Value = e; //this to assign value, (e) which is from Textbox1.Text
                sqlparameter.Direction = ParameterDirection.Input;
                cmd.Parameters.Add(sqlparameter);

                sqlparameter = new SqlParameter();
                sqlparameter.ParameterName = "@Password";
                sqlparameter.SqlDbType = SqlDbType.NChar; //DataType of Emp_id is nChar(10)
                sqlparameter.Value = p; //this to assign value, (p) which is from Textbox2.Text
                sqlparameter.Direction = ParameterDirection.Input;
                cmd.Parameters.Add(sqlparameter);
                
                SqlDataAdapter sqlDA = new SqlDataAdapter();
                dt = new DataTable();
                sqlDA.SelectCommand = cmd;
             //3)Open Connection:
                cn.Open();
                sqlDA.Fill(dt);
             //3)Close Connection:
                cn.Close();
            }
            catch (Exception ex)
            {
                Response.Write("Error");
            }
            return dt;
        }

And in button i invoke the method as following :

protected void Button1_Click(object sender, EventArgs e)
        {
            string EmpID = TextBox1.Text;
            string password = TextBox2.Text;

            GridView1.DataSource = table(EmpID, password); //try to display result as table
            GridView1.DataBind();
 
        }

but nothing happen i don't know if there something wrong, the GridView1 not display and the in database not result i go to my database and right click then show table data but no any thing plezzzzzzz :( if i have any error tell me. Note, when am i run there are no any error in code .

Thanks All :)

Cs.A M A L · Answer 5 · 2011-04-05T14:29:00

Solution 5

can we inserting data into database by using button, really i confusing, just for ask !!!
And what about my codes above can i using to insert data by use button or may i have big mistake in codes and i don't know about it, for this i ask us to help me :)?

Thanks every one

Posted 5-Apr-11 14:29pm

Cs.A M A L

insert into database from the user

5 solutions

Solution 1

Solution 3

Solution 2

Solution 4

Solution 5

Add your solution here

Preview 0