|
i have a pdf file to learn how to creat reports . if u need mail me at
onlymadni@gmail.com
|
|
|
|
|
I would like this pdf file if you dont mind. i will email and request it.
|
|
|
|
|
Dear Friends,
I have problem in opening SQL Server Database when i run the application it gives error
an unhandled exception of type system.data.sqlclient.sqlexception occured in system.data.dll
Additional information System Error
Please help me in solving this problem
your help will be highly appriciated.
my app.config contains string like below
<appsettings>
<add key="ConnectionString" value="server=(MURTUZA);database=NorthWind;uid=sa;pwd=sumayya">
Thanks
Murtuza
|
|
|
|
|
can u send the lines u written for connection? it may be query problem that u r trying to open
|
|
|
|
|
Dear Abbasi,
The connection string i m using is as below
<add key="ConnectionString" value="server=(MURTUZA);database=NorthWind;uid=sa;pwd=sumayya" />
when i am reaching at rs.open i m getting the error as i mention before.
rs is an instanse of my class called Recordset.
Rs has the below Open method
Public Sub Open()
cnn = New SqlConnection(mConnectionString)
cmd = cnn.CreateCommand()
conn.Open()
cmd.CommandText = "SELECT COUNT(*) FROM (" & mSelectString & ") tbl"
mRecordCount = cmd.ExecuteScalar
' Cursor declared with a SQL-92 syntax (BooksOnLine)
cmd.CommandText = "DECLARE crsr SCROLL CURSOR FOR " & mSelectString
cmd.ExecuteNonQuery()
cmd.CommandText = "OPEN crsr"
cmd.ExecuteNonQuery()
GetTableName()
mBOF = True
mEOF = (mRecordCount = 0) ' If there are not records: EOF=BOF=True
mAbsolutePosition = -1
End Sub
|
|
|
|
|
Thanks all Friend
My problem solved and its working fine
|
|
|
|
|
Did you use the
Imports System.Data.SqlClient
Imports System.Configuration
Namespaces????
|
|
|
|
|
no need ; it wouldn't have compiled if the namespaces weren't resolved...
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
add the crashinc code into a try catch block to have a more precise decription of the problem :
Try
...
Catch ex As Exception
MessageBox.Show("SQL error : " & ex.Message, _
"Error", _
MessageBoxButtons.OK, _
MessageBoxIcon.Error, _
MessageBoxDefaultButton.Button1)
End Try
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
I am installing my vb.net app on a client computer. I have included the merge modules with the project but i still get "load report failed" when i try and open my report. Does anyone know a solution to this or another free easy to use report writer i can use with .NET???
|
|
|
|
|
|
|
nevermind i found it. It works halfway. I do not get the error message anymore but my parameter prompt comes up, i enter the parameter, click OK and nothing happens. NO report shows. Help???
|
|
|
|
|
now it is asking me for my sql server logon information, how do i get rid of this???
|
|
|
|
|
enter database user name and password to logon
|
|
|
|
|
use RefreshReport property of crystal report viewer control.
|
|
|
|
|
i ve embedded a Windows Media Player component in the ASP.NET Web Application interface.. but dunno how to play a media(audio/video) file in it...
i ve tried giving a URL path to a Hyperlink, when this Hyperlink is clicked, another Windows Media Player pops up and plays that media file... but i want the embedded media player(on the interface) to play the file..
how to do this.. ??
and also how to go for dynamic URL path for the media files.. like when a user clicks on any file, its URL shud be invoked n played in the Embedded Windows Media Player(on interface)...
|
|
|
|
|
i want to make an applicaton ( in VB.NET) through which i can send mail
i also want to add option of "cc" and "bcc" and also of attaching files
is, there any method in vb.net to send mails
plz help me as i m new in this field.
a code will be very useful
|
|
|
|
|
yup.. it's fairly simple...
take a look at the documentation for System.Web.Mail
here's a c# example:
<br />
using System.Web.Mail;<br />
...<br />
SmtpMail.SmtpServer = "relayserveraddress";<br />
MailMessage msg = new MailMessage();<br />
msg.From = "from@youraddress.com";<br />
msg.To = "to@them.com";<br />
msg.bcc = "bcc@bcc.bcc";<br />
msg.cc = "cc@cc.cc";<br />
msg.Subject = "test message";<br />
msg.Body = "this is the body of your message<br>Formatted with HTML";<br />
msg.BodyFormat = MailFormat.html;<br />
<br />
SmtpMail.Send(msg);<br />
That's all there is to it. Your code has to have relay access to the smtp server.
Adam
// TODO: Write code.
|
|
|
|
|
Use the System.Web.Mail.MailMessage object. This is an example in C# of how to use it, but it should easily convert to VB.NET:
MailMessage mail = new System.Web.Mail.MailMessage();
mail.From = ***sender's email address***;
mail.To = ***reciever's email address;
mail.Subject = ***Subject***;
mail.Body= ***some message***;
System.Web.Mail.SmtpMail.SmtpServer = ***your email server***;
System.Web.Mail.SmtpMail.Send(mail);
You can .cc, .bcc, and .attachments, as well.
Hope this helps
|
|
|
|
|
Hi,
Is it possible usig the VS.net setup wizard to have files install to the c:\ root.
Thanks
|
|
|
|
|
Yes you can add a Custom Folder that points to C:\, but it is generally not a good idea to install files to the root drive folder.
Robert
|
|
|
|
|
First of all i wish to thank to this site....
I got a clear idea about Inserting relational data using DataSet and DataAdapter in SQL Server....
But the sample given here for MSAccess is not working, I cant create the Event Handler for solving the Autonumber column issue...
If anyone have the solution for this plz replay me....
Plz refere this address http://www.codeproject.com/cs/database/relationaladonet.asp
Thanks in Advance
With regards Hareesh
Hareesh A S
Systems Excecutive,
Trivandrum,
India.
|
|
|
|
|
Hi everybody,
I have a utility to which i have to add features. But before that I have to convert the application from VB 6 to VB.NET....any known resources where to get help from? Am getting a lot of errors after migration.
John
|
|
|
|
|
I haven't seen any. It's pretty much going down the error list and handling the cases by hand that the conversion tool couldn't handle on its own. Most of the time, you'll be rewriting entire sections of code to convert it to something compatible in .NET.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
