fotini

I wrote this line of code and it returns nothing. sb.Append(myReader.GetValue(0))

1.myMessage.Body = sb.ToString 2.no, and I'm wondering why... sniff...

I have an object DataTable but there is not a method Get XML I tried to append tha data myself to the document with StringBuilder.append but the mail that I recieve is empty! sb= New StringBuilder Dim myReader As SqlDataReader = command.ExecuteReader() While myReader.Read() sb.append=myReader.GetValue(0) sb.append="vbCrLf" End While

I know that with the following code in VB.NET you can send a mail Dim myMailServer As SmtpMail Dim myMessage As New MailMessage() myMessage.BodyFormat = MailFormat.Text myMessage.Priority = MailPriority.Normal myMessage.From = "xxx@apn-automation.com" myMessage.To = "yyy@yahoo.fr" 'To Address myMessage.Subject = msgSubject myMessage.Body = body myMessage.Attachments.Add(...) myMailServer.SmtpServer = "mySMTPserver" myMailServer.Send(myMessage) myMessage = Nothing What I want to do: retrieve data from a database (with a SELECT) and mail them. How? I can't attach them because there aren't in a file, I can't put it to message body because there are not a string. Please tell me the solution. (I want to mail a DataTable) P.S. I don't want to make them in a file

Thanks from me too! It's great!

I found the problem.... At the secyrity tab of the SQL Server, I chose Authentification: SQL and Windows (mixte).... I didn't know the properties of their SQL Server... I'm really sorry...

I gave user all permissions. The error I get is the same when I first ran the application on my machine, locally(web server, sql server, vs net all in my machine), and the solution came with the creation of an ASPNET account. But here, with the intranet... I don't know. With my Windows application Ididn't have problems, I was connected to the database and I took the data I wanted. With the same connection string Thanks anyway for the help and the interest

Authorization of SELECT is denied on the objet "Table1", database "Database1", owner dbo ???

yes

Server Error in abc Application Autorisation SELECT refusee sur l'objet "PERSONNEL", base de donnees "NetGestion", proprietaire dbo System.Data.SqlClient.SqlException

I wrote an ASP Application. I put the connection string you propose. I wanted to install this application in another machine X. This machine X hasn't VS .NET, SQL Server etc. I installed IIS, .NET Framework, MDAC 2.6, MDAC 2.7 SP1. I wanted my application installed on the machine X to communicate with a database of SQL Server of the machine Y. I created a user with access to this database. It doen't work Sorry but I'm a beginner... and the things are so difficult for me

I created the user APN with blank password and I gave him all rights, I use the following connectionstring but I take server error in application... <add key="SqlConnection1.ConnectionString" value="Network Library=DBMSSOCN;Data Source=APN-TC2110,1433;Initial Catalog=Netgestion;UserID=APN;Password=;Persist Security Info=false;Workstation ID=APN-e800;Connect Timeout=30" /> I'm so confused...

.NET Framework is not installed on the machine where SQL Server is so there is not an aspnet account...

That works, thanks. But in the following case?: I have a web server (IIS) and a SQL server 2000 and each of these live on a different box in our network. I want to let my asp.net app talk to my SQL server box.I f I understand, what I need to do for the separate boxes to talk, is set up a login on my SQL server database for the ASPNET account. Does my network admin have to create an account like this for me? What do they use for the password? An account by this name does not currently exist. The web server is running Win2K server and the SQL box is the Enterprise Edition runnning on WinXP pro.

I have an IIS server running on my WinXP. I also recently installed a SQL Server 2000 on my machine. Now here's the problem. ASP.NET pages work just fine on my machine if I'm not talking to my SQL Server Database. But when I do try to connect to my SQL Server 2000 I get an error: This is the String that I'm using to connect: SqlConnection sqlConn = new SqlConnection("server=BAQIR_MACHINE\\BAQIR_DB;" + "Integrated Security=SSPI;Initial Catalog=Baqir_Test_Data"); And this is the error that I get: Server Error in '/BaqirADO' Application. -------------------------------------------------------------------------------- Login failed for user 'BAQIR_MACHINE\ASPNET'. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'BAQIR_MACHINE\ASPNET' (By the way, I checked and I do have an ASPNET account on my machine) (Pointing to this line of code) sqlConn.Open(); ------------------------------------------------------------------------------------------------------------------- I then tried to connect with this line: SqlConnection sqlConn = new SqlConnection ("server=localhost;database=Baqir_Test_Data;uid=sa;pwd=;"); And this is the error that I get: Server Error in '/BaqirADO' Application. -------------------------------------------------------------------------------- Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. Can someone help me out here. Am I doing something wrong here, or do I have to configure some setting in my computer. Thanks In Advance

Hi, While I succesfully created a setup project for a windows application which I have already installed and it is running without problems, I can't do the same thing with a Web Application. I create the web setup project ( add--> project output--> primary output and content files) but when I run the setup.exe at the target machine: I can't select the location of the installation It installs the project on the disk E et not at the disk C where I want (that happens with the windows application) On the disk E there are only data On the disk C I have the IIS, dotnetfx, MDAC 2.6, MDAC 2.7 SP1 When I'm trying to request the page(http://localhost/WebApplicationX/WebFormY.aspx...) it gives me an error that it can't find the page requested. Please help me because these things make the life of a beginner more difficult .

Thank you Robby!

Windows XP do not grant write permission to the folders to the ASPNET account (or Network Service account)? I'm working in XP, I'm writing an ASP .NET Web Application and I can't write in a file! What I can do? Please help! I wanted to create a chart, to save it in a file and then bind it as the url of an image... Thanks a beginner

How can I change the text of the labels of the WebFormX with code of the WebFormY? We are on the formY, the user gives the data for the texts of the labels of the formX. Thanks

How can I change the ForeColor of a button when the mouse passes over this button?

I want to create a chart from an Excel File Problem: I use the following code: Dim oSeries As Excel.Series oSeries.XValues = oSheet.Range("A2", "A17") to define the values of the Axis X but, whereas these cells contain datetime values, on the created chart, on the axis x, I take simple numbers 1 2 3 4 5... Where am I wrong? Please help me.

Splice, everything is ok. I got through it! Many many thanks!!! Your work really helped me.

I have a problem: I don't take response from the COM port. I don't take OK or ERROR but only "Error occurred Read Timeout. data fetched: " when I click on Rx button.Why?Please help me again!!!!

What about : 'an example With oSheet.Range("A1", "D1") .Font.Bold = True .VerticalAlignment = Excel.XlVAlign.xlVAlignCenter End With oRange = oSheet.Range(("A2", "D2") oRange.Orientation = 38 oRange.WrapText = True oRange.Interior.ColorIndex = 36 With oRange.Borders(Excel.XlBordersIndex.xlEdgeBottom) .LineStyle = Excel.XlLineStyle.xlDouble .Weight = Excel.XlBorderWeight.xlThick End With 'etc....

Hello, I'm trying to create an Excel chart ... I'm based on the "Create an Automation Client for Microsoft Excel" When I write the following code: oSeries.XValues = oSheet.Range("A7", "A22") nothing changes to the generated chart (same result when I leave out this line of code!) and I don't take the values of this column (A) to the axis X... Where is the error? I have 2 series so I tried the following: .SeriesCollection(1).XValues = oSheet.Range("A7", "A22") .SeriesCollection(2).XValues = oSheet.Range("A7", "A22") but I take this error: An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in microsoft.visualbasic.dll Additional information: Type mismatch. Please, can anybody help me? Note: I found that this error is a bug of MS but I didn't understand what I'm supossed to do to correct it... Thank you