Insert values into the SQL server table and click on the blank records

Question

0.00/5 (No votes)

See more:

i am inserting data into the sqlserver data table. and i have many parameters. if i fill the values and click on the insert button so values are inserting and going into the table properly. but if i am inserting only few values means not all. so it gives me an error.
i want if i click on the button without any value so it should not give me an error.
please guide me how to solve this condition with my these codes.

What I have tried:

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=DelhiEMP;Integrated Security=True");
           con.Open();
           string query = "insert into itemmaster(itemcode, name, salesprice, salestax,profit, quantityonhand) values(@itemcode, @name, @salesprice,@profit,@salestax,  @quantityonhand)";
           SqlCommand cmd = new SqlCommand(query, con);


           cmd.Parameters.AddWithValue("@itemcode", textBox1.Text);
           cmd.Parameters.AddWithValue("@name", textBox2.Text);
           cmd.Parameters.AddWithValue("@salesprice", textBox3.Text);
           cmd.Parameters.AddWithValue("@salestax", textBox4.Text);
           cmd.Parameters.AddWithValue("@profit", textBox5.Text);
           cmd.Parameters.AddWithValue("@quantityonhand", textBox6.Text);
           cmd.ExecuteNonQuery();
           MessageBox.Show("Saved");
           con.Close();

Posted 30-Apr-17 19:28pm

faizy001

Updated 30-Apr-17 19:50pm

Add a Solution

Comments

Nirav Prabtani 2-May-17 2:19am

What kind of error is there ? Can you please share ?

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)

Tejas Vaishnav · Answer 1 · 2017-04-30T19:50:00

First of all you need to check your database table schema, if all the columns are null or having any default value specified then only your goal is achieved, means with out entering anything and clicking on button your blank record is created.

here you are using itemmaster table, so if its schmea is allowing null value/ default value to columns itemcode, name, salesprice, salestax,profit, quantityonhand then you can insert a default value/null value record to your table.

can you please share your table schema, and also don't forget to updated your error details, like what error message you are getting while inserting a blank row.

UPDATES

As you have shared your database table schema as per below script

SQL

CREATE TABLE [dbo].[itemmaster](
[itemcode] [int] NOT NULL,
[name] [varchar](50) NULL,
[salesprice] [decimal](18, 0) NULL,
[salestax] [decimal](18, 0) NULL,
[profit] [decimal](18, 0) NULL,
[quantityonhand] [decimal](18, 0) NULL,
PRIMARY KEY CLUSTERED 
(
[itemcode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

You have set itemcode as primary key with out identity column, so you need to provide value for that column while inserting record. Rest of the columns are allowed null, so you can either specified value for it or not that work to insert the data to your itemmaster table.

Or As per the below script you can modify your table schema and define itemcode as Identity Column with Primary Key, then database will automatically increment the next identity value and insert it to your table while inserting the records.

SQL

/****** Object:  Table [dbo].[itemmaster]    Script Date: 5/1/2017 8:08:10 PM ******/
DROP TABLE [dbo].[itemmaster]
GO

/****** Object:  Table [dbo].[itemmaster]    Script Date: 5/1/2017 8:08:10 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[itemmaster](
	[itemcode] [int] IDENTITY(1,1) NOT NULL,
	[name] [varchar](50) NULL,
	[salesprice] [decimal](18, 0) NULL,
	[salestax] [decimal](18, 0) NULL,
	[profit] [decimal](18, 0) NULL,
	[quantityonhand] [decimal](18, 0) NULL,
 CONSTRAINT [PK__itemmast__986EE407B02D1FB9] PRIMARY KEY CLUSTERED 
(
	[itemcode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Suggesion: please do not use inline query in your application, it will allow SQL Injection[^] to be injected to your application.
Instead using inline query use store procedure with in your application like this Store Procedure Demo[^]