Comments by dcba1 (Top 70 by date)

i want datgrid to be filled at the time of laoding. and selection change event after form loading..

Not understood what you are saying. Where to add addhandler?

Its not like that I know via ADO.net.
I have installed software on three PC. I want to access database from server on that PC's.

I installed it 3 times.. There is no installation problem..

yes I have used mysqlfixtoolbox . But facinf same problem.

Yes I have uninstall all the file of mysql.. and installed it again. But problem doesn't solve.

I have already checked that site. My problem does not solve.

yes I have checked it. Certificate date also and computer date and time also.

I have install that certificate but it is not installed properly. I follow same procedure given in your link. How to download that certificate from internet (from where to download).

if Security Certificate is the problem. then how to resolve that. How to install the certificate? From where to download that certificate?

without user name and password that code works fine. But when I enter password and username it throws error. I want to copy username and password from from my application to website login page

I know that site. I changed that connection but still problem remains same.
I think its problem of drivers not connection string. But I don't know which drivers I have to install on 64 bit.

Public con As New ADODB.Connection

str_con = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=" + strdbpth + ";" & _
"Persist Security Info=True;"
con.Open(str_con)

str_con = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=" + strdbpth + ";" & _
"Persist Security Info=True;"

same

How to check empty cell from excel while importing data.
If cell is in number format.

can I use adobd to update records.. and oledb to display records on datagridview... means when i want to display more data the I use oledb connection and when I want to update something then I will use adodb..

Leave it. simple question .. how to load data in datagridview with fill method..
means is there any method in adodb to load datagrid faster..

I have tried it by removing code at the loading time.. It is fast...

form is ready as per client requirement so that I can't reduce no. of controls on form. No control is bound to the database.. I am searching data from database and displaying that on controls.

64 bit

I want that project run on windows xp,7 and windows server 2008 .
How to make it compatible so the it run on any system..

provider not found microsoft.jet.oledb.4.0
This error is thrown at the time of database connection...

what u want to say? Is there any solution for that??

Its for asp.net application.
I want it for windows application.
I want vertical scrollbar on left side..

I want it in vb.net windows application. I am not getting what you want to say.
how to set overflow-y:scroll?

thanks... my problem is solved

dropdownstyle is dropdown

Only want to execute that event when I click on combo box and change value manually.

I solve this problem myself.
I just import the visual studio settings from other pc where VS 2008 is working fine.

yes on vb.net

plz help me

I have tried back of database from mysql administrotor tool. But its not working. In this tool there is option for scheduled backup.

If any one have some other method please tell me.

But I want connection without databind method.

I just want query form in html that is send to my id when user enter something and click on submit button.

I know that solution. I have already apply icon in the project properties. But when I run the application it doesn't show that icon. When I create the project setup and install on pc then it should show that icon on short cut of the application.

how?

thanks

Dim rs As New ADODB.Recordset
Dim rs1 As New ADODB.Recordset
Dim rs2 As New ADODB.Recordset
Dim tmpSmptmsgk As Integer
Dim strSQL As String
Dim tmpgkmax As Integer
Dim tmpgkhlthplbm As Integer
Dim tmpsmtpmsnnm As String
If e.KeyData = Keys.Enter Then
tmpgkhlthplbm = gtgkeybydtls("HlthPrblmnm", cmbhlth.Text, "hlthprblm", "HlthPrblmgk")
Dim tmprwcnt As Integer
tmprwcnt = smptGridView1.RowCount - 1
tmpsmtpmsnnm = smptGridView1.Item(0, tmprwcnt - 1).Value
tmpSmptmsgk = gtgkeybydtls("Smptmsnm", smptGridView1.Item(0, tmprwcnt - 1).Value, "smptms", "Smptmsgk")
If tmpgkhlthplbm <> 0 Then
If tmpsmtpmsnnm <> "" Then
rs.Open("select * from smptms where Smptmsgk='" & tmpSmptmsgk & "'", con, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
If Not rs.EOF Then
rs1.Open("select * from hlthprblmssmptms where Smptmsgk='" & tmpSmptmsgk & "' and HlthPrblmgk='" & tmpgkhlthplbm & "'", con, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
If Not rs.EOF Then
Else
strSQL = "insert into hlthprblmssmptms (HlthprblmsSmptmsgk, HlthPrblmgk,Smptmsgk,Rfrncgk) values('" & tmpgkmax & "','" & tmpgkhlthplbm & "','" & tmpSmptmsgk & "')"
con.Execute(strSQL)
End If
rs1.Close()
refresh_main_frm()
Else
tmpgkmax = getMaxNo("Smptmsgk", "smptms")
tmpSmptmsgk = tmpgkmax
strSQL = "Insert into smptms (Smptmsgk, Smptmsnm) values ('" & tmpgkmax & "','" & smptGridView1.Item(0, tmprwcnt - 1).Value & "')"
con.Execute(strSQL)
rs1.Open("select * from hlthprblmssmptms where Smptmsgk='" & tmpSmptmsgk & "' and HlthPrblmgk='" & tmpgkhlthplbm & "'", con, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
If rs.EOF Then
strSQL = "insert into hlthprblmssmptms (HlthprblmsSmptmsgk, HlthPrblmgk,Smptmsgk) values('" & tmpgkmax & "','" & tmpgkhlthplbm & "','" & tmpSmptmsgk & "')"
con.Execute(strSQL)
End If
rs1.Close()
refresh_main_frm()
End If
rs.Close()
End If
End If
End If



this is my code. I have one datagrid and I to perform event when I change data on grid and press enter key.

I know this method. But I want it through code.

I want connection through code.

thanks!!!!!!1

yes.

if I press enter key then I want to edit the data in datagridview. I want to execute code on that event.

I have tried it by using
dataGridView1.Columns("ColumnName").ReadOnly = False
this property but it also not working

How to make Column read only in vb.net datagridview? I have 5 Column in datagrid. I want to edit only 3rd Column not all. I set datagirdview.Column(2).readonly=false
and datagridview property set to readonly true. But its not working. I can't edit that 3rd Column.

It also not working. I have already tried it.

Winform

if i use anchor property for the controls on my form some of data on form get lost. I have one checkedlistbox on form. I used anchor property for that. It shows only 3 items from the list.

if i use anchor property for the controls on my form some of data on form get lost. I have one checkedlistbox on form. I used anchor property for that. It shows only 3 items from the list.

I don't want to adjust user's screen resolution. I want to adjust my application based on user's screen resolution.

Is there other option to screen resolution. Can we set screen resolution dynamically?

form doesn't have properties such as Dock and Anchor. Label or button have that property. If I set the property for form resolution then it will automatically adjust all controls on the form.

can we open .aspx page in chome??????

http url

No. I tried to open it in Google Chrome. Because i want to see it will run on all browsers or not.I am developing that site on visual studio 2008.

This is my code
I have declared it by same code as u told.
But its not working
<table style="border: thin double #0B2161; width: 100%; height: 83px;"
frame="border">
<tr>
<td>
 User name

 

</td>
<td>
<asp:TextBox ID="TextBox1" runat="server">
</td>
</tr>
<tr>
<td>
  Password</td>
<td>
<asp:TextBox ID="TextBox2" runat="server">
</td>
</tr>
<tr>
<td>
  </td>
<td>
<asp:Button ID="Button1" runat="server" Text="Button" />
</td>
</tr>
</table>

event is not firing..

function is not working..