|
|
Please help me in sending rdlc report as an email attachment.
Intelligence is measured by common sense not by how many scholarly books you read.
|
|
|
|
|
i made a project but when i run it i face the following error mentioned in bold text when trying to login.plz tell me how to resolve it.
Server Error in '/Courier' Application.
--------------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error:
Line 43: dsUsers = New DataSet
Line 44:
Line 45: Dataadapter.Fill(dsUsers, "users")
Line 46:
Line 47: If dsUsers.Tables(0).Rows.Count = 0 Then
here is the code of this page
Imports System.Configuration
Imports System.Data.SqlClient
Namespace Courier
Partial Class Login
Inherits System.Web.UI.Page
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<system.diagnostics.debuggerstepthrough()> Private Sub InitializeComponent()
End Sub
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Dim dsUsers As DataSet
Dim Dataadapter As SqlDataAdapter
Dim strConnection As String
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
strConnection = ConfigurationSettings.AppSettings("ConnectionString") (this line also gives error)
End Sub
Private Sub cmdLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdLogin.Click
Dim roleName As String
Dataadapter = New SqlDataAdapter("SELECT * FROM users where users_login='" + txtID.Text + "' AND users_password='" + txtPassword.Text + "'", strConnection)
dsUsers = New DataSet
Dataadapter.Fill(dsUsers, "users")
If dsUsers.Tables(0).Rows.Count = 0 Then
lblError.Visible = True
Else
lblError.Visible = False
roleName = dsUsers.Tables(0).Rows(0)("users_role")
Session.Add("loggedIn", roleName)
If roleName = "administrator" Then
Response.Redirect("officemain.aspx")
End If
If roleName = "branchadmin" Then
Response.Redirect("officemain.aspx")
End If
End If
End Sub
Private Sub cmdCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdCancel.Click
txtID.Text = ""
txtPassword.Text = ""
End Sub
End Class
End Namespace
|
|
|
|
|
I got this error in my application also
This error occurs due to many reasons one of it is your Windows FireWall is not allowing to connect remote server .
Off your and Server fire wall and check once again
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
maybe it the sqlserver2005 service is turned off
try to turn it on
regards
|
|
|
|
|
maybe it is the connectionstring it self did u change the server name and the datebase
or the sql is turned off
i had this error
|
|
|
|
|
how can i zip a folder which contain some files?
Thks
|
|
|
|
|
dont u have winZip o winrar?
|
|
|
|
|
i mean by .net code, with out any sw
|
|
|
|
|
|
|
|
Satips,
Even me too was bit *adamant* on sticking to it. But a few reviews show up negative on using the java.util.zip from VJSLib.dll because of
1) performance
2) zip errors
I think SharpZipLib is more good. It just needs one compiled binary to be shipped along with the assembly. http://www.icsharpcode.net/OpenSource/SharpZipLib/[^]
|
|
|
|
|
Hi All,
I am using HtmlControls to select file from local machine. A problem with this control is at a time we can select only single file from 'Choose file'
window.
Here we need multiple file selection option from 'Choose file' window
in my web application.
Please guide me how to implement this functionality.
Pravin
|
|
|
|
|
I think you can upload only one file at a time using that control
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Hi,
thanx for reply.
but i want to select multiple files and enqueue them into a list box. So what can i do for that...?
Pravin
|
|
|
|
|
Whats the problem of using Multiple Upload file controls ?
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
in web u can't
u see the attchment controls of all the mails (yahoo,hotmail,gmail)
on file at once
regards
|
|
|
|
|
hi,
thaxs for reply, but i want to just add the selected file names in the list box.
Pravin
|
|
|
|
|
You don't want to upload that files to server ?
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
yes i want to upload that files on the server, but i want to select the number of files, add these files in the list box and then upload that all files on the server.
Pravin
|
|
|
|
|
See When you select files from Upload file control that will be at client side after uploading only you will able to add those file name to list box
if you want to show list box before file uploads then you will have to write Javascript for that
Again i am saying Use multiple Upload file controls instead of one
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
ok, i will try for it.
Pravin
|
|
|
|
|
in the fileupload control the filename make a problem ....i had it once
maybe it because the path is on the client
all u can got the file bytes
regards
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)