在Sql Server中插入值 [英] Insert Value in Sql Server

问题描述

嗨





我想将值插入Sql Srver我创建程序在sql server中我想通过插入值不使用文本框的C＃代码我是怎么做的



这里的代码

Hi


I want to insert the value into Sql Srver I create procedure In sql server and I want to Insert value through C# Code without Using Text Box How i do this

Here the code

SqlConnection abc = new SqlConnection(@"Data Source=Malhotra;Initial Catalog=master;User ID=sa;Password=abc@123");
        abc.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = abc;
        cmd.CommandType = CommandType.StoredProcedure;

        cmd.CommandText = "contact_insert_procedure";
        cmd.Parameters.Add("@Id", SqlDbType.Int).Value = "Rahul";
        cmd.Parameters.Add("@title", SqlDbType.Char).Value = "Mr";
        cmd.Parameters.Add("@Firstname", SqlDbType.Char).Value = "Gurpreet";
        cmd.Parameters.Add("@Lastname", SqlDbType.Char).Value = "Arora";
        cmd.Parameters.Add("@address", SqlDbType.VarChar).Value = "Nit FAridabad";
        cmd.Parameters.Add("@Lastname", SqlDbType.Char).Value = "Arora";
        cmd.Parameters.Add("@Company", SqlDbType.Char).Value = "XYZ";
        cmd.Parameters.Add("@Lastname", SqlDbType.Char).Value = "Arora";
        cmd.Parameters.Add("@last_send_date", SqlDbType.DateTime).Value = DateTime.Now.Subtract(TimeSpan.FromDays(12));
        cmd.ExecuteNonQuery();

推荐答案

Rahul 是数值？

Does Rahul is numeric value?

cmd.Parameters.Add("@Id", SqlDbType.Int).Value = "Rahul";

将其改为正确的数据类型。

Chenge it to proper data type.

我修改了你的代码，请试试这个

i have modified you code , plz try this

SqlConnection abc = new SqlConnection(your connection string);
        abc.Open();
        String str="contact_insert_procedure";
        SqlCommand cmd = new SqlCommand(str, abc);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@title", SqlDbType.Char).Value = "Mr";
        cmd.Parameters.Add("@Firstname", SqlDbType.Char).Value = "Gurpreet";
        cmd.Parameters.Add("@Lastname", SqlDbType.Char).Value = "Arora";
        cmd.Parameters.Add("@address", SqlDbType.VarChar).Value = "Nit FAridabad";
        cmd.Parameters.Add("@Lastname", SqlDbType.Char).Value = "Arora";
        cmd.Parameters.Add("@Company", SqlDbType.Char).Value = "XYZ";
        cmd.Parameters.Add("@Lastname", SqlDbType.Char).Value = "Arora";
        cmd.Parameters.Add("@last_send_date", SqlDbType.DateTime).Value = DateTime.Now.Subtract(TimeSpan.FromDays(12));
        cmd.ExecuteNonQuery();

这篇关于在Sql Server中插入值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！