|
Thanks Bob for that response. That is a good site.
Please take a look at this code:
<Dim db as NEW ADO DB.Connection
Dim rs as NEW ADO DB.Record-set
DIM spath as String ' Path for the database
Dim SQLL as String ' Sql statement
sPath = app.path & "\DB\Name.mdb
>
Now the question is Bob: Is this code sufficient for connecting to an access DB? If not what is lacking?
Thank you!
|
|
|
|
|
i installled a window service that will access ftp server folder.
i get the following error The remote server returned an error: (500) Internal Server Error.. any idea pls
|
|
|
|
|
|
the article i found are on webservice. my application is window service. it actually execute the create folder before trowing the error
|
|
|
|
|
Your best bet to troubleshoot this issue is to mimic the steps that the windows service is doing.
Perform the same actions as the Service (login to FTP, read folders, etc) using a manual FTP client like FileZilla. Make sure you use the same login permissions, and are running the software from the same computer.
|
|
|
|
|
I'm developing a UserControl and I need to know when a user has changed the BorderStyle of the UserControl. I know that this is trapped in the UserControl's StyleChanged Event. But, I don't know how to determine which of the Control's Styles has changed and what it has changed to.
Does anyone have a code sample that would demonstrate this Event please.
Regards, Graham
|
|
|
|
|
Hi,
First Each n every control has its own style changed event if u still facing the problem in it then check the fous or active control in your form , One the control has focused=true n active means that control's border sytle has changed....
Hope this will help U
Unless u don't give ur hundred percent whatever u r doing till there is no result of ur work...
|
|
|
|
|
I think that I'm too simple to understand all of this.
Could you please translate this into something like English.
I can also speak French if that is easier for you.
Regards, Graham
|
|
|
|
|
Which thing is difficult to understand my english or the meaning of this what i said???
Which default control your are using to create a new user control????
There is 3 methods of doing this
1> Take default control eg textbox n add new features to create new textbox usercontrol
2>Use more than 1 control to create new user control
3>Create own user control without using any default
So which method you are using and which control???
May be i help u because i have also created user control before some time....
Unless u don't give ur hundred percent whatever u r doing till there is no result of ur work...
|
|
|
|
|
Seemed pretty clear to me, mind you your sig says it all - drop 10 characters from a sentence and make it difficult to read!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
What is difficult is the abreviations you are using.
I'm 68 years old and all of the younger generation words are foreign to me.
Please be explicit. English or French is OK with me.
Regards, Graham
|
|
|
|
|
What the keyboard challenged is trying to say is that each of your objects within the control has a border. If it is the UC borderchange event then I beleive it will be the UC container. If you change the border on a textbox within the UC does the event for the UC fire. If so then as ~V~ said chek the current active control inside the UC.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you.
Now I'm closer to the solution.
I'll test with that and get back to you.
Regards, Graham
|
|
|
|
|
i have a temporary created excel application
in that in a particular cells i want to fill the values
from the form
example
in excel i have format like this
name:
father's name:
etc
now i want to fill these fields from vb.net form
plz help me
thanks in advance
vijay kumar d
|
|
|
|
|
Microsoft has an interop library for controlling Excel, that's what you probably want to look at.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Hii
First import the microsoft.office.interop.excel library and then use the following code to insert data in excel sheet.
dim xlapplication as new excel.application
dim myworkbook as new excel.workbook
dim myworksheet as new excel.worksheet
myworksheet.cells(1,1).value="Name :"
myworksheet.cells(2,1).value="Address :"
myworksheet.cells(3,1).value="Age :"
Thanx
~Khatri Mitesh
|
|
|
|
|
Is there anyway to translate this Excel program into a VB.Net one ?
The Program goes like this:
I enter 2 fields : Density & Temperture .
They will be converted and used later on to get the Coefficient , The putput is Tabel ASTM table 54-B
2 Input Boxes: in locations
I8 and J8
Box K8
=IF((J8*100)-INT(J8*100)<0.1,INT(J8*100),IF((J8*100)-INT(J8*100)<0.3,INT(J8*100)+0.2,IF((J8*100)-INT(J8*100)<0.5,INT(J8*100)+0.4,IF((J8*100)-INT(J8*100)<0.7,INT(J8*100)+0.6,IF((J8*100)-INT(J8*100)<0.9,INT(J8*100)+0.8,(INT(J8*100)+1))))))*10
Box L8
=IF(K8<=771,(346.4228/K8^2)+(0.4388/K8),(IF(K8>=771.1,(IF(K8<=787,(2680.3206/K8^2)-0.00336312,(IF(K8>=787.1,(IF(K8<=838.49,(594.5418/K8^2),(IF(K8>=838.5,(IF(K8<=1075.5,(186.9696/K8^2)+(0.4862/K8))))))))))))))
Output Box M8
=(ROUND(EXP(-L8*(I8-15)-0.8*(L8^2)*((I8-15)^2)),4))
|
|
|
|
|
You have an excel formula and you want to write a VB program that does the same ? Seems pretty simple to me, do you know any VB ? If you don't and you have no intention to learn, it could save you some grief to just pay someone to write this for you.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Hy,
I just wanted VB.Net program or formula that do the same job as the Excel one. That's all. I couldn't read well the Excel formula & I need to use i in VB.Net.
J ,
|
|
|
|
|
Hii
Use like this
myworksheet.cells(11,8).Formula= "IF((J8*100)-INT(J8*100)<0.1,INT(J8*100), _
IF((J8*100)-INT(J8*100)<0.3,INT(J8*100)+0.2,IF((J8*100)-INT(J8*100)<0.5,INT(J8*100)+0.4, _
IF((J8*100)-INT(J8*100)<0.7,INT(J8*100)+0.6,IF((J8*100)-INT(J8*100)<0.9,INT(J8*100)+0.8,(INT(J8*100)+1))))))*10"
may be this helps you.
Thanx
~Khatri Mitesh
|
|
|
|
|
I have a dropdown list box on in a web application.
When a user clicks on an item, I want it to
be removed from the list. Below is my code for doing that:
Protected Sub ddlSelected_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlSelected.SelectedIndexChanged
If ddlSelected.SelectedIndex <> -1 Then
ddlSelected.Items.RemoveAt(ddlSelected.SelectedIndex)
End If
End Sub
My problem is, when a user clicks on the last item in the list, it does
not get removed. How do i handle this?
|
|
|
|
|
HI,
Here is an alternative,
would you consider trying to clear the drop downlist seeing that it is the last item in the list.
me.dl.items.clear()
just a thought,
Thanks
Anoop
|
|
|
|
|
|
Hi ,
i am using vs2005 and tried using the below command...it works for me...
If Me.dlCustomers.Items.Count = 1 Then Me.dlCustomers.Items.Clear()
not sure why it wont work for you....
sorry!
|
|
|
|
|
Here's the new code i'm using:
If ddlSelected.SelectedIndex <> -1 Then
ddlSelected.Items.RemoveAt(ddlSelected.SelectedIndex)
ElseIf Me.ddlSelected.Items.Count = 1 Then
Me.ddlSelected.Items.Clear()
End If
Still won't work because if there's only ONE item in the list, there's no
textchange event to fire nor indexchange event to fire.
Anyway, I changed the dropdownlist box to a regular listbox and my code works fine.
I appreciate the help.
|
|
|
|