Compilation Error Not Understood

Thank you very much satyapriya nayak. I'm going to university in september so I'm going to have to practice inserting into a database in code behind.

Hi
This is the complete program i have done it.Run the attachments.
 
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    SqlCommand com;
    string str;
  
    protected void btnadd_Click(object sender, EventArgs e)
    {
        ExecuteInsert(RegistrationText.Text, MakeText.Text, ModelText.Text, FuelTypeText.Text, CapacityText.Text, BhpText.Text, MileageText.Text);
        Response.Write("Record was successfully added!");
    }
    private void ExecuteInsert(string RegistrationNumber, string Make, string Model, string FuelType, string Capacity, string Power, string Mileage)
    {
        SqlConnection con = new SqlConnection(connStr);
        str = "INSERT INTO Vehicles (RegistrationNumber, Make, Model, FuelType, Capacity, Power, Mileage) VALUES (@RegistrationNumber, @Make, @Model, @FuelType, @Capacity, @Power, @Mileage)";
        try
        {
        con.Open();
        com = new SqlCommand(str, con);
        SqlParameter[] param = new SqlParameter[7];
        param[0] = new SqlParameter("@RegistrationNumber", SqlDbType.NVarChar, 10);
        param[1] = new SqlParameter("@Make", SqlDbType.NVarChar, 30);
        param[2] = new SqlParameter("@Model", SqlDbType.NVarChar, 30);
        param[3] = new SqlParameter("@FuelType", SqlDbType.NVarChar, 10);
        param[4] = new SqlParameter("@Capacity", SqlDbType.Int, 4);
        param[5] = new SqlParameter("@Power", SqlDbType.Int, 4);
        param[6] = new SqlParameter("@Mileage", SqlDbType.Int, 8);
        param[0].Value = RegistrationNumber;
        param[1].Value = Make;
        param[2].Value = Model;
        param[3].Value = FuelType;
        param[4].Value = Capacity;
        param[5].Value = Power;
        param[6].Value = Mileage;
        for (int i = 0; i < param.Length; i++)
            {
             com.Parameters.Add(param[i]);
            }
        com.CommandType = CommandType.Text;
        com.ExecuteNonQuery();
        }
        catch (System.Data.SqlClient.SqlException ex)
        {
            string msg = "Insert Error:";
            msg += ex.Message;
            throw new Exception(msg);
        }
        finally
        {
        con.Close();
        }
}
   
}

 
 
 
Plz mark the answer if you like it.
 
Thanks

Amit I did what you said and started at number1. The error message was then as follows:
Format of the initialization string does not conform to specification starting at index 0.
Any other suggestions anyone?

OK Amit i'll try this, but it seems a bit strange to start working with an array a index 1!! I thought indexes should start a 0 in arrays. .

Hi Amit,
It seems you have a lot of time in replying post in this forum, what is your job? Sorry for the off-topic!

hi friend,

Here is your culprit statement:
param[0] = new SqlParameter("@RegistrationNumber", SqlDbType.NVarChar, 10);

Don't start adding param from 0 index try to add from index 1.

Format of the initialization string does not conform to specification starting at index 0.
This error is saying the same thing.


Thierry  Please mark " Do you like this post" if it helps you.

How do I output to the console this connection string?
Response.Write("ConnectionStringName") or Console.Write("ConnectionStringName")?
Here's the code in case you are curious:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration.Assemblies;
namespace CarServiceManager
{
public partial class AddVehicle : Form
{
public AddVehicle()
{
InitializeComponent();
}

private void AddButton_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection sqlConnection1 = new System.Data.SqlClient.SqlConnection("ServiceManagerDBConnectionString");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT INTO Vehicles (RegistrationNumber, Make, Model, FuelTypes, Capacity, Power, Mileage) VALUES (@RegistrationNumber, @Make, @Model, @FuelType, @Capacity, @Power, @Mileage)";
cmd.Connection = sqlConnection1;
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@RegistrationNumber", SqlDbType.NVarChar, 10);
param[1] = new SqlParameter("@Make", SqlDbType.NVarChar, 30);
param[2] = new SqlParameter("@Model", SqlDbType.NVarChar, 30);
param[3] = new SqlParameter("@FuelType", SqlDbType.NVarChar, 10);
param[4] = new SqlParameter("@Capacity", SqlDbType.Int, 4);
param[5] = new SqlParameter("@Power", SqlDbType.Int, 4);
param[6] = new SqlParameter("@Mileage", SqlDbType.Int, 8);
param[0].Value = RegistrationText.Text;
param[1].Value = MakeText.Text;
param[2].Value = ModelText.Text;
param[3].Value = FuelTypeText.Text;
param[4].Value = Convert.ToInt32(CapacityText.Text);
param[5].Value = Convert.ToInt32(BhpText.Text);
param[6].Value = Convert.ToInt32(MileageText.Text);
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
}
}
}

Hi friend,
The error tells you that there's something wrong with the connection string. You can have a preview of how to write connection string from "http://www.connectionstrings.com/".
Output your connection string to the console, and see if there's something wrong.