Hi all, I had installed Framework 1.1 (on my HDD) and had created the SETUP files for my project. Now I had installed Framework 2.0 on my client machine. When I try to run SETUP from my Client machine, the SETUP program prompts to install Framework 1.1. My question is; Do I need to recreate/run the SETUP wizard again on my machine, so that the new framework 2.0 would be registered on the SETIP program? or I simply install the framework 1.1 on my client machine? Tnx

Hi ppl, I have installed Server 2005 and when I try to run my application I get the following error mssg: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. Code: Imports System.Data Imports System.Data.SqlClient Public Conn As SqlConnection = New SqlConnection Dim da As New SqlDataAdapter Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Conn.ConnectionString = "Data Source=(local);" & _ "Initial Catalog=Rsch1;" & _ "Integrated Security=SSPI" Conn.Open() ----------> Error Mssg What could be the problem? Tnx

Hi, I got the SQL server 2005 Express installed but dunno how to import my data from the MDB files. Wr do I look for this? Do they have it in on EX Ed? Tnx

Hi all, I have installed my program on my network machine (EXE and the DB) I have set the sharing & Security for the folder of the network machine When I try to run the program from my machine I get the following error: Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version= 1.0.5000.0, Culture =neutral, PublicKey Token = b77a5c561934e089 failed It runs fine from the network machine i.e. If run it from the NETWORK machine. This is the code for me to open my conection: Imports System.Data.SqlClient .... Dim Conn As SqlConnection = New SqlConnection Conn.ConnectionString = "Data Source=(local);" & _ "Initial Catalog=Rsch1;" & _ "Integrated Security=SSPI" Conn.Open() How do I set the permision for the network machine? Tnx

Hi ppl, I have created an ODBC connection using the ODBC wizzard. I am using VB.NEt and SQL server The DSN name : Rch1 Description of Data source : SqlRch SQL Server Connection "MT1" This code is not working Public conn As New OdbcConnection("Provider=sqlodbc;server=Rch1 ;Database=Rch;Trusted_Connection=YES;") But wont connect. I get the following error: An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in system.data.dll Additional information: System error. Tnx -- modified at 11:01 Wednesday 17th May, 2006

Pls Could you give me some more info on this. Tnx

I need to run my program on my client machine. I had developed my program on my machine and created the DB on my machine. Now I need to transfer the db and my EXE file on to another machine The server name on my machine shows Running - \\Rch1 - MSSQLServer But the server name on the second machine Running - \\Krnot - MSSQLServer How do I replace the servername. My code; Public conn As New OleDbConnection("Provider=sqloledb;server=Rch1;Database=Rch;Trusted_Connection=YES;") Tnx

Hi Ppl, On installing projects/packages on XP I get this error mssg missing mfc7xxxxx.dll (where x varies) Where can I get an installable copy of these runtime, or the component dll files, for XP? Tnx

Hi, I would like to use the F1 and F2 key to set the focus between 2 grids in the form. Lets say the cursor focus is in DBgrid1, on hitting F1 I want the focus to shift to Dbgrid2. And again on hiting F2 I want the focus to go back to DBgrid1. Here is a piece of my code but wont work. It does not give me an error mssg but wont fire. If I change it to DbGrid2.Focus = True then I get an error mssg. Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyDown If e.KeyCode = Keys.F2 Then DBGrid2.Item(0, 0).Focus = True 'Dbgrid2.Focus = True End If End Sub

Hi all, Can some one help me with the AxFlexgrid. How do I populate a flexgrid from my dataset. Tnx

Hi Ppl, I would like to populate my datagrid with just the months in vertical order with the datasource from a dataset. From my dataset I can get 2 col namely QtyOrdered and QtyTaken But I would like to display these for 12 month period as shown below Month QtyOrdered QtyTaken Difference Jan 10 20 +10 Feb 20 10 -10 Mar 30 10 -20 ... ... Dec 50 20 -30 Can I do this in my SQL statement or do I have to do this at grid popluation? Tnx

I could not understand the solution. Can you pls explain in detail. Tnx

Hi All, I have populated my DataGrid1 from the dataTable. When I select the record and hit the 'DEL' key it removes the record from the grid. I would like to prompt the user on 'DEL' keypress and then remove the row from the grid. Is this possible. Tnx

When I set the prefered col width to 200 all the other columns too take the same width. How do I specify the 2nd col with a different width. Tnx

Thanks a bunch.

Hi all, I am trying to fix teh col width of my datagrid but I get an error @ dbgrd.GridColumnStyles(0).Width = 50 The error Msg is : An unhadled exception of type 'System.ArgumentOutOfRangeEception' Occured in mscorlib.dll. Addional Information: Index was out of range. Must be non negative and less than the size of the collection. Code: With ds.Tables("Ord1") Dim iCount As Integer Dim nRow As Data.DataRow For iCount = 0 To .Rows.Count - 1 nRow = objDT.NewRow() nRow(0) = CType(.Rows(iCount).Item(0), String) nRow(1) = CType(.Rows(iCount).Item(1), String) nRow(2) = CType(.Rows.Item(iCount).Item(2), Long) objDT.Rows.Add(nRow) Next Dim dbgrd1 As DataGridTableStyle = New DataGridTableStyle() dbGrid1.DataSource = objDT dbGrid1.ReadOnly = True Dim dbgrd As DataGridTableStyle = New DataGridTableStyle() dbgrd.MappingName = "Ord1" dbGrid1.TableStyles.Add(dbgrd) dbgrd.GridColumnStyles(0).Width = 50 dbgrd.GridColumnStyles(1).Width = 500 dbgrd.GridColumnStyles(2).Width = 500 can some one help. Tnx

Hi all, Why wont my sql query work. It returns with no records. SELECT pkey, description FROM Test WHERE (((test.description) Like 'DEL%')) Yet there is a record with 'DELIVER' in the description col of the Test table. Tnx

The grid is populated from the data table.

Hi all, I would like to use a for next loop with a Datagrid. I have 2 grids in my form. Dbgrid1 and Dbgrid2 In my Dbgrid1 I have 2 cols Col1 has 2A 3B 4C Col2 Has 10 20 30 I want to calculate the total on Col2 using For next eg: for i = 0 to 2 Total = Total + current(col2) next Then: Insert the total in the first row of the second col of my second datagrid: Can some one give me the code. Tnx

Hi all, I would like to know if we could set a hot key to open a specific tab page. I have a form with the tabPage object stuck on it. On opening the form I have the first tabPage opened by default. I want to set my F11 key to open the second tab page. Is this possible. Tnx