JarHead

I'm using Visual Basic .net to interface with a Postgresql server. I'm not sure if those terms apply to anything but MS Sql server. I'm trying to add about 200,000 rows to this Postgresql server with the click of a button, and not have to wait all day for the operation to process. Any ideas?

I'm trying to find the best, fastest way to add a large number of rows to my server at a time. The way I'm doing it now involves a loop that updates each row individually, which is a lengthy procedure. Is there a better way?

I'm trying to print (to the printer) a page of formatted text (a combination of fonts, styles and sizes), but I have no clue where to start. I assume it has something to do with the graphics object, but didn't get any further then that, please help!

I need help to configure the Datagrid control to: Select the entire row when clicked (not just a cell). Set individual column widths. Make data displayed read only. I've been searching google for a few hours, and couldn't find anything, please help if you can.

using System.Data; using Npgsql; Npgsql.NpgsqlConnection objConn = new Npgsql.NpgsqlConnection("Server=TestServer;Port=5432;User ID=Test_User;Password=Test_Password;Database=TESTDB;"); objConn.Open();

I am attempting to connect to a PostgreSQL database via C# or VB.net using the Npgsql .Net data provider, but I get the following error when I attempt to open the connection: An unhandled exception of type 'System.IO.IOException' occurred in npgsql.dll Additional information: Unable to read data from the transport connection. Any ideas?

I have recently decided to make the switch from SQL server to PostgreSQL, however I am having issues making a connection to the server (basically, I have no idea what I'm doing). I simply want to make a connection to my server, without using the PostgreSQLDirect .Net Dataprovider (the one you have to pay for). I'm willing to use ODBC or anything, I need help!

Ok, very frustrating problem...I am adding a new row to a database, using SQLCommandBuilder to construct the SQL statement for me, but as it does so, its ignoring one of the fields! please help... here the code... objNewRow("Username") = UN objNewRow("Password") = PWD ' <----- IGNORING THIS FIELD objNewRow("FName") = FName objNewRow("LName") = LName objDataTable.Rows.Add(objNewRow) Dim objInsertCommand As New SqlClient.SqlCommandBuilder(objAdapter) objAdapter.InsertCommand = objInsertCommand.GetInsertCommand objAdapter.Update(objDataSet) I have read objAdapter.InsertCommand.CommandText, and there is no password field. Anyone know a way to help?

I need to be able to change the windows GUI to custom graphics (i.e. windows titlebar, command buttons, the little 'x' button at the top) I know how to do it the hard way - that is, custom design each form, replacing all the buttons with images, but I was hoping somebody here can point me to a quicker, easier solution. Thanx

well, there are two ways...one would be to declare a global variable in a module, and another to create a public property in the form: '***somewhere in the child dialog Public Readonly Property Example() as string get return (textbox1.text) end get end property '***in the parent dialog Private Sub Button1_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Dim frm As New frmDialog() frm.ShowDialog() MsgBox(frm.Example) End Sub its a crud example that hopefully gets the point across

how do i disable autoredraw in a form? i want to have implicit control over when my form, and the controls it contains are drawn. Thanks