how to insert data from a table into MS Access

public class AgentClass
{
    SqlConnection cn;
    SqlCommand cmd;
    SqlDataReader dr;
	public AgentClass()
	{
        String cs;

        cs = ConfigurationManager.ConnectionStrings["LandBankConnectionString2"].ConnectionString;
        cn=new SqlConnection(cs);
        cmd = new SqlCommand();
        cmd.Connection=cn;
        cmd.CommandType = CommandType.Text;
		
	}

    public bool InsertRecordForAgent(string AgentName,string fulladdress, string address, string suburb, int postcode, string state, int phone, int fax, string email, string isactive, string notes, string contactname)
        {
      
        try
        {
            cmd.CommandText = "insert into tbl_LB_Agent values(@AgentName,@fulladdress, @address, @suburb, @postcode, @state, @phone, @fax, @email, @isactive, @notes,@contactname)";
            cmd.Parameters.AddWithValue("@AgentName", AgentName);
            cmd.Parameters.AddWithValue("@address", address);
            cmd.Parameters.AddWithValue("@suburb", suburb);
            cmd.Parameters.AddWithValue("@postcode", postcode);
            cmd.Parameters.AddWithValue("@state", state);
            cmd.Parameters.AddWithValue("@phone", phone);
            cmd.Parameters.AddWithValue("@Fax", fax);
            cmd.Parameters.AddWithValue("@email", email);
            cmd.Parameters.AddWithValue("@isactive", isactive);
            cmd.Parameters.AddWithValue("@notes", notes);
            cmd.Parameters.AddWithValue("@contactname", contactname);
            cmd.Parameters.AddWithValue("@fulladdress", fulladdress);
            cn.Open();
            cmd.ExecuteNonQuery();
            cn.Close();
            return true;
        }
        catch (Exception ex)
        {
            return false;

        }
    }





 protected void btnOk_Click1(object sender, EventArgs e)
    {
        string AgentName, fulladdress, address, suburb, state, email, notes, isactive, contactname;
        int postcode;
        int phone, fax;
        AgentName = txtName.Text;
        address = txtAddress.Text;
        suburb = txtSuburb.Text;
        postcode = int.Parse(txtPostCode.Text);
        state = txtState.Text;
        phone = int.Parse(txtPhone.Text);
        fax = int.Parse(txtFax.Text);
        email = txtEmail.Text;
        isactive = (txtActive.Text);
        notes = txtNotes.Text;
        contactname = "";
        fulladdress = txtAddress.Text + ", " + txtSuburb.Text + ", " + txtState.Text;

        AgentClass Acl = new AgentClass();
        if (Acl.InsertRecordForAgent(AgentName, fulladdress, address, suburb, postcode, state, phone, fax, email, isactive, notes, contactname) == true)
        {
            Label4.Text = "record updated";
        }
        else
        {
            Label4.Text = "error";
        }

    }

Re: how to insert data from a table into MS Access

Hi krishnapodduturi,

Do you mean? Data insertion IN MS access table? if so, your code seems to be correct at a glance. please let us know is it error you are troubled with. Also, did you debug and proceeded to know the loc of code where you need help.

bottom line, please elaborate the problem.

Re: how to insert data from a table into MS Access

To insert into Access, you need to use the OleDb namespace instead of the SqlClient Namespace.

http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access

And you forgot to specify the fulladdress parameter

Re: how to insert data from a table into MS Access

Hello krishnapoddutri

Use Oledb classes firstAnd

Is there anything wrong with your codesAre you sharing a nice idea or solution about that

Welcoem your feedbackBut plz first remove trycatch so as to let the error exposed directly

Reguards

Re: how to insert data from a table into MS Access

hi,

declare this namespace

using System.data.oledb;

public Class Insert

{

sqlconnection cn;

sqlcommand cmd;

cs = ConfigurationManager.ConnectionStrings["LandBankConnectionString2"].ConnectionString);

sqlconnection cn = new sqlconnection (cs);

cn.open();

cmd = new sqlcommand(YourQueryString",cn);

int i = cmd.ExecuteNonQuery();

if (i == 1) then

\\insert successful

else

\\inserting failed

}

Re: how to insert data from a table into MS Access

Thanks for the reply guys. I really appreciate it.

I am sorry to waste your time. I am new to asp.net forums and just sharing the code for data insertion into sql server for another member.

I will make sure to include the details next time.

Re: how to insert data from a table into MS Access

<div>

Read word document - http://www.csharpaspnetarticles.com/2009/06/read-write-word-filestream-streamwriter.html

write excel document - http://blogs.msdn.com/b/erikaehrli/archive/2009/01/30/how-to-export-data-to-excel-from-an-asp-net-application-avoid-the-file-format-differ-prompt.aspx

areyy see this...for copying word doc to excel..Im unable to open them

</div>