|
Dave Kreskowiak wrote: the imagination abounds with retribution
Oh yeah, you got it 
If you try to write that in English, I might be able to understand more than a fraction of it. - Guffa
|
|
|
|
|
you aren't making much sence 
|
|
|
|
|
Perhaps you should do you own course work, and not expect others to do it for you. I am sure we do not mind helping but I hope nobody is going to help you cheat !!!!
Steve Jowett
|
|
|
|
|
RAHUL2006 wrote: pls do the needful
You haven't said what it is you need help with. Having said that, we are not going to do your homework for you. You have to make the attempt and if you have any specific problems with the attempt we'll help you out with those specific problems.
|
|
|
|
|
hi,
ihave made a program for Exporting table values to Excel.
i have used Excel 2003 .
how can i run my VB.Net Exe in a system having Excel 2000.pls help me.
|
|
|
|
|
hi,
i m working in a project i m sending emails using outlook.
but now i want to send emails with out using outlook.
can any one help me.
pls.
|
|
|
|
|
Hi,
The example below is actually for VB.NET, so it may work in VB6 or you may have to adapt it a little, I am not sure.
Public Function SendEmail(ByVal oFrom As String, ByVal oTo As String, ByVal oSubject As String, ByVal oText As String, Optional ByVal oCC As String = "", Optional ByVal oBCC As String = "", Optional ByVal oPri As Integer = 0)<br />
Dim mailmsg As New System.Web.Mail.MailMessage<br />
With mailmsg<br />
.From = oFrom<br />
.To = oTo<br />
.Cc = oCC<br />
.Bcc = oBCC<br />
.Subject = oSubject<br />
.Body = oText<br />
.Priority = oPri<br />
End With<br />
System.Web.Mail.SmtpMail.SmtpServer = "TheNameOfYourSMTPServerHere"<br />
System.Web.Mail.SmtpMail.Send(mailmsg)<br />
End Function
Good luck with it,
Johan
|
|
|
|
|
System.Web.Mail.MailMessage ?
i don't think that's VB 6.0 meterial :P
for VB 6.0 try this (if above doesnt work)
1) add this reference to your project :
Microsoft CDO For Windows 2000 (XP,2000,2003)
2) add this at a startup to your code
Mail.Configuration.Fields.Item("smtpserver") = "smtp.yourserver.com"
Mail.Configuration.Fields.Item("smtpserverport") = 25
3) small example
Dim Mail As CDO.Message
Set Mail = New CDO.Message
Mail.From = "tester@test.com"
Mail.To = "test@test.com"
Mail.Subject = "Subject"
Mail.TextBody = "Hey .."
Mail.Send
|
|
|
|
|
hi
i have a no of text boxes in my form.i want to reset all text boxes by clicking the reset button. in my form..can anybody tell me how can i do it by using a loop(for..next..)nstead of doing textbox1.text="" for each one...??? i am using vb.net
thanks in advance
i m pradip kishore
|
|
|
|
|
dim c as Control
For Each c In Me.Controls
If TypeOf c is TextBox Then
c.Text = ""
End If
Next
Tarakeshwar Reddy
MCP, CCIE Q(R&S)
|
|
|
|
|
hi
thanks for your quick response..
i m pradip kishore
|
|
|
|
|
Add the following to your Reset Button click event and it should sort out your issue:
For Each Ctl As Control In Me.Controls<br />
If TypeOf Ctl Is TextBox Then Ctl.Text = String.Empty<br />
Next<br />
Regards,
Martin
|
|
|
|
|
hi
i am having a problem in crystal report.
in the combobox1,i have a list of table name.when i select one name ,then all the data in that table will be inserted into the report table and i ll map all those data to the crystal report.after the report is shown ,then the report table will be blanked..now the problem is that when ever i am accessng the crystal report 1st tme,i can view all the data in the selected table from the combobox1.but on subsequent access to crystal report i cant get the all records inserted(means i always get one record less than the actual value).the code i used is something like below:
Private Sub ButtonReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
da = New OleDb.OleDbDataAdapter("select * from " & ComboBox1.SelectedItem & "", cn)
ds.Clear()
ds.Reset()
da.Fill(ds)
Dim i As Integer
For i = 0 To ds.Tables(0).Rows.Count - 1
Try
cm = New OleDb.OleDbCommand("insert into report values ( '" & ds.Tables(0).Rows(i)(0) & "','" & ds.Tables(0).Rows(i)(1) & "','" & ds.Tables(0).Rows(i)(2) & "','" & ds.Tables(0).Rows(i)(3) & "','" & ds.Tables(0).Rows(i)(4) & "','" & ds.Tables(0).Rows(i)(5) & "' )", cn)
cm.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.Message)
End Try
Next
Dim frm As New LedgerShow()
frm.CrystalReportViewer1.ReportSource = "E:\Accounts_swt\Accounts\Ledger.rpt"
frm.Update()
frm.Show()
'frm.Update()
frm.Refresh()
ds.Clear()
ds.Reset()
Try
cm = New OleDb.OleDbCommand("delete from report", cn)
cm.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
thanks in advance..
its urgernt please..
i m pradip kishore
|
|
|
|
|
Why not simply pass report parameters with the values you need to the report?
Have the datasouce of the report be a view or stored proc.
JaDaar
"I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones."
Einstein
|
|
|
|
|
hi
thanks for your response.can you show me a code snippet or any link thrugh which i can fulfill my objective
i m pradip kishore from india,working in vb.net & asp.net
|
|
|
|
|
hi
am using vb.net and ms access as database
please try to give a solution for it
pradip kishore
|
|
|
|
|
hello everybody... merry christmas to all of you...
can anyone help me, where to get a third party control for vb.net2005?....
Thank you and Merry Xmas...
nothing is impossible.....
|
|
|
|
|
momooomooomomo wrote: can anyone help me, where to get a third party control for vb.net2005?
What kind of control are you looking for? Try a google search and see what comes up
Merry Christmas to you too 
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
a 3d button if there is.. or 3d tab controls... do u have some links that could help me ease on searching from the net?... thank you once again and merry xmas..
nothing is impossible.....
|
|
|
|
|
Google[^]
Just search for ".net windows forms controls" or you can try "Infragistics" or "Dundas", or any other manufacturer that you come acrossed, probably in the ads around CodeProject.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
thank you sir... and may you have a very special christmas.....
nothing is impossible.....
|
|
|
|
|
Hi,
I need to link my MS Access database to my vb.net program.
All im looking to do is simply get the user to click a button and by doing so, displaying whats in the MS Access Database.
sounds simple, but I haven't got a clue how to do this, am also struggling to find a tutorial that will teach me how.
I would think its simple as they are both Microsoft products.
Thanks in advance
Jaidev
|
|
|
|
|
There's no such thing as "linking" an Access database, or any other for that matter, you your VB.NET app.
Your VB.NET app can use the database and make queries against it. In order to get the tables, field names, and types in that database, you'll have to query the schema of the database. But, before doing that, I'd suggest learning the basics before getting into something more complicated like this.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
well you're right about it being easy
if you also happen to have the latest MSDN (free for the express editions)
you'll find great little tutorials there
anyways all you have to do, is follow the wizard in adding a new data source.
there you'll find options as to what kind of database you'll link to.
(choose from SQL Server, or MS Access database)
After that, it'll import the tables and views from the database.
Also it will ask you if you want to make a copy in your working directory or link it permanently
to the database.
(I suggest the first option which makes a new copy after each compile. Otherwise it;s not easy to distribute an application with it's database hardcoded into the application)
Now the easiest way, is to open your form in design view, and go to your data sources, and simply drag and drop the table you want.
have a look at the options then, and you'll quicly get the hang of it.
hope i could help
|
|
|
|
|
Hi,
Thanks for your reply. However were do I find the 'Adding a new data source' wizard?
Thanks in advance.
Jaidev
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
