Ad:

ASP.NET Discussion Thread
Unsolved
Views: 1064

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Aug 23rd, 2009

add data into a sql with a drop down

Expand Post »

hi

this may sound simple but i can not get it to work i have try for about 5-6 weeks now and this my last hope

all my project is to make a job dater base that workers can add jobs and cliences can see there job but i am stuck on
the user (user being the worker) fill out a form(this would be a new job) and then sumit it to a dater base.
the form will include

job name = text box
job status = drop down box
hazarads = drop down box
design staff = drop down box
description = multiline text box

and a few more but if i know how to do them then i can figure out how do the others.

any help please

thanks alot

ANY questions please please ask

using asp.net would perfure vb but that desprate will use c#

Last edited by motters; Aug 23rd, 2009 at 12:17 pm. Reason: add detail

Similar Threads

How to import Excel Sheet data into SQL Server 2003 ???? Stpes. in MS SQL
Do anyone know the example code for VB6 on add and update data to the ms sql 2000 in Visual Basic 4 / 5 / 6
Sql command to add new data using store values? in C#
Command object use to add data to a database in MySQL
ootball league table - add data in C

motters

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

37 posts
since Aug 2009

Permalink

Aug 23rd, 2009

-1

Re: add data into a sql with a drop down

hi frnd , can u plz explain ur question more clearly...or send me ur question on mine id <EMAIL SNIPPED>

Last edited by peter_budo; Aug 23rd, 2009 at 4:13 pm. Reason: Keep It On The Site - Do not post asking for an answer to be sent to you via email or PM.

sonia sardana

Reputation Points: 0

Solved Threads: 8

Posting Whiz

Offline

326 posts
since Mar 2008

Permalink

Aug 23rd, 2009

Re: add data into a sql with a drop down

Click to Expand / Collapse Quote originally posted by sonia sardana ...

hi frnd , can u plz explain ur question more clearly...or send me ur question on mine id <EMAIL SNIPPED>

ok thanks for helping me

all i want to do is to add data into sql dater base using a drop down box,text box, and mulitly line text box

Last edited by peter_budo; Aug 23rd, 2009 at 4:13 pm. Reason: Snipping email from quote

motters

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

37 posts
since Aug 2009

Permalink

Aug 23rd, 2009

Re: add data into a sql with a drop down

ks so simple it is..I m showing u the code dat add data to SQL database but from textbox,U just change dropdown here..

ASP.NET Syntax (Toggle Plain Text)
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient; 
 
public partial class FrmRegistration : System.Web.UI.Page
{
 
    SqlConnection conn = new SqlConnection("Data Source=SONIA-B408A4159\\SQLEXPRESS;Initial catalog=sonia;Integrated Security=true");
    string query;
    SqlCommand cmd;
 
 
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        query = "Insert into UserInfo values(@name,@email)";
        cmd = new SqlCommand(query, conn);
        conn.Open();
        cmd.Parameters.AddWithValue("@name", txtName.Text);
        cmd.Parameters.AddWithValue("@email", txtEmail.Text);
        cmd.ExecuteNonQuery();
        conn.Close();
 
 
    }
}
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient; 

public partial class FrmRegistration : System.Web.UI.Page
{
   
    SqlConnection conn = new SqlConnection("Data Source=SONIA-B408A4159\\SQLEXPRESS;Initial catalog=sonia;Integrated Security=true");
    string query;
    SqlCommand cmd;
 
 
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        query = "Insert into UserInfo values(@name,@email)";
        cmd = new SqlCommand(query, conn);
        conn.Open();
        cmd.Parameters.AddWithValue("@name", txtName.Text);
        cmd.Parameters.AddWithValue("@email", txtEmail.Text);
        cmd.ExecuteNonQuery();
        conn.Close();
      
      
    }
}

ASP.NET Syntax (Toggle Plain Text)
create table UserInfo(Name varchar(100),EMail varchar(100))
select * from UserInfo
delete from UserInfo
create table UserInfo(Name varchar(100),EMail varchar(100))
select * from UserInfo
delete from UserInfo

Last edited by sonia sardana; Aug 23rd, 2009 at 1:26 pm.

sonia sardana

Reputation Points: 0

Solved Threads: 8

Posting Whiz

Offline

326 posts
since Mar 2008

Permalink

Aug 23rd, 2009

Re: add data into a sql with a drop down

motters: Please post your project. Zip it and upload the entire project.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Aug 23rd, 2009

Re: add data into a sql with a drop down

Click to Expand / Collapse Quote originally posted by sknake ...

motters: Please post your project. Zip it and upload the entire project.

there is one problem with that i am in test stages i am testing that i can do everything needed for the project. so not starting project till i know how to slove this problem. so i have know thing to upload.

--------------------------------------------------------------------------------

also i have i problem with the code supply

c# Syntax (Toggle Plain Text)
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        query = "Insert into UserInfo values(@name,@email)";
        cmd = new SqlCommand(query, conn);
        conn.Open();
        cmd.Parameters.AddWithValue("@name",[B] txtName[/B].Text);
        cmd.Parameters.AddWithValue("@email", [B]txtEmai[/B]l.Text);
        cmd.ExecuteNonQuery();
        conn.Close();
 
 
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        query = "Insert into UserInfo values(@name,@email)";
        cmd = new SqlCommand(query, conn);
        conn.Open();
        cmd.Parameters.AddWithValue("@name",[B] txtName[/B].Text);
        cmd.Parameters.AddWithValue("@email", [B]txtEmai[/B]l.Text);
        cmd.ExecuteNonQuery();
        conn.Close();
      
      
    }

where is says txtName and txtEmail i have a red line uder and it says "txtName does not exsist in the current context"
same for txtEmail.
on my page i do have two text boxs one called
txtName and the other one
txtEmail

what have i done wrong

thanks alot for your help

Last edited by peter_budo; Aug 23rd, 2009 at 4:14 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

motters

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

37 posts
since Aug 2009

Permalink

Aug 23rd, 2009

Re: add data into a sql with a drop down

Please use code tags when posting code on daniweb:

[code=csharp]
...code here...
[/code]

It sounds like you're creating the controls dynamically. It is impossible to tell what is really going on without an uploaded sample project. You can create a new project and move over enough code to reproduce the issue.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Aug 23rd, 2009

Re: add data into a sql with a drop down

ok sorry for not using he code tag i will from now on sorry

i will get together a sample project as soon as i can

thanks for all your help

motters

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

37 posts
since Aug 2009

Permalink

Aug 23rd, 2009

Re: add data into a sql with a drop down

just remove the txtName.Text & type it again..Dont cut & paste it again...

sonia sardana

Reputation Points: 0

Solved Threads: 8

Posting Whiz

Offline

326 posts
since Mar 2008

Permalink

Aug 23rd, 2009

Re: add data into a sql with a drop down

Click to Expand / Collapse Quote originally posted by sonia sardana ...

just remove the txtName.Text & type it again..Dont cut & paste it again...

i have just try that am it did not work should the text box be in a formview?

motters

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

37 posts
since Aug 2009

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: DataReader Vs DataSet

Next Thread in ASP.NET Forum Timeline: how to dynamically set the text of a label using the text from textbox?

DaniWeb Message

Cancel Changes

User Name
Password