|
Thanks Nilesh Hapse!
Yeah, this application is using Go Diagram DLL also. But it's running fine at another pc with window server 2003 also.
You mean we need to install Go Diagram DLL at every pc which running this application? How can we know whether this DLL is registered on the machine or the reference path is correct ?
|
|
|
|
|
I think it needs GO Diagram.
They (Northwoods software ppl) say that you don't need Go Diagram installed on each and every machine. They have mentioned this in under Deployment section of GoWinIntro.doc document which will be in your samples folder of Go Diagram.
I am still working on that.
But i got rid of that error by installing GO Diagram temporarily on test machine.
But i hope that we don't need to install GO diagram on every machine.
You can also try installing GO Diagram on the machine where you aer getting this error message...
|
|
|
|
|
Hi
I have set width for each column in the Datagrid through Property Builder--AFormat--Columns--Setting the width for each column....
My problem is,though i have set width for the columns,the cell width increases if the data in any of the cell is lengthier...
How to retain the width and wrap the text within the cell? (i have checked 'Wrap textbox within the cell' textbox in the Property Builder--AFormat--Columns)
Please help me!
Thanks!
|
|
|
|
|
halllo Everyone,
will anyone tell me how to see changes in my datagridview on updating records.
i wrote following code on my update commandButton. it is affecting the database & showing updated values in related textboxes of that form also.
But it is not updating my datagridview on same form.
'' *****************************************************
Dim cmd As MySqlCommand
cmd = New MySqlCommand("UPDATE cust_mast c SET CustName='" & txtCustName.Text & "' where
custid=" & Val(txtCustId.Text) & ";", conn)
cmd.ExecuteNonQuery()
MyDataAdapter.SelectCommand = cmd
MyDataAdapter.Fill(ds, "cust_mast")
''---------------------------------------------
DgvCustList.DataSource = ds.DefaultViewManager
DgvCustList.DataMember = "Cust_mast"
'' *****************************************************
priya
|
|
|
|
|
|
Through utilities on your PC, you can use Task Manager or Process Viewer.
Through VB.Net, you can look at the My.Computer namespace.
Shreekar
|
|
|
|
|
hi,
i m using mysql & vb.net(winforms) in my application
will anyone help me in my Udate Query?
If conn.State = ConnectionState.Closed Then
Connect()
End If
Dim da As MySqlDataAdapter = New MySqlDataAdapter()
Dim cmd As MySqlCommand
Dim parm As MySqlParameter
' Create the SelectCommand.
cmd = New MySqlCommand("SELECT * FROM cust_mast WHERE CustName=?name", conn)
cmd.Parameters.Add("?name", MySqlDbType.VarChar, 45, txtCustName.Text)
da.SelectCommand = cmd
da.Fill(ds, "cust_mast")
If editFlag Then ''---------------Update Logic---------------
' Create the UpdateCommand.
cmd = New MySqlCommand("UPDATE cust_mast SET Address=?addr where custname=?
name;", conn)
cmd.Parameters.Add("?addr", MySqlDbType.VarChar, 200, txtAddr.Text)
parm = cmd.Parameters.Add("?custname", MySqlDbType.VarChar, 15, txtCustName.Text)
da.UpdateCommand = cmd
da.Update(ds, "cust_mast")
da.Fill(ds, "cust_mast")
Above code i wrote on my Update button,it is not giving any error but not affecting database.
Will u tell me how shuld i update my receords
priya
|
|
|
|
|
From my limited knowledge of parameterised SQL queries/statements,
priya_p233 wrote: WHERE CustName=?name", conn)
cmd.Parameters.Add("?name", MySqlDbType.VarChar, 45, txtCustName.Text)
this seems a bit wrong. It should read something like this:
WHERE CustName=?", conn)
and
cmd.Parameters.Add("name", MySqlDbType.VarChar, 45, txtCustName.Text)
Similarly for the update statements.
I may be wrong, so for better help, read up MSDN on parameterised SQL queries/statements.
Shreekar
|
|
|
|
|
You can use this sub
Public Sub ExceCommand(ByVal SqlCommand As String)
If conn.State = ConnectionState.Open Then conn.Close()
conn.Open()
Dim Sqlcom As SqlCommand = New SqlCommand(SqlCommand)
Sqlcom.CommandType = CommandType.Text
Sqlcom.Connection = conn
Sqlcom.ExecuteNonQuery()
conn.Close()
End Sub
then you can call your sql statement as :
ExceCommand ("UPDATE cust_mast SET Address=..... where custname=.....")
-- modified at 0:28 Monday 22nd January, 2007
jooooo
|
|
|
|
|
hi,
Thnx for help. but if i m using above execute commant to update my table which contains many fields, it would be tedious to maintain txtbox & double cotes values...so i wrote tht code.
-thnx Regards Priya.
priya
|
|
|
|
|
Hi,
I want to show dynamically designed html page in the vb.net form using webbrowser control. I have the code like this,
Dim doc As mshtml.HTMLDocument
doc = AxWebBrowser1.Document()
But when I option strict on, it gives me error as
"Option Strict On disallows implicit conversions from 'System.Object' to 'mshtml.HTMLDocument'."
How do I resolve this any luck, If i switch off option strict then it works fine.
Regards,
Rams.
-- modified at 23:59 Sunday 21st January, 2007
Be simple and Be sample.
|
|
|
|
|
What do you mean by 'dynamically designed' - do you want to write a web designer ? You'll need to manipulate the HTML of the control for that.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
You can use the CType statement like below:
doc = ctype(AxWebBrowser1.Document(),mshtml.HTMLDocument)
However, you should be using the Web Browser Control that comes with .Net, not the COM one.
Hope this helps.
Shreekar
|
|
|
|
|
Thanks,
I had another problem, how do i set the left and top margin for the webbrowser control. Also, I need the focus to be always on last line.
Regards,
Rams.
Be simple and Be sample.
|
|
|
|
|
Do that in the HTML page.
Create an anchor tag and point the web URL to that anchor tag. like:
abc.html#tagname
Shreekar
|
|
|
|
|
Hi,
I set the left and top margins. Now i need how to auto scroll to last line of my browser control.
Regards
Rams.
Be simple and Be sample.
|
|
|
|
|
Hi,
I came to know the way to auto scroll to bottom, we need to write these following code in AxWebBrowser1 documentcomplete event as,
If e.pDisp Is AxWebBrowser1.Application Then
AxWebBrowser1.Document.parentWindow.scrollto(0, 99999999)
End If
I got problem if the option strict is on as "Option Strict On disallows late binding."
How to solve this error
Regards,
Rams.
Be simple and Be sample.
|
|
|
|
|
I'm using VB.Net and i can't retrieve my data from my database to my PDA.
Is it compulsary to put sqlserver ce provider?
I had try both of the below coding also can't retrieve.
1.) conn = New SqlCeConnection("Data Source = C:\teh\teh\MyDatabase.sdf")
2.) conn.ConnectionString = "Provider=.NET Framework Data Provider for SQL Server Mobile Edition; data source=C:\teh\teh\MyDatabase.sdf"
Can anyone correct my error or show a simple program?
Thanks.
|
|
|
|
|
HI everybody,
pls help me to find out this problem. I want to show time in the status bar. if i want to show CAPS LOCK, NUM LOCK, what steps i need to do.
sourish
|
|
|
|
|
Just add a StatusBar on your form (as you would a TextBox), add as many Panels you want in it. Then write any information you want in them.
The Quickest way to get info on small stuff like this is with your good friend "GOOGLE"
Try googling "vb.net Statusbar", "vb.net caps lock", "vb.net ....anything..."
|
|
|
|
|
Hello, i am trying to develop a derived tcplistener and a tcpclient. my derived tcpclient has a tcpclient and a string object as private fields. i would to be able to access the string field when my derived tcplistener object accepts a connection. How can i do that. please at the code below to see what i am trying to do.
Public Class MyTcpClient
Inherits TcpClient
Private _id As String
Private client As TcpClient
Public Sub New(ByVal myIpEndPoint As IPEndPoint)
MyBase.New(myIpEndPoint)
thisClient = New TcpClient
_id=nothing
End Sub
Public Property GetId() As String
Get
Return _id
End Get
Set(ByVal Value As String)
_id = Value
End Set
End Property
end class
Public Class MyTcpListener
Inherits TcpListener
Private myClient As MyTcpClient
Public Sub New(ByVal myIpEndPoint As IPEndPoint)
MyBase.New(myIpEndPoint)
myClient = New MyTcpClient
End Sub
public function MyAcceptTcpClient as MyTcpClient
'need help writing this part
end sub
end class
public class chat
public sub listen()
dim server as tcplistener
server = New MyTcpListener(thisIpEndPoint)
server.Start()
dim client as MyTcpClient
if server.pending then
client=? server.MyAcceptTcpClient
end if
end sub
end class
|
|
|
|
|
Sir/Madam,
Can I programically validate the email placed into the textbox.in vb.net(window application).
PLease help.
Thanks and regards
Pankaj
|
|
|
|
|
You can validate the format of the email address, but you can not validate that it is an existing address.
This is a regular expression pattern that I use sometimes to verify email addresses: "^[\w\-%~\.]+@[\w\-\.]+\.[\w]{2,4}$". It's based on the specification of how an email address may look, so it might be too strict as some email addresses does not follow the specification. You might want a more relaxed pattern like "^.+@.+\.\w{2,4}$".
---
Year happy = new Year(2007);
|
|
|
|
|
Sir/Madam,
I searched a email validation string
Function IsValidEmail(ByVal strIn As String) As Boolean
Return Regex.IsMatch(strIn, "^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$")
End Function
Is this useful.
Thanks and Regards
Pankaj
|
|
|
|
|
Sir/madam,
Can i programically call the outlook to send the email in vb.net (Window Applications).
Thanks and Regards
|
|
|
|