I am useing sql and vwd.
i created the db on sql and used database explorer to connect it to vwd.
it keeps failing at step 5 (con.open())
i think i listed all relevant code, but if i missed something let me know and ill post it.
what am i missing.
[code]....
I am making a login page in asp.net. when am trying to fill the data into the database it can give the error..."Incorrect syntax near 'Password'." my code is
SqlConnection sqlConnection = new SqlConnection("Data Source = DELLVOSTRO; Initial Catalog = ALPHA; User Id= sa; Password= intransit");
string queryString = ("INSERT INTO LOGIN(User_Id, Password, Confirm Password, E_Mail, Security_Question, Security_Answer) VALUES ('" + CreateUserWizard1.UserName + "','" + CreateUserWizard1.Password + "','" + CreateUserWizard1.ConfirmPassword + "','"
+ CreateUserWizard1.RequireEmail + "','" + CreateUserWizard1.Question + "','" + CreateUserWizard1.Answer + "')");
sqlConnection.Open();
SqlCommand cmd = new SqlCommand(queryString, sqlConnection);
cmd.ExecuteNonQuery();
When i fill my sql adapter daAuthors.Fill(dsPubs, "MYTable") sometime i get A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dllmy code can run for a lot hours without any problems but sometime i get the message
View 1 Repliescmd.Connection = con;
con.Open();
cmd.CommandText = "Update tiit.Enquiry Set Status='" + DropDownList4.SelectedValue + "', NextFollowup='" + TextBox8.Text + "', Remarks='" + TextBox9.Text + "', Name='" + TextBox1.Text + "', Email='" + TextBox2.Text + "', Phone='" + TextBox3.Text + "','','','','', City='" + TextBox4.Text + "', Country='" + TextBox5.Text + "', Course='" + TextBox6.Text + "', Comments='" + TextBox7.Text + "', Cost='" +TextBox14.Text+ "' where SN='" + HiddenField1.Value + "'";
int i = cmd.ExecuteNonQuery();
con.Close();
I'm having a spot of bother deploying my database to my host using the Publishing Wizard. I'm using the .sql file generated along with RunSQL.aspx as discussed in this blog by Scott Guthrie.
The issue I am having is that the permission is set to dbo but this seems to be causing an issue with the hosted database as in I get the following error when I run RunSQL.aspx.
An error occured: System.Data.SqlClient.SqlException: Cannot find the user 'dbo', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.runsql_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in d:~hosting details removed for security~RunSQL.aspx:line 88
Is there any way to make the Publishing Wizard set the owner to a particular username, i.e the username I use to access the hosted database.
I am getting this error message
System.Data.SqlClient.SqlException: Invalid object name 'Members'.
The database name is ACEStaff
I copied it accross from my old server to my new one
The table name in the database is Acestaffrm.members. Is the Acestaff prefix giving me this problem. I notice other table have dbo. prefix
[Code]....
View 5 RepliesI did executed a db - contact form page successfully in the same project with the same connection string, but for this page its doing error and so I commented the binary file saving codes and all and put just simple 2 fields to see if the db is connecting and surprisingly getting sqlexception error and no data is written to the db. I am using sqlexpress 2005 and VS 2008. After this code I am listing the error I got.
Imports System.Data.SqlClient
Imports System.IO.FileInfo
Imports System.Data
Partial Class picture2
Inherits System.Web.UI.Page
Protected Sub upButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles upButton.Click
'' SOME CODES ARE HERE
Dim ctr As Integer = 0
Dim fleName As String
Dim fleLength As Integer
fleName = FileUpload1.FileName
fleLength = FileUpload1.PostedFile.ContentLength
Dim fleDatasource As New SqlDataSource
fleDatasource.ConnectionString = ConfigurationManager.ConnectionStrings("CandidatesConnectionString").ToString()
fleDatasource.InsertCommandType = SqlDataSourceCommandType.Text
fleDatasource.InsertCommand = "INSERT INTO Picture (picLength,picName) values (&picLength, &picName)"
fleDatasource.InsertParameters.Add("picLength", fleLength)
fleDatasource.InsertParameters.Add("picName", fleName)
fleDatasource.Insert()
----------------------- executed and now the prg returns to my code with the following sqlexception error box and while expanded I got this info ------------------------
message - Incorrect syntax near "&"
Line number 1
Errorcode -2146232060
in order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. fleDatasource.Insert() the prg stops in the code with the green highlight on the fleDatasource.Insert().
I get and error when I run a sub select statement. What is wrong with the statement?
[Code]....
[Code]....
ERROR:
System.Data.SqlClient.SqlException: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
When the Stored procedure is executed through SQL Server Management Studio, its taking 23 seconds,When the same Stored proc is called through web app, its throwing below copied exception. It is noticed that when the data is more than 100k records this exception is thrown other wise expected records are shown in UI. Another stored proc from the same app returns over 150k records without any excetpion. Can't conclude that the exception is in Stored proc, because it works from SQL Server Management studio, but throws below exception from Web app.
[Code]....
I am facing the following problem when i try to add record in database. "System.Data.SqlClient.SqlException: A severe error occurred on the current command.The results, if any, should be discarded." This exception occurs occasionally, and the sql server log shows the following error whenever the above exception occurs:
Server,Unknown,A user request from the session with SPID 54 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
[Code]....
View 1 RepliesI have a website having an aunthentication system. When I am setting my website on IIS 6 the code is absolutly working fine. But when i configure the website on IIS 7 (Windows 2008 server) it is showing me the above error. I am using a stored procedure for it
View 3 Repliesi am trying to create an insertion form in ASP.net.but i get this exception and i could not find this with google.
<div id = "survey_div">
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:surveyConnectionString1 %>"
DeleteCommand="DELETE FROM survey"
InsertCommand="INSERT INTO survey(age, country, city) VALUES (,,)"
SelectCommand="SELECT FROM survey" UpdateCommand="UPDATE survey SET">
</asp:SqlDataSource>
<asp:DetailsView ID="DetailsView1" runat="server" CellPadding="4"
DataSourceID="SqlDataSource1" EnableModelValidation="True" ForeColor="#333333"
GridLines="None" Height="50px" Width="125px">
<AlternatingRowStyle BackColor="White" />
<CommandRowStyle BackColor="#D1DDF1" Font-Bold="True" />
<EditRowStyle BackColor="#2461BF" />
<FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True" />
<Fields>
<asp:CommandField ShowInsertButton="True" />
</Fields>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
</asp:DetailsView>
</div>
Hopefully I am posting this in the correct forum.
I am having a problem with my ASP.Net Web application. The application is developed using vb.net and is linked to a SQL Server database. Let me explain how the application works and the problem I am experiencing. The system is an online web app which allows registered users to create a CV online. One of the pages within the app gives users the chance to add a cover note to their CV. The page that allows them to do this consists of only a textarea control and a button control. The textarea allows users to input up to 4,000 characters.
Once the user clicks the 'Save' button to save their cover note info, the following code then executes.This code checks to see if the CV already has cover note info, if it does, then the application runs an update statement, otherwise, it runs an insert statement.The table within the database which records the cover note information is called tbl_covernote and has three columns, covernote_id (int and autoincrement), cv_id(int), covernote_text (nvarchar(max)).
The error which occurs sometimes is as follows:
Dim dr As SqlDataReader
Dim param(0) As SqlParameter
Finally [code]...
I am doing the MVC Music Store on VS 2010 and I get this expection: System.Data.EntityException was unhandled by user code Message=The underlying provider failed on Open.
Source=System.Data.Entity
StackTrace:
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source).....
It happens at the Album ablum line above. I checked and SQLExpress is running with login to Local system.
Complete code for Controller is:
[Code]....
I'm trying to do a master-detail by first search the database when a user click on the search button. Then display the result to a ListView control. After that, if the user click on the hyperlink, it displays the detail on the Formview control. Below are my code:
[Code]....
And here's the part that causes the error:
[Code]....
The error is on this line: string strID = ltvLusHmoob.DataKeyNames[e.Item.DataItemIndex].ToString();
In code behind getting error: Code:
Dim mySqlSelect As String = "Select distinct GroupName from Vecellio.dbo.GroupsTable where GroupName like %" & prefixText & "% order by GroupName desc" Value of string: Select distinct GroupName from Vecellio.dbo.GroupsTable where GroupName like %A% order by GroupName desc
Error: System.Data.SqlClient.SqlException = {"Incorrect syntax near 'A'."}
I am getting the below exception when I run my ASP.NET/C#/SQL project on an XP box:
[code]...
i am using the page asynchronousTask to call the wcf service which is reside in another project in same solution for that i am using following code
protected void Button1_Click(object sender, EventArgs e)
{
PageAsyncTask pat = new PageAsyncTask(BeginDoWork, EndDoWork, null, null);
Page.RegisterAsyncTask(pat);
//Page.ExecuteRegisteredAsyncTasks();
}
IAsyncResult BeginDoWork(object sender, EventArgs e, AsyncCallback acb, object extraData)
{
nor = new ServiceReference1.Service2Client();
return nor.BeginDoWork(acb ,extraData );//first null value is any call back method
//return nor.BeginProductList(acb, extraData);
}
void EndDoWork(IAsyncResult ar)
{
nor.EndDoWork(ar);
}
but in the endDoWork method it will show the following error
system.servicemodel.protocolexception was unhandled by user code
I'm attempting to use the following line of code in my VB.NET code-behind for my page:
[Code]....
"System.FormatException was unhandled by user code - Input string was not in a correct format"
This is driving me crazy! Can anyone see what the problem is?
[Code]....
[Code]....
If the table no data is displayed this error:
System.FormatException was unhandled by user code Message=Input string was not in a correct format.
[code]....
in my web project i got an error that i couldnt find any solution. the error says: System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. when i work in local there were no problem i put files to our server and i changed the database also. when i work in server in web application in Default.aspx i can connect db and get values without any problem using my DataLibrary
BUT the problem in my web service i also use my DataLibrary in webservice but when i try to run a method in web service it gives me the error which is : System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
my new db connection is
strConnectionString = "Data Source=OURSERVERNAME\SQLEXPRESS;Initial Catalog=DoveTR;Persist Security Info=True;User ID=sa;Password=123456789;Pooling=True";
private
static
void ReadKey(SymmetricAlgorithm
algorithm)
{
byte[] converted =
Convert.FromBase64String(ConfigurationManager.AppSettings["Key"]);
byte[] bytes =
UnicodeEncoding.ASCII.GetBytes(("$@|T"));
algorithm.Key = ProtectedData
.Unprotect(
converted,
bytes,
DataProtectionScope.LocalMachine);
}
I am getting the following exception "Key not valid for use in specified state"