|
I want to put a field from table in database to a combo box without a wizard. I want to using coding...can you help me ??? Please...
|
|
|
|
|
Request the table from the database, make it the datasource, and make the displaymember property the name of the correct column in the table.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
what section are you getting stuck on?
1) Create a Connection String that points to you database
2) Creating a Query String that selects the data that you want
3) Running the Query
4) Storing the retrieved values in a dataset or datatable
5) Setting the DataSource DisplayMember and ValueMember properties of the Combobox
Show what you have done for those 5 steps and if you still have a problem let us know
/jason
|
|
|
|
|
Hi all,
can someone help out on how to send email from my local host to the webmail using vb.Net???
Thanks in advance..
besah
|
|
|
|
|
well you can try this
imports system.net.mail
Private sub SendIT
Dim objMail as new MailMessage (strFrom, strTo, strSubject, strBody)
Dim objSend as new SMTPClient
objSend.Host="Your SMTP server"
objSend.Send(objMail)
End sub
As You can see, it is simple 
Oggy
|
|
|
|
|
Sorry ...but i did not get it ...
"Localhost" .... if u want to use localhost then u shud configure smtp relay option in IIS.
Correct me if i am wrong ..
Thnx ...hope it helps.
Swammingo.
|
|
|
|
|
I am working on a program for VS.net that reads data from XML file and list them in treeview. The XML file named Dooa. Elements under Dooa are F1, F2, and F3. F1 is the root (parent) and F2 is the child and the content of F3 will be displayed in TEXTBOX1 if F1 or F2 selected. See the code.
What I want is that, if F1 are same for some roots then F2 (child(s)) for these roots should be listed under F1. Example
This is the XML
<dataroot NS0:noNamespaceSchemaLocation="Dooa.xsd" generated="2005-11-01T15:40:12" xmlns:NS0="Dooa">
<Dooa>
<F1>First</F1>
<F2>Car1</F2>
<F3>Home1</F3>
</Dooa>
<Dooa>
<F1>First</F1>
<F2>Car2</F2>
<F3>Home2</F3>
</Dooa>
<Dooa>
<F1>Second</F1>
<F2>CarA</F2>
<F3>HomeA</F3>
</Dooa>
<Dooa>
<F1>Second</F1>
<F2>CarB</F2>
<F3>HomeB</F3>
</Dooa>
</dataroot>
Then treeview should be like this
First
Car1
Car2
Second
CarA
CarB
What is the missing code that should take care of what I need as explained above??
Here is the code
Imports System.IO
Imports System.Xml
______________________________________________________________________
Public Class Form1
Inherits System.Windows.Forms.Form
Private Const dataXML As String = "c:\Data1.xml"
Private dsData As System.Data.DataSet
______________________________________________________________________
Private Sub loadData()
dsData = New DataSet("Data")
Dim fs As New FileStream(dataXML, FileMode.Open)
Dim xr As New XmlTextReader(fs)
dsData.ReadXml(xr)
End Sub
______________________________________________________________________
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
loadData()
Dim dr As DataRow
For Each dr In dsData.Tables("Dooa").Rows
TreeView1.Nodes.Add(dr("F1").ToString()).Nodes.Add(dr("F2").ToString())
Next
End Sub
_______________________________________________________________________
Private Sub TreeView1_AfterSelect(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles TreeView1.AfterSelect
Dim dr As DataRow
For Each dr In dsData.Tables("Dooa").Rows
If dr("F2").ToString() = TreeView1.SelectedNode.Text.ToString() Then
TextBox1.Text = dr("F3").ToString()
TextBox3.Text = dr("F2").ToString()
End If
Next
End Sub
_____________________________________________________________
Private Sub MenuItem2_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click
TreeView1.BackColor = Color.FromArgb(212, 199, 130)
TreeView1.Visible = True
End Sub
-- modified at 20:36 Wednesday 29th March, 2006
|
|
|
|
|
|
here's the brief story: it's about a transportation application
i create 2 projects(programs),admin(with database,journey,driver name,mileage setting,etc) and user interface page(user can book ticket)..admin can change(add/delete) info,etc and automatically the info is changing in other project(user interface)
ex:admin add new journey...and automatically there is a new journey added on user interface(station kiosk)
i know how to change things in other forms in one project..but how to do it if the project is separated?
or i have to add the user interface page to admin ?or what?haha...im getting worse 
thank you
|
|
|
|
|
you're going to need a database that can be accessed by both applications:
admin creates new journey in database
station kiosks reads all journeys from database
this way, you can create 2 applications that share the same data
/jason
|
|
|
|
|
i have program "A" as an admin page that can change what in program "B"
im confuse..please anyone help me
thanks
|
|
|
|
|
Khomeini wrote: i have program "A" as an admin page that can change what in program "B"
I dunno - you tell me.
Khomeini wrote: im confuse.
Well that makes at least two of us 
Tell us what problem you are having (i.e. be more explicit) and we can help.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
I have finished my app and i want that when double click on the file that ends with ".wuzx" that it opens in my app i did all in setup and argument is "%1" for open... buth what i need to do that if double clicked that by app loads and opens that file! Allso if you know for edit and print...
Ummmmmm not urgent... 
and not 1line question so i will write a little more, Well...
I am working a small reader program like notepad buth fast and it has 1000 functions, i am working that for me and my father becose he needs something like that and i need it two becose i dont like resizing forms and big forms i want small fast and ugly...
its enough!!!
<blink>FeRtoll Software.net
------------
E-Mail me
WebPage
|
|
|
|
|
The double clicked file name will be passed as the first argument into your app's Main function. If you don't have a Main, then I suggest that you create one as shown below. You'll also need to change your project's Startup Object to "Sub Main".
Public Class Main
Public Shared Sub Main(ByVal args() As String)
Dim fileName As String = String.Empty
If (args.Length > 0) Then
' File was double clicked on.
fileName = args(0)
EndIf
End Sub
End Class
There is more info on this subject in this forum. Just do a search.
-- modified at 17:30 Thursday 30th March, 2006
Fixed mistake in the above code. I wrote it a little too quickly.
|
|
|
|
|
thanks man...
Joshua Quick wrote: There is more info on this subject in this forum. Just do a search.
ja buth i have slow internet!!!  i am from croatia.
<blink>FeRtoll Software.net
------------
E-Mail me
WebPage
|
|
|
|
|
FeRtoll wrote: a buth i have slow internet!!!
What a lot of crap[^]!
Slow internet does NOT mean you can't do basic searches on The Code Project or Google or <insert your="" favourite="" search="" engine="" name="" or="" website="" here="">. The searches are performed on the web servers - not your machine.
This reminds me of an old English proverb - "a bad tradesman always blames his tools".
FeRtoll wrote: i am from croatia.
Why does this matter?
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
|
|
|
|
|
ummmmmmm i did on properties ˇ
Joshua Quick wrote: You'll also need to change your project's Startup Object to "Sub Main".
and i inserted new class
and copy your code buth it says...
No accessible 'Main' method with an appropriate signature was found in 'NodeDraw'.
 ~
<blink>FeRtoll Software.net
------------
E-Mail me
WebPage
|
|
|
|
|
If you were not such a smartass all the time, I might have stopped to try and help you with this.
|
|
|
|
|
Oops. I made a mistake. 
The Main() method needs to be marked as Shared.
Public Shared Sub Main(ByVal args() As String)
|
|
|
|
|
|
 Hey guys! I am a rookie having a problem and need your help. I am trying to run the SMS ClientAction script below on a list of targeted machines (using a .TXT file) but I can't get it to execute the .VBS on the targeted machines,instead the .VBS is only executing and pulling back results of the local machine the number of times it see's a targeted machine.
For example if I have 5 machines targeted, it will pull back the results of the local machine 5 times. I am trying to have the results show the Machine Name and the Count. I have the .vbs & .bat. listed below. I'd appreciate any help you can give.
=========.vbs file=========
dim oCPAppletMgr 'Control Applet manager object
dim oClientAction ' Individual client action
dim oClientActions ' A collection of client actions
dim iCount 'Number of actions
'Get the Control Panel applet manager object
set oCPAppletMgr=CreateObject("CPApplet.CPAppletMgr")
if err.number<>0 then
Wscript.echo "Couldn't create control panel application manager"
Logging(FSO)
end if
'Get a collection of actions
set oClientActions=oCPAppletMgr.GetClientActions
if err.number<>0 then
wscript.echo "Couldn't get the client actions"
set oCPAppletMgr=nothing
end if
wscript.echo oClientActions.Count
'Display each client action
For iCount = 1 to oClientActions.Count
set oClientAction=oClientActions.Item(iCount)
next
set oClientActions=nothing
set oCPAppletMgr=nothing
=========batch file==========
set log=Log.csv
if /i exist oldlog.csv del oldlog.csv
if /i exist "%log%" ren "%Log%" oldlog.csv
echo Machine,Object,Count > %log%
for /f "tokens=1" %%i in (Machine.txt) do call :checker %%i
:Checker
Set Machine=%1
Set Count=
cscript action.vbs %1 >Temp.txt
For /F "skip=1 Tokens=1" %%i in (temp.txt) Do Set Count=%%i
FIND /I "Unable to access" TEMP.TXT > NUL
IF NOT ERRORLEVEL 1 SET Status=Unable to Access
:LOGGING
echo %machine%,%count%,%object% >>%log%
goto :EOF
|
|
|
|
|
I still did not get my asnwer...
Problem is :-
when i run my program, and open the particular form for editing the field's value...all d values r shown in the textboxes, but the data of combo box does show which we had selected while inserting the values in d form..so, i want to know the code for setting that problem which can show the data of combo box while the filled form showing its data.
Gurpreet
|
|
|
|
|
rahsi wrote: I still did not get my asnwer...
Maybe you were not clear enough in your question - and perhaps you are double-posting so that the thread you started this question on is now out of sync? Hmmmm???
In any case you have been given direct answers in the past. You should lookup the methods and properties of the ComboBox object (put the cursor over ComboBox in your code and press F1). The method you seek is contained within.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
thanks steve...I need to consult some1 else. be rite back if i fix in some other prob.
Gurpreet
|
|
|
|
|
Ok I'm writing this program just to play Hi-Low Guessing game. I have it so the guessing game part works but I'm having lots of trouble trying to get my counter to work so that when my counter <= 4 it turns on smiley face and when its over it just says congrats you guess the number..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
