You searched for the word(s): userid:875072

More Search Options

RSS Available

• check for duplicate records

  Hi, I am using visual studio 2005, Asp.net c# and postgreSQL... I am trying to insert IDs into the database through a text box and a submit button. I want to check for duplicates before insertion and give an error when the ID already exists.. this is what I got so far: protected void btnAdd_Click(object sender, EventArgs e) { CoreLab.PostgreSql.PgSqlConnection cn = new CoreLab.PostgreSql.PgSqlConnection("my connection string"); string strSQL = "Select Count(win) as TheCount from tbl_win

  Posted to Other Databases (Forum) by maisa on 6/23/2009

• Re: check for duplicate records

  That worked :) Thank you so much

  Posted to Other Databases (Forum) by maisa on 6/23/2009

• connecting to postgresql

  Hi, I am working on asp.net c# with visiual studio 2005 and I would like to connect to postgressql..I have the PostgreSQLDirect.Net. I have successfully connected to the database but I want to replace those two lines with the proper lines for Postgresql: OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AccessDB\db1.mdb;User Id=admin;Password=;"); OleDbCommand cmd = new OleDbCommand(); any ideas? Thank you

  Posted to Other Databases (Forum) by maisa on 6/22/2009

• Re: connecting to postgresql

  Hi, Thank you for the hint but I'm still confused, I've seen some strings online but dont know whether to use: PgSqlConnection cn = new PgSqlConnection(@"Provider=PostgreSQL OLE DB Provider;Data Source=myServerAddress;location=myDataBase;User ID=myUsername;password=myPassword;timeout=1000;"); Or OleDbConnection cn = new OleDbConnection(@" Provider=PostgreSQL OLE DB Provider ;Data Source=myServerAddress;location=myDataBase;User ID=myUsername;password=myPassword;timeout=1000;"

  Posted to Other Databases (Forum) by maisa on 6/22/2009

• connect to postgres from ASP

  Hi, I've posted this question in another form, I've been helped but I guess I should post it in getting started since it is a very basic question, could you help me pls: I am working on asp.net c# with visiual studio 2005 and I would like to connect to postgressql..I have the PostgreSQLDirect.Net. I have successfully connected to the database but I want to replace those two lines with the proper lines for Postgresql: OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB

  Posted to Other Databases (Forum) by maisa on 6/22/2009

• on textChanged?

  Hi, I'm using ASP.net c#, visual studio 2005, and access 2003. I'm trying to add a record to a database with the info of a textbox when that textbox changes. so I wrote this code in the Textchanged method protected void _TextChanged(object sender, EventArgs e) { OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AccessDB\db1.mdb;User Id=admin;Password=;"); OleDbCommand cmd = new OleDbCommand(); cmd.CommandText = "insert into comments

  Posted to Getting Started (Forum) by maisa on 6/19/2009

• Re: on textChanged?

  Still no results and i received a syntax error when I added AutoPostBack="true" <asp:TextBox ID="COMMENT_BOX" Name="COMMENT_BOX" runat="server" Enabled="true" OnTextChanged="_TextChanged" Height="24px" Width="344px" AutoPostBack="true" />

  Posted to Getting Started (Forum) by maisa on 6/19/2009

• Re: on textChanged?

  I tried that, still doesn't work, and I don't know why I'm getting the syntax error

  Posted to Getting Started (Forum) by maisa on 6/19/2009

• Re: on textChanged?

  Well.. I don't have a choice here.. My boss wants me to save the information when it is written, without hitting an add button.. so I gotta do this

  Posted to Getting Started (Forum) by maisa on 6/19/2009

• Re: on textChanged?

  I tried that already and it didn't work and i also recieved a syntax error...

  Posted to Getting Started (Forum) by maisa on 6/19/2009