Hi there! I installed the Sql Reporting Services under Vista Business. When i run de configuration tool, i have to select yhe machine name and instance name... then when i press connect this exception is thrown
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options) at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus() --- End of inner exception stack trace --- at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus() at ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration() at ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames itemName) at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus() at ReportServicesConfigUI.ConfigurationManager.ChangeMachine() at ReportServicesConfigUI.ConfigurationManager.LaunchDialog() at ReportServicesConfigUI.ConfigurationManager.tsbConnect_Click(Object sender, EventArgs e) at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ToolStrip.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Can anyone help me with this. it's Urgent Thanks Rui Fernandes
I have been using Sql server Reporting services 2000 and i never had these problems I tried firing up my Sql server Reporting services 2005 today i went through the reporting services conf manager and then got to the "database setup" stage and bingo can't get through this error below
* On my PC i have Reporting services 2000 and Reporting services 2005 installed and my
is working ok
ReportServicesConfigUI.WMIProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.
---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3) --- End of inner exception stack trace --- at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
Looked for some info and got a hint here at: http://blogs.msdn.com/bimusings/archive/2005/08/23/455263.aspx
But still can't get it to fox it.. Also with the Encription Keys i anytine i try to delete it BINGO again i get the error above.. These error has been given people nigtmares and it isn't new does anyone know the fix for this error.. Hope someone from Microsoft could help
When I try to access the http://server/reportserver page I got the folowing error:
"The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError)"
So I wento to the Reporting Services Configuration tool, and there is a "X" on Initialization. When I try to initialize the instance I got this error:
"ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)"
I tried many ways to correct this, the only thing i did not do was delete the encription key. What happens if I delete it? I also read in some foruns that if I delete it I will have to reconfigure all the connection and recreate the encripted content. How can I do this? Should I do this?
Platform : SQL Server Express SP2 with advanced services
I have an install script that installs all of the services and features with the exception of management studio express. My install script is very basic, the only addition was to have RSSQLOCAL=1, and I set RSCONFIGURATION=Default.
After the installation, when I navigate to localhostReports$SQLEXPRESS or localhostReportServer$SQLEXPRESS, I get an authentication error. When I go into the reporting services configuration manager, everything looks OK, but the 'Initialized' status is 'NO' under status. If I go to 'Database Setup', choose Connect, and then 'Apply', the reporting services now becomes initialized, and everything seems to be OK.
What is the reason for this manual step in the reporting configuration manager? Any ideas?
Hi Experts, I am getting this error and error message is Error: The report Server installation is not initialized. Check the documentation for more info (rsReportServerNotActivated), The RPC server is not listening.
Can any one give me some idea how to over come the situation.
I've installed SQL Express 2005 on an XP Professional machine and I'm trying to configure Report Services. In Reporting Services Configuration Manager, all items are "green" except "Web Service Identity". The value is <machinename>ASPNET and isn't configurable. I've searched the forums and followed the advice I've found to remove and reinstall .NET, but it hasn't helped. User ASPNET does exist on the machine with a local account, and IIS5 is running. SQL gurus, please help me figure out what to do! Thanks.
I am trying to build a SQL Server 2000 (sp3) admin app in VB.NET that gives the users targeted access to EM functions without having to search through EM. At any rate, I cannot seem to re-initialize the SQL namespace, even after setting it to nothing (I want to enable a user to do work with one server, pop into another, etc). Here is a sample of what I am doing, stripped to its essentials. This code fails with the error in the subject line. Thanks in advance.
I'm a bit confused right now. I am using Sql 2005 merge replication. I have a publisher and a subscriber running. Today, I updated some data in my publisher which caused 300,000 updates to be sent to the subscriber. There was no problem here, it took a while though. Later, I added a new subscriber and when it started initializing I suddenly thought that I should have really created a new snapshot, one that included the 300,000 row update. Because I didn't I was epecting that once the subscription had finished initializing from the old snapshot it would then have to apply the 300,000 row update. But it didn't seem to do this last update! But yet all the data was correct!!
Does Sql replication somehow merge the snapshot with pending updates when it creates a new subscription?
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
In short, I have a couple grid views on a page that are used for editing as well as sorting, etc. The grids are setup to use the SqlDataSources. I'm trying to deploy this to a server environment for different instances (test,cert,prod) and am trying to set the ConnectionString for the SqlDataSource in the code behind (Page_Load()). Everything works well, except, I get an error message that says the "ConnectionString Property Has Not Been Initialized." Its a javascript alert coming up on top of the grid view. Here is how I'm trying to set the ConnString in the Page_Load():this.EmployeeTimeCardDataSource.ConnectionString = ConfigurationManager.ConnectionStrings[connStr].ConnectionString; Here is an example of the DataSource.<asp:SqlDataSource ID="EmployeeTimeCardDataSource" runat="server" SelectCommand="sp_Select_Managers_Employees_List" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:SessionParameter Name="CurrentUser" SessionField="User" Type="String" /> </SelectParameters></asp:SqlDataSource>
I am getting an error message that says that my connection string has not been intialized I have initialized it. Dim AirliquidiConn As New SqlClient.SqlConnection(ConfigurationManager.AppSettings("AirliquidiDatabase")) Any suggestions??
Hi all This is the code in my web.config file. <appSettings> <add key="ConnectionString" value="server=127.0.0.1;database=testdb;uid=sa;pwd=sa"/> </appSettings> When I'm connecting to the sqlserver database,the page shows that The ConnectionString property has not been initialized. The code that I used to get the "ConnectionString" as belows using System.Configuration; protected static string connectionString =ConfigurationSettings.AppSettings["ConnectionString"]; public static object GetSingle(string SQLString,params SqlParameter[] cmdParms) { using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand()) { try { PrepareCommand(cmd, connection, null,SQLString, cmdParms); object obj = cmd.ExecuteScalar(); cmd.Parameters.Clear(); if((Object.Equals(obj,null))||(Object.Equals(obj,System.DBNull.Value))) { return null; } else { return obj; } } catch(System.Data.SqlClient.SqlException e) { throw new Exception(e.Message); } } } }
These code works well on my machine.When running on my colleague's machine ,the page show that exception. Any ideal?
I tried to insert my inputs into the database but it says "The ConnectionString property has not been initialized."
These are my codes: SubmitAssigment.aspx.vb Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim conn As SqlConnection Dim mycmd As SqlCommand Dim dr As SqlDataReader Dim str As String conn = New SqlConnection(Configuration.ConfigurationManager.AppSettings("ConnectionString")) conn.Open() str = "INSERT INTO [UploadInfo] ([StudentID], [Subject], [Assigment], [File], [Upload], [Time]) VALUES (@StudentID, @Subject, @Assigment, @File, @Upload , @Time )" mycmd = New SqlCommand(str, conn) mycmd.Parameters.Add("@StudentID", Data.SqlDbType.VarChar, 500).Value = User.Identity.Name mycmd.Parameters.Add("@Subject", Data.SqlDbType.VarChar, 500).Value = DropDownList1.SelectedValue mycmd.Parameters.Add("@Assigment", Data.SqlDbType.VarChar, 500).Value = DropDownList2.SelectedValue mycmd.Parameters.Add("@File", Data.SqlDbType.VarChar, 500).Value = File1.PostedFile.FileName mycmd.Parameters.Add("@Upload", Data.SqlDbType.VarChar, 500).Value = "Yes" mycmd.Parameters.Add("@Time", Data.SqlDbType.VarChar, 500).Value = System.DateTime.Now dr = mycmd.ExecuteReader() mycmd.Dispose() dr.Close() End Sub
My IT dept set up an SQL db on a server for me and I am connected to it through a port. They told me I had to create my tables through an MS Access adp, which I have done. I am using VWD Express and am trying to create a login page using usernames and pw's from a db table. I am connected (at least the db Explorer tab shows I am) to the MS Access adp and can drop a GridView from my Employees table from it onto a page and get results. I keep getting the "ConnectionString property not initialized" error message pointing to my sqlConn.Open() statement and cannot figure out why. I have looked at hundreds of posts but can't seem to find anything that works. If someone could point me to some post or website that could explain connecting to a SQL db through a port or whatever you think I need to learn to get this fixed I would appreciate it. Web config: <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <appSettings/> <connectionStrings> <add name="ASPNETDB" connectionString="Description=Training;DRIVER=SQL Server;SERVER=USAWVAS27;UID=usx14611;APP=Microsoft® Visual Studio® 2005;WSID=983QD21;Network=DBMSSOCN;Address=USAWVAS27,3180;Trusted_Connection=Yes" providerName="System.Data.Odbc" /> </connectionStrings>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server">
Protected Sub LoginUser(ByVal s As Object, ByVal e As EventArgs) Dim blnAuthenticate As Boolean = Authenticate(username.Text, password.Text) If blnAuthenticate Then FormsAuthentication.RedirectFromLoginPage(username.Text, False) End If End Sub Function Authenticate(ByVal strUsername As String, ByVal strPassword As String) As Boolean
Dim strConnection As String = ConfigurationManager.AppSettings("ASPNETDB") Tried this code as wellDim sqlConn As New SqlConnection(ConfigurationManager.AppSettings("ASPNETDB")) Dim sqlConn As New SqlConnection(strConnection)
Dim sqlCmd As SqlCommand Dim sqlDR As SqlDataReader Dim userFound As Boolean sqlCmd = New SqlCommand("SELECT * FROM Employees " & _ "WHERE username='" & strUsername & " ' AND password='" & strPassword & "'", sqlConn)
I have installed SQL Server 2005 Express Edition.I have defined the connectionstring in my web.config as follows: <connectionStrings><add name="MyDB" connectionString="Server=local;Provider=SQLOLEDB;Initial Catalog=Shop;Trusted_Connection=Yes;DataSource==.SQLExpress;AttachDBFilename=Data/MyDB.mdf" providerName="System.Data.SqlClient"/></connectionStrings>Here's my vb code: Dim connStr As String = ConfigurationManager.ConnectionStrings("MyDB").ToString()Dim DBConnection As New SqlConnectionDim SQLCmd As New SqlCommand("SELECT * FROM tblMember WHERE UserName=@UserName", DBConnection)SQLCmd.Parameters.Add(New SqlParameter("@UserName", tbUserName.Text))DBConnection.Open()and on that last line I receive the error: The ConnectionString property has not been initializedNow, I have seen SO many different versions of a connectionstring that im totally confused!!I want to use windows authentication (I know thats better for security reasons).But I have difficulties understanding the attributes required (AND THEIR MEANING!) of the connectionstring. (e.g. do I need to define DataSource or Initial Catalog or AttachDBFileName and the rest? What does it do exactely?)Also: I have registered my server as "MyServer" is that the alias I need/can use in my connectionstring?If someone could explain me the above questions it would be of GREAT help!!
Hi, I'm trying to do a database operation in ASP.NET page using the following code: string connString = "SERVER=localhost;DATABASE=chbr;UID=sa;PWD=password;Connection Timeout=120";SqlConnection sqlConn = new SqlConnection(connString);sqlConn.Open(); string commandStr = "..."; SqlCommand command = new SqlCommand(commandStr); command.ExecuteNonQuery();sqlConn.Close(); But I kept getting the exception saying "ExecuteNonQuery: Connection property has not been initialized." What did I do wrong? Thanks!
Hello, I have just begun my first web application in vs 2005. I have a done a bit of coding in VS 2003. I have some list boxes on the page that use an ObjectDatasource that I set up with the wizard--and they work well and connect to SQL server. But I wanted to re use some of my old code for another list box on the page and put code in myself. Dim MyConnection As SqlConnection = New SqlConnection(ConfigurationManager.AppSettings("CONN_DATAConv")) Dim ProcConnection As SqlConnection = New SqlConnection(ConfigurationManager.AppSettings("CONN_DATAConv")) Dim myCommand As New SqlCommand(CommandText, MyConnection) MyConnection.Open() ProcConnection.Open() Here is what is in the web.config <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <appSettings/> <connectionStrings> <add name="DataConvConnectionString_gisad" connectionString="Data Source=PWDGIS4;Initial Catalog=DataConv;Persist Security Info=True;User ID=gisad;Password=erv11new" providerName="System.Data.SqlClient" />
<add name="CONN_DATAConv" connectionString="Data Source=PWDGIS4;Initial Catalog=DataConv;Persist Security Info=True;User ID=gisad;Password=erv11new" providerName="System.Data.SqlClient" /> </connectionStrings> Please note that I canged the connection string call from ConfigurationSettingsAppSettings that was in vs 2003 But the connections won't open. Any help would be greatly appreciated.
Dear all, I'm using ASP.net 2003, I need to display some of the messages that retrieve from a table in my sql server 2k. When I run the program, it works fine, but all of the messages that are supposed to get from the db table were not show. Below is my connection string in web config : <add key="dbconn" value="data source=localhost;initial catalog=MyWeb;Min Pool Size=3;Max Pool Size=20;Pooling=true;password=mypassword;persist security info=True;user id=sa;workstation id=local" /> Any help will be greatly appreciated
Dear all, I'm using ASP.net 2003, I need to display some of the messages that retrieve from a table in my sql server 2k. When I run the program, it works fine, but all of the messages that are supposed to get from the db table were not show. Below is my connection string in web config : <add key="dbconn" value="data source=localhost;initial catalog=MyWeb;Min Pool Size=3;Max Pool Size=20;Pooling=true;password=mypassword;persist security info=True;user id=sa;workstation id=local" /> Any help will be greatly appreciated
Hi , Iam new to vs2005. Iam trying to integrate Authorize.net for transactions in my site. When i tested it worked fine .But when i put it in live for Amex cards it is giving me sqlerror. Here is my code using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Net; using System.IO; public partial class Paymentprocessing : System.Web.UI.Page {SqlConnection objConn = new SqlConnection(ConfigurationManager.AppSettings["strConn"]); string permLevel = "";protected void Page_Load(object sender, EventArgs e) {if (Session["displayname"] == null || Session["franchiseid"] == null || Session["username"] == null) {Response.Redirect("Default.aspx"); } else {lblusrname.Text = Session["displayname"].ToString(); }string strSelectquery = ""; strSelectquery = "select userPermissionLevel,Franchise_ID from tblUsers where User_Name='" + Session["username"].ToString()+"'";SqlCommand objCmd = new SqlCommand(strSelectquery, objConn);SqlDataReader objDr; objConn.Open(); objDr = objCmd.ExecuteReader(); if (objDr.Read()) { permLevel = objDr[0].ToString(); } objDr.Close(); objConn.Close();if (int.Parse(permLevel) == 99) {pnlRefundCC.Visible = true; pnlRefundCA.Visible = true;pnlTransact.Visible = true; pnlPaymentInfo.Visible = true;pnlCardifo.Visible = true; } else {pnlPaymentInfo.Visible = true; pnlCardifo.Visible = true;pnlRefundCC.Visible = false; pnlRefundCA.Visible = false;pnlTransact.Visible = false; } }protected void RadioButton3_CheckedChanged(object sender, EventArgs e) {pnlTransact.Visible = false; pnlPaymentCCA.Visible = false;pnlOrgTransID.Visible = true;pnlCardifo.Visible = true;
Here is the error iam getting server Error in '/' Application. ----------------ExecuteNonQuery: CommandText property has not been initialized 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.InvalidOperationException: ExecuteNonQuery: CommandText property has not been initializedSource Error: Line 431: SqlCommand cmd1 = new SqlCommand(strInsert,objConn);Line 432: objConn.Open();Line 433: cmd1.ExecuteNonQuery();Line 434: objConn.Close();Line 435: Source File: d:Websitesserviceinfo.comsecurePaymentprocessing.aspx.cs Line: 433 Stack Trace: [InvalidOperationException: ExecuteNonQuery: CommandText property hasnot been initialized] System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +873524 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +72 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 Paymentprocessing.btnSubmit_Click(Object sender, EventArgs e) in d:Websitesxyassss.aspx.cs:433 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 ----------------Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
Hello, I try to execute the following SP in my class below. But get a runtime error saying "the connection string property has not been initialized" line 11 I have set permissions on the SP to public/execute What is wrong here. My connection string also is below thanks Ehi
1 public class signup_data_entry 2 { 3 public signup_data_entry() 4 { 5 SqlConnection con = new SqlConnection("cellulant_ConnectionString"); 6 7 8 SqlCommand command = new SqlCommand("Cellulant_Users_registration", con); 9 command.CommandType = CommandType.StoredProcedure; 10 11 con.Open();
Hello, am trying to run a SP in my class against my database. However, I get the error below. The connection string is in the web.config file as thus <connectionStrings> <add name="cell_ConnectionString" connectionString="Data Source=xxx.xxx.xxx.xxx,2433;Network Library=DBMSSOCN;Initial Catalog=day;User ID=day;Password=jdhje5rhydgd;" providerName="System.Data.SqlClient"/> </connectionStrings> and the connection string name is called in my class as thus 1 SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["cell_ConnectionString"]); 2 3 SqlCommand command = new SqlCommand("cell_ConnectionString", con); 4 command.CommandType = CommandType.StoredProcedure; 5
What is wrong here ? thanks Ehi
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.InvalidOperationException: The ConnectionString property has not been initialized.Source Error:
Line 49: command.CommandType = CommandType.StoredProcedure; Line 50: Line 51: con.Open(); Line 52: Line 53: command.Parameters.Add(new SqlParameter("@csv", SqlDbType.VarChar, 8000, "recipients")); Source File: c:inetpubwwwrootizevwwwrootwelcomesms.aspx.cs Line: 51
I'm writing my first vb.net app. Have a default page that uses a persons network login to query a database to get all their timekeeper id, firstname, last name, etc. But I keep getting this error. (My code is below) What am I missing??? ExecuteReader: Connection property has not been initialized. 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.InvalidOperationException: ExecuteReader: Connection property has not been initialized.Source Error:
Line 21: conn.Open() Line 22: Line 23: reader = comm.ExecuteReader() Line 24: If reader.Read() Then Line 25: EmployeesLabel.Text = reader.Item("tkinit") <script runat="server">Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)Dim conn As SqlConnectionDim comm As SqlCommandDim reader As SqlDataReaderDim connectionString As String = ConfigurationManager.ConnectionStrings("xxxConnectionString").ConnectionStringcomm = New SqlCommand("Select top 1 tkinit, tklast, tkfirst +' '+ tklast as fullname from txxx WHERE login = @login)", conn)comm.Parameters.Add("@Login", Data.SqlDbType.VarChar)comm.Parameters("@Login").Value = Me.User.Identity.Name.Substring(User.Identity.Name.IndexOf("") + 1)conn = New SqlConnection(connectionString)conn.Open()reader = comm.ExecuteReader()If reader.Read() ThenEmployeesLabel.Text = reader.Item("tkinit")FirstLastName.Text = reader.Item("fullname")End Ifreader.Close()conn.Close()End Sub</script>
Hi, I wrote the code below to store images on SQL Server 2005; however, I keep getting this error: The connection String property has not been initialized! My Connection String is stored in the web.config and am using ASP.NET 3.5. 1 using System; 2 using System.Configuration; 3 using System.Data; 4 using System.Web; 5 using System.Web.UI; 6 using System.Web.UI.HtmlControls; 7 using System.Web.UI.WebControls; 8 using System.IO; 9 using System.Data.SqlClient; 10 using System.Web.SessionState; 11 12 public partial class CarImage : System.Web.UI.Page 13 { 14 protected void Page_Load(object sender, EventArgs e) 15 { 16 } 17 18 protected void UploadButton_Click(object sender, EventArgs e) 19 { 20 if (Page.IsValid) 21 { 22 Stream imgStream = UploadImage.PostedFile.InputStream; 23 int imgLen = UploadImage.PostedFile.ContentLength; 24 25 byte[] imgBinaryData = new byte[imgLen]; 26 int n = imgStream.Read(imgBinaryData, 0, imgLen); 27 28 String StrCarID = Request.QueryString["CarID"]; 29 int CarID = System.Convert.ToInt32(StrCarID); 30 31 int RowsAffected = SaveToDB(imgBinaryData, CarID); 32 if (RowsAffected > 0) 33 { 34 Response.Write("<BR>The Image was saved"); 35 } 36 else 37 { 38 Response.Write("<BR>An error occurred uploading the image"); 39 } 40 } 41 } 42 43 private int SaveToDB(byte[] imgBin, int carID) 44 { 45 //Store Conn String in Web.Config 46 SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["LocalSqlServer"]); 47 SqlCommand command = new SqlCommand("INSERT INTO tblImage (CarID, Image) Values (@carID, @imgBin)", connection); 48 49 SqlParameter param0 = new SqlParameter("@imgBin", SqlDbType.Image); 50 param0.Value = imgBin; 51 command.Parameters.Add(param0); 52 53 SqlParameter param1 = new SqlParameter("@carID", SqlDbType.Int, 4); 54 param1.Value = carID; 55 command.Parameters.Add(param1); 56 57 connection.Open(); 58 int numRowsAffected = command.ExecuteNonQuery(); 59 connection.Close(); 60 61 return numRowsAffected; 62 } 63 } Any help will be very much appreciated.E
I am trying to create a web form that will be used to create new users. The first step that I am taking is creating a web form that can check the username against a database to see if it already exists. I would it to do this on the fly, if possible. When I execute my current code, I get the following error:
ExecuteNonQuery: Connection property has not been initialized
Below is the code from the page itself: ----- <!-- #INCLUDE FILE="../include/context.inc" --> <!-- #INCLUDE FILE="../include/db_access.inc" -->
<script language="VB" runat="server">
Sub CheckButton_Click(Sender as Object, e as EventArgs)
cmd.ExecuteNonQuery() result = cmd.Parameters("result").Value
If result <> 1 Then CheckResults.Text="<font color=""#ff0000"">Username already exists!</font>" Else CheckResults.Text="<font color=""#009900"">Username is available.</font>" End If
Can anyone see why I might get this error? Here are some more details of the error:
Line 15: cmd.Parameters.Add( "@userName", OdbcType.VarChar, 100 ).Value = Request.Form("userName") Line 16: *Line 17: cmd.ExecuteNonQuery() Line 18: result = cmd.Parameters("result").Value
I have a web form that is generating an error and I can't seem to figure out why for the life of me. Below is the code:
Private Sub VerifyNoDuplicateEmail() Dim conn As SqlConnection Dim sql As String Dim cmd As SqlCommand Dim id As Guid sql = "Select UserID from SDCUsers where email='{0}'" sql = String.Format(sql, txtEmail.Text) cmd = New SqlCommand(sql, conn) conn = New SqlConnection(ConfigurationSettings.AppSettings("cnSDCADC.ConnectionString")) conn.Open() Try 'The first this we need to do here is query the database and verify 'that no one has registed with this particular e-mail address id = cmd.ExecuteScalar() Response.Write(id.ToString & "<BR>") Catch Response.Write(sql & "<BR>") Response.Write("An error has occurred: " & Err.Description) Finally If Not id.ToString Is Nothing Then 'The e-mail address is already registered. Response.Write("Your e-mail address has already been registered with this site.<BR>") conn.Close() _NoDuplicates = False Else 'It's safe to add the user to the database conn.Close() _NoDuplicates = True End If End Try End Sub
Web.Config <appSettings> <!-- User application and configured property settings go here.--> <!-- Example: <add key="settingName" value="settingValue"/> --> <add key="cnSDCADC.ConnectionString" value="workstation id=STEPHEN;packet size=4096;integrated security=SSPI;data source=SDCADC;persist security info=False;initial catalog=sdc" /> </appSettings>
I'm struggling with the different methodologies for using DataSets in 2.0. I can knock this out in no time flat in 1.0, but am bogged down in 2.0. Can anyone guide me on the right track? My code is below. I'm forming a DataSet from a SQL Server Express database from the user's choice from a drop down. My connection string "ASOCTCOConnectionString" is declared in my web.config and used successfully throughout in the WYSIWYG configurations of my databound controls. But I want to control this in code. This si getting frustrating and right now I'm longing for the clean simplicity I had with Web Matrix :( In any case, any suggestions? It crashes with this error when opening the connection with MyConn.Open(). I just want to be able to configure a DataSet and apply it to my controls and results. <code> Dim connectionString As String = System.Configuration.ConfigurationManager.AppSettings("ASOCTCOConnectionString") Dim MyConn As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim MyQuery, SearchString As String
Dim myAdapter As New System.Data.SqlClient.SqlDataAdapter Dim myDataSet As New System.Data.DataSet Dim mySelectCommand As New System.Data.SqlClient.SqlCommand mySelectCommand.CommandText = "SELECT * from Device_Type where Category LIKE " & DDLDevType.SelectedItem.Text mySelectCommand.Connection = MyConn MyConn.Open() Grid1.DataSource = myDataSet Grid1.Databind() MyConn.Close() </code>