creating guid when inserting data to the MS Access database : The Official Microsoft ASP.NET Forums

Reply

Re: creating guid when inserting data to the MS Access database

Feb 11, 2010 08:40 PM|LINK

krishyy
Would you please tell me how to add guid to each parameter...?

First show us your code? Because we don't know what you're doing! Are you using datasource (Access- or SQL-) controls, or are you doing the inserr in code behind?

Reply

Re: creating guid when inserting data to the MS Access database

Feb 11, 2010 08:52 PM|LINK

public partial class XYZ : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //InsertGUID();
    }
    private void InsertGUID(){
    String strGuid = "P" + System.Guid.NewGuid().ToString();
     AccessDataSource ds = new AccessDataSource();
        ds.DataFile = "C:\\XYZ\\xyzzz\\xyzz\\foldername\\xyz.mdb";
        ds.InsertCommand = "INSERT INTO tblProspect (ID) VALUES('" + strGuid + "')";
    ds.Insert();
}
    protected void Submit_Click(object sender, EventArgs e)
    {


        string ConnString = ConfigurationManager.ConnectionStrings["Data"].ConnectionString;
        OleDbConnection conn = new OleDbConnection(ConnString);
        string Text1 = TextBox1.Text;
        string Text2 = TextBox2.Text;
        string Text3 = TextBox3.Text;
        string Text4 = TextBox4.Text;
        string Text5 = TextBox5.Text;
        string Text6 = TextBox6.Text;
        string Text7 = TextBox7.Text;
        string Text8 = TextBox8.Text;
        try
        {
            conn.Open();
            InsertGUID();
            string str = "Insert into tblProspect ([Name],[Sal],[FirstName],[LastName],[Phone],[Fax],[Web],[Pwd]) values (@Name,@Sal,@FirstName,@LastName,@Phone,@Fax,@Web,@Pwd)";
            OleDbCommand cmd = new OleDbCommand(str, conn);

            cmd.Parameters.AddWithValue("@Name", TextBox1.Text);
            cmd.Parameters.AddWithValue("@Sal", TextBox2.Text);
            cmd.Parameters.AddWithValue("@FirstName", TextBox3.Text);
            cmd.Parameters.AddWithValue("@LastName", TextBox4.Text);
            cmd.Parameters.AddWithValue("@Phone", TextBox5.Text);
            cmd.Parameters.AddWithValue("@Fax", TextBox6.Text);
            cmd.Parameters.AddWithValue("@Web", TextBox7.Text);
            cmd.Parameters.AddWithValue("@Pwd", TextBox8.Text);
            cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            ex.Message.ToString();
        }
        finally
        {
            conn.Close();

        }



    }
protected void clear_Click(object sender, EventArgs e)
{
    TextBox1.Text = "";
    TextBox2.Text = "";
    TextBox3.Text = "";
    TextBox4.Text = "";
    TextBox5.Text = "";
    TextBox6.Text = "";
    TextBox7.Text = "";
    TextBox8.Text = "";
}
}

Reply

hans_v

All-Star

35998 Points

6551 Posts

Re: creating guid when inserting data to the MS Access database

Feb 11, 2010 09:06 PM|LINK

public partial class XYZ : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ~~//InsertGUID();~~
    }
    private void InsertGUID(){
    String strGuid = "P" + System.Guid.NewGuid().ToString();
     AccessDataSource ds = new AccessDataSource();
        ds.DataFile = "C:\\XYZ\\xyzzz\\xyzz\\foldername\\xyz.mdb";
        ds.InsertCommand = "INSERT INTO tblProspect (ID) VALUES('" + strGuid + "')";
    ds.Insert();
}
    protected void Submit_Click(object sender, EventArgs e)
    {


        string ConnString = ConfigurationManager.ConnectionStrings["Data"].ConnectionString;
        OleDbConnection conn = new OleDbConnection(ConnString);
        string Text1 = TextBox1.Text;
        string Text2 = TextBox2.Text;
        string Text3 = TextBox3.Text;
        string Text4 = TextBox4.Text;
        string Text5 = TextBox5.Text;
        string Text6 = TextBox6.Text;
        string Text7 = TextBox7.Text;
        string Text8 = TextBox8.Text;
        try
        {
            conn.Open();
            ~~InsertGUID();~~
            string str = "Insert into tblProspect ([ID],[Name],[Sal],[FirstName],[LastName],[Phone],[Fax],[Web],[Pwd]) values (@ID, @Name,@Sal,@FirstName,@LastName,@Phone,@Fax,@Web,@Pwd)";
            OleDbCommand cmd = new OleDbCommand(str, conn);

            cmd.Parameters.AddWithValue("@ID", "P" + Guid.NewGuid().ToString());
            cmd.Parameters.AddWithValue("@Name", TextBox1.Text);
            cmd.Parameters.AddWithValue("@Sal", TextBox2.Text);
            cmd.Parameters.AddWithValue("@FirstName", TextBox3.Text);
            cmd.Parameters.AddWithValue("@LastName", TextBox4.Text);
            cmd.Parameters.AddWithValue("@Phone", TextBox5.Text);
            cmd.Parameters.AddWithValue("@Fax", TextBox6.Text);
            cmd.Parameters.AddWithValue("@Web", TextBox7.Text);
            cmd.Parameters.AddWithValue("@Pwd", TextBox8.Text);
            cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            ex.Message.ToString();
        }
        finally
        {
            conn.Close();

        }



    }
protected void clear_Click(object sender, EventArgs e)
{
    TextBox1.Text = "";
    TextBox2.Text = "";
    TextBox3.Text = "";
    TextBox4.Text = "";
    TextBox5.Text = "";
    TextBox6.Text = "";
    TextBox7.Text = "";
    TextBox8.Text = "";
}
}