|
well i manage to connect to it but it's alot of code, and
it looks like i set up another connection (apart from the one i'm activly using with
the .net components)
i have to declare oledb connection strings
connect to it (add the fact it's got security blah)
read it to a dataset
specify my sql command
execute the command into a new dataset
and then use datatables and datarows to access it
isn't there a simpler way ?
that what i'm looking for
(something in the lines of the new ado.net help thingys)
Ericos Georgiades
|
|
|
|
|
Trying using the datagrid control. After you follow the wizard setting up the connection you have the option of changing your query. You can also add additional queries with buttons to run the specific query.
|
|
|
|
|
"the specific query"
yeah i dont want to run pre-defined queries cause i cannot specify my criteria freely.
i want to return to a table all the rows of a table
given a selection of parameters
for instance, if a listbox shows me all the customers and i select 4 of them, i'd like to
have a table as datatable which has the rows of the sales table which match the 4 customers i chose.
with the wizard i can only predefine the criteria
anyways it doesnt seem as though there is a simpler way rather than writing the entire connection string
oh yeah and i know, i talk alot... :P
Ericos Georgiades
|
|
|
|
|
I want to read data from USB IR receving device.
|
|
|
|
|
Then it's probably exposed as a COM port (Serial port). You'll have to check with any documentation you got with the device or the machine. Google for "VB.NET Serial Port" and you'll come up with all kinds of stuff on it, that's IF it's exposed as a serial device.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Keep your posts in the same thread. Don't start a new thread just because you have something need to say about the old one.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Whay I dont have the "system.io.ports" class in vb.net?
-- modified at 2:38 Tuesday 19th December, 2006
|
|
|
|
|
agbaria ahmed wrote: Whay I dont have the "system.io.ports" class in vb.net?
Which version of .NET are you using.
System.IO.Ports is only supported in .NET 2.0 and .NET 3.0
|
|
|
|
|
|
Hi,
Can you Help me.
I am having one multiline textbox.i am selecting some content from word document and paste it in textbox.the data is being inserted into database when button is clicked.The problem is the data is not inserting along with html tags.
And when i retrive the data into datagrid the htmlformat is not there i.e without line breaks,spaces..etc...
vin1070
|
|
|
|
|
A textbox does not support formatting. Perhaps you should use a RichTextBox instead.
---
It's amazing to see how much work some people will go through just to avoid a little bit of work.
|
|
|
|
|
Thanks for quick reply
but there is limitation for me, i have to use only multiline textbox and if i am not wrong there is no Richtextbox in .Net webapplication and i dont want to buy any third party tool either.
regards,
vin1070.
|
|
|
|
|
Hi Friends,
Today, i required one small project which i need to submit on my univesity.i required souce code of the project also.
project in VB ok, Small c++ it's also okay... I want to submit this project but tommrrow onyl... this is my humble request you to pls so the needful..
I already submited project but, my they cancle for some resion. request you yo send me as soon as possible. i want to take printout hardcopy also..pls do the needful
RAHUL
|
|
|
|
|
I understand that its urgent but you failed to say what the project is and what it should do. We need to know this.
Posted by The ANZAC
|
|
|
|
|
No we don't. He needs to write it himself. He can come here and ask questions, but we're not going to write it for him just to save his butt.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave Kreskowiak wrote: ask questions, but we're not going to write it for him just to save his butt
Yep. If I were his teacher and found this thread, well.......
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
PaulC1972 wrote: Yep. If I were his teacher and found this thread, well.......
Ahh yes, the imagination abounds with retribution!
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
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
|
|
|
|