I have a function that checks for a username and if it finds the username it will allow the user to update the user, there are 3 main columns: Name,Age,isFemale. I have the enduser supply the information and then I try to update the record but I get a sql error for "not a valid" column.console app:
[Code]....
I pass the spIsFemale by using an enum, here is the Person Class with function. [Code]....
I get an error that column isFemale is not valid. The isFemale column is a bit type. If it's a 1, it's a female, if 0 male. this is more of a test area and I'm trying to update records or create new one's if the name does not exist.II am new to C # and I am just trying to learn new ideas and methods within C sharp.
cmd ="select [title] from products where sku='% "3.5 caddy" %'"
this statement wont return anyfin where there is products with titles startin with 3.5 or ending with caddy or containing 3.5 caddy but just not together for example there is this title "3.5" IDE to USB 2.0 Aluminum External Silver HDD Enclosure Caddy" and that search of 3.5 caddy wont pick this item up as 3.5 is at the start and caddy is at the end.
I have written a bunch of T-sql code to my accessdatasource selectcommand. But I am having problem with where statement ! here is my code;
SELECT OWGBP, RTGBP, OWEUR, RTEUR, OWYTL, RTYTL, (SELECT Resort FROM Resort RF WHERE (View = True) AND (RF.ResID = TypePrices.ResID)) As Resortİsmi, (SELECT Destination + ' - ' + CodeOfDest FROM Destination TD WHERE (View = True) AND (TD.DestID = @DestID)) As DestIsmi, (SELECT TypeOFTrf FROM TRFTypes WHERE (TRFTypes.TRFTypeID = TypePrices.TypeOfTRF)) As TrasferTürü, @QADT As ADTSayi, @QCHD As CHDSayi, ([CHDPerCent]/100) As PerCHDCent, (ADTSayi ++ CHDSayi) As Deger, ResID FROM TypePrices WHERE ([View] = True) And (ResID = @QRes) AND (Deger >= [MinReq]) AND (Deger <= [MaxCap])
And here is my select parameters;
[Code]....
It is a bit long ! I am having problem on last two where declaration. here ;
(Deger >= [MinReq]) AND (Deger <= [MaxCap])
those MinReq and MaxCap columns are int32 columns. But when I run the page it doesnt work properly ! It display the valuse it shouldn't be ! weird thing is, when I display this 'deger', I get the value properly. with this;
Değer : <b><asp:Label ID="Label10" runat="server" Text='<%# Eval("Deger")%>'/></b>
for example I get 8 with this but it dosnt work on where statement.
In HTML I usually use the techniqe to check for different statments by calling public Strings and like in this case if test == "notTrue" wich it is not, then the following code in the if statment wont render in the HTML.
It have worked out fine but it does not seem to work for the update panel that I declare. I get this error. I wonder why that is happening and if there is a way to to this in HTML like I do here ?
Microsoft JScript runtime error: Sys.InvalidOperationException: Could not find UpdatePanel with ID 'UpdatePanel1'. If it is being updated dynamically then it must be inside another UpdatePanel.
how to fix my sql syntax so my code works again, i made a few manual entrys for now to see if I can get them to be displayed: The FriendUserID relates to another UserID in the usertable who has obviously a different picture and information but I dont know how to display to concurrent WallPosting's from different users atm.
my code creates a dynamic div gives the div an ID = to the userid and input the wallpost messgaes named wallpostings, it takes the information stored about the userid and applys the image related to that userid, is there any way this can be changed with sql? or have i went down a one way alley?
public partial class UserProfileWall : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack) { //It is a postback so check if it was by div click (NOT WORKING because the javascript isnt posting back) string target = Request["__EVENTTARGET"]; if (target == "DivClicked") { string id = Request["__EVENTARGUMENT"]; //Call my delete function passing record id using (OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=gymwebsite2; User=root; Password=commando;")) { cn.Open(); using (OdbcCommand cmd = new OdbcCommand("DELETE FROM WallPosting WHERE idWallPosting="+id, cn)) { cmd.ExecuteNonQuery(); }..............
If i split the statements up they work fine individually.But what im trying to accomplish is to pass in the column name that i want to select from my table.. ill pass it from the page as well as 1 other parameter.
I was looking and found some queries that will return the column name from the table but figured this may work.when i execute this,it returns the actual value in my SET @column line.so in the below code if i run it, it will just return the value "VideoLevel"
BUT if i change it to the example below that,it works..
im trying this query but i get a error at the very end of the statement at [BookingNumber] ---- The error IS: Incorect Syntax near [BookingNumber]
"UPDATE ["+txtDBNameSql+"].[dbo].[Bookings] SET [ItemPrice]="+Price+",[ItemCode]="+Code+",[Status]="+Status+",[Clientescription]="+ClientDesc+",[ArrivalDate]="+arrival.ToShortDateString()+",[DepartureDate]="+depature.ToShortDateString()+",[DurationCharged]="+Nights+",[ClientCode]="+clientCode+" WHERE [BookingNumber]="+WebBookingNo+""
I'm trying to do updates into for a table with checkbox and number value type from the search page but there is problem with my update statement.Problem with the code: Unable to perform an update, datatype mismatch.
there is a field in my table WATERMARKED_IMAGE which is null at present...i want to insert value in that column....at the same time i want to update a column FLAG.
so should i use insert or update query??
SqlCommand storeimage = new SqlCommand("update WATERMARKED_IMAGES set WATERMARKED_IMAGE=@bmp,FLAG=@flag where (WID='" + wid + "' )", connection); storeimage.Parameters.Add("@bmp", SqlDbType.Image,bmp.Width).Value = imtobyte; storeimage.Parameters.Add("@flag", SqlDbType.Int, 50000).Value = Flag;
I am writing a simple form that will take in data and insert it into a db if it's a new record and update the existing record if it already exists. The insert works fine, but the update isn't working at all, yet the code looks solid to me and everything I've compared it to in my google searches.
I'm writing an update statement to update a user's password in the linked Access Database when they input (and confirm the input) of the new password in a textbox on my webpage.
The SQL statement that is being generated is - UPDATE tblUser SET [Password]=[chuck68] WHERE UserID=0000009
With tblUser being the correct name for the table, Password being the correct name for the field I wish to change and UserID being the linked field to lookup the password from.
The entirety of my code is as follows: (with the necessary import statement at the top of the class).
Protected Sub ChangePasswordButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ChangePasswordButton.Click
I have a method to execute two "Update" sql statements.
The first one works fine and the second one I can't get to work for nothing.
Here is the entire method:
[Code]....
The error I am getting is "Incorrect syntax near '05'."
It is occuring on the next to the last line which is:
dc.ExecuteCommand(sql);
I update the variable "sql" first so I can debug. At the time it crashes the value of sql is:
"Update Blogs set Status = 'Archived', ArchiveDate = 06/22/2010 05:14:46 PM Where (BlogID != 1) and (Status = 'Published') and (AuthorID = 9e37e028-c205-4903-920e-e8643b30a724)"
It appears to be the ArchiveDate that is causing the problem here. The "05" is the hour of the time portion. Both ArcgiveDate and PublishDate are defined exactly the same in the database. If you look at the first dc.ExecuteCommand it does exactly the same thing with PublishDate (DateTime column) in the same table and it works just fine.
Then I modifed the code and remove the ArchiveDate from the sql statement then I get the error:
"Incorrect syntax near 'e028'."
which as you can see is part of the AuthorIDs value in the where clause. So I am assuming both the date and the Guid / Author ID is causing problems. I have tried enclosing the values in quotes but I just cant make this work even though it seems to be working fine in other places.
I even remove the code for the author ID and left in the code for the ArchiveDate and it still does not work so I have proved that both are causing a problem.
I am trying to update a Single Record in a table. I also trying to join columns of that single record with another table to update prices the prices of that record.
I have a GridView; one of the columns displays concatenated records from a tables. to extract the records that are going to be concatenated and put in this column, i have used: FOR XML path('') and it works just fine for displaying those records. the problem now is the whole gridview can not be sorted anymore and gives me a 404, document not found, error whenever i try to click the columns to sort. here is my select statement for my sql datasource select command:
SqlDataSource2.SelectCommand = "Select a1.*, keyword = substring( ( SELECT DISTINCT ', ' + keywordName FROM keywords JOIN key_mm_articles ON key_mm_articles.keywordID = keywords.keywordID WHERE key_mm_articles.articleID = a1.articleID FOR XML path(''), elements ),2,500) FROM articles a1 WHERE title LIKE '" & titles & "' Order By a1.articleID"
I have a simple table. (with PK). I have created a tableadapter that selects all fields and filters with a control parameter. This works fine. The results are displayed within a DetailView control. All okay up to this point. I have then enabled 'Editing'.I can then click on the edit and change the text, but when I click the edit button the page updates but the value has not changed in the database?
I am using Linq to SQL. Tables have timestamp columns and I am using regular Linq methodology in ASP.NET MVC.I do use detached entities and always try to do updates without first querying the database for the original entity. To update an entity I use context.Attach(entity, true) followed by context.SubmitChanges() and all is fine. The sql statement that gets executed looks like:
I have a gridview that is using a SQLdataSource with an update statement and I am able to print out the update statement listed in the SQLDataSource by doing this:
[Code]....
but for some reason the record is not being updated so I want to know how do I print out the entire Update statement, including the value of the EmailAddressID to make certain that the update statement is being set correctly?
I can test the update statement above manually, taking the EmailAddressID for that record and then run the update statement manually using SQL Server Mgmt then it updates the record correctly so I know the update statement set in the SQLDataSource is ok. However I still want to print out the update statement that is supposed to be executed in the vb code, how to do this?
I see there is an event called "SqlDataSource1_Updating",
is it possible to print out the actual update statement there?
Just to be clear in the asp.net page I want to do something to print out the actual full update statement, ex:
<SQL> UPDATE [EmailTable] SET [EmailAddress] = @EmailAddress WHERE [EmailAddressID] = 22 </SQL>
I am running an Update statement against an SQL database on server 2008. The update runs but does not update the record, but returns no errors.The database is part of a commercial help desk package called TrackIt 8.5 which was just a fresh install on a new web server and a new sql server. The update is running from a web form we use to automatically create active directory accounts. After the account is created the web form closes out the work order in the Trackit db. This was working fine when the system was running on Server 2003 and SQL server 2005. Running Trackit version 7.02.The login use to access the database has full permissions to read and write to the database, just as it did on the old server which never had an issue updating. Odd thing is, if I log onto the SQL server and make a change to any single field in that record. I can then run the web form and it updates the record normally.
I'm quite new to asp.net. I use MS Visual Studio 2008 and MySQL database. When I try to edit a record via gridview and the generated UPDATE syntax I get an error.I inserted a gridview into my asp.net web application and connected it to my database (all is OK). Then I checked for auto generation of update and other syntax:
[Code]....
When I test in a browser I get a pop window form for editing a record. But when I click "update" I get the following error:"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, strSkrajsanNaziv = ?, strKraj = ?, strDavcnaSt = ?, SkupinaID = ? WHERE Stran' at line 1"what's wrong with the UPDATE syntax? Is this syntax only valid when using MSSQL?
I was wondering if there is any way to view an sql statement that is created by a templateField Gridview when updating? I had my Gridview working properly then I changed my update statement to update less fields and I changed a couple more things on the page and now I don't know what broke it. The error I'm getting is
"System.Data.OleDb.OleDbException: Syntax error in UPDATE statement."
When I searched for this error it said to debug it but all that happens when I do that is visual studio tells me there were errors because it couldn't find my header, which it does find when it runs regularly so this isn't the problem.
i built an oledb update stmt using the syntax from a 4 guys tutorial, http://www.4guysfromrolla.com/articles/071002-1.3.aspx , but am getting the above error
sample how i build an update field into the update string
Dim targetAttendeeCount As Integer = _ CType(e.Item.Cells(0).FindControl("targetAttendeeCountTextBox"), TextBox).Text Dim parmTarAttCnt As OleDbParameter = _ New OleDbParameter("@targetAttendeeCount", OleDbType.Integer) parmTarAttCnt.Value = targetAttendeeCount myCommand.Parameters.Add(parmTarAttCnt)
so none of the variables are being resolved, i know they are being returned from, in this case a datagrid, because i have printed them separately, so am not sure at this point how to get the vars to resolve, i was hoping to not have to use all the quotes + apostrohes and thought the @syntax was simplifying that but not so. is there some way to code this with the @'s?
I need to loop through a GridView and get the values of a databound field. Then use those values in my update statement.
Here is the GridView:
[Code]....
And here is my UPDATE statement, which is actually just passing the values to a stored procedure:
[Code]....
Right now, I just have it grabbing the text from a label control, but I know that will not work as it only passes one value. I need to be able to update multiple rows based on the del_doc_num.
