In the following code, the user documents types are not getting updated, they do initially but don't stay updated. perhaps you can see something blatant here:
<Columns>
<asp:BoundField DataField="DocumentType"
HeaderText="Customer Document Types"
SortExpression="DocumentType" />
<asp:ButtonField CommandName="Delete" Text="Delete" />
[Code]....
I have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
View 1 RepliesI'm using a GridView to retrieve data from a stored procedure using a SQLDataSource (db is SQL Server 2008). When I compile my application and go to my website, all the data is loaded and shown fine. If I was to add a new entry to the table however (a seperate page on my website has a Wizard control to facilitate this) and then return to the page with the GridView, the new entry doesn't show up.
Looking from SQL Server, the data has been added, but the GridView isn't updating to show it. If I were to recompile the project with F6 and refresh the page, the new data will show up. I tried calling DataBind() on the GridView in the Page Load event, however the issue still remains.
I have a GridView in ASP.NET. I have an Edit CommandButton for every line in the GridView to edit the data on that line. All of this works fine except for the fact that when the user clicks on Update, it does not update with the correct value that the user entered. I have this as a Template field with the textbox to edit bound to the field, so it updates when the user changed the value and clicks Update. However it does not work. I have tried almost everything and its very frustrating. Here is the code for the Data Source:
<asp:SqlDataSource ID="Table1DataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
InsertCommand="INSERT INTO TABLE1(ProjectId, WBS, WBSTitle, VersionId) VALUES (@ProjectId, @WBS, @WBSTitle, @VersionId)"
DeleteCommand="DELETE FROM TABLE1
[code]...
I have a page with an updatepanel, which at runtime has controls dynamically created. The controls are saved within the cache, and readded to the page upon postback each time when needed. Sometimes the controls need to change, sometimes not. In most of my cases, if I just re-add the control to the page without any changes to the control AJAX will leave the control alone on the client-side leaving me with what I expect to see, which is no change. If I make a change, it obviously updates correctly.
Now, I have added a literal control which defines an iFrame which points to another page. ie:
Code:
.LiteralControl.Text = "<iframe name='" & .LiteralControl.ID & "' id='" & .LiteralControl.ClientID & "' frameborder='no' scrolling='auto' height='" & _
.ItemHeight & "px' width='" & .ItemWidth & "px' src='" & "WBRender.aspx?ViewID=" & strUniqueID.ToString & "' style='position: absolute; " & _
"left:" & .ItemLeft & "px; top:" & .ItemTop & "px;'></iframe>"
If I re-add this control on postback, with a change, I get the item on the page as I expect. If I make no changes to the .Text and simply re-add the control to the page, it flashes as though it has been changed and then re-requests the page defined by the src. The whole point of me caching this, is to stop the client-side from updating a control that has not changed, removing a flashing screen and all the resizing that goes with it.
I have a gridview which contains a dropdownlist inside a TemplateField. The ddl appears correctly and seems to work ok but it isn't updating the table despite being bound to a field.
[Code]....
I've created a page called "EditItem.aspx" where a user can edit a row in a database. On EditItem.aspx.cs, the pageload function grabs the correct row from the database (by grabbing the querystring in the url). The form is populated with all of the correct data. I've got a button onclick that runs this code:
[Code]....
But the changes do not apply. However, if I set static information (so the information is not being grabbed from fields on the form) into the SQL string, I can click the button once, nothing will happen, but if I press it a second time, THEN the information will be passed to the database.
There seems to be something wrong with the create user wizard?I am using hashed password storage. When I change it to clear storage I see the user's password is being stored as something completly different than what they typed in.Example: changeme1 now equates to something like: 4W*KQQ4%=SIf I use 4W*KQQ4%=S as the password to login with it works but changeme1 does not.When I use the reset password wizard it updates the password just fine and it works when I login next.Any clues what could be causing this?
View 1 RepliesI have a button in a Gridview that updates selections. This works fine.
I made a DropDownlist wich should put the variables "Kursistnummer" and "pcsvar" in a new table.
The button in the Gridview writes the value of "kursistnummer" and the text "pcsvar" in the new table.
But if i call the sub"btnTilmeldPc_Click" i get this error:
Procedure 'LP_KursistEksamenPc' expects parameter '@kursistnummer', which was not supplied Its friday and its a bit hard stuf for me.
I have these procedures:
[Code]....
and stores procedures in my db
[Code]....
and a general dropdownlist
[Code]....
and my Grivwiev
[Code]....
I have a web application and on page is an update page to update some profile information. Below is the code I am using to update the table. But I think it is wrong. Does anything stick out? The connection string works cause it is used to read the database to get the profile information, I just removed it due to it containing password/login info for the db.player is the class of properties that contains player information and ds is the dataset, but I would like to update the database itself online...
Dim connectionString As String = ""
Dim GigsterDBConnection As New System.Data.SqlClient.SqlConnection(connectionString)
GigsterDBConnection.Open()[code]....
I think the issue is something the 3 last lines of the code. am I doing it right or is their a better way?
I have two tables master and comp table. In master table, I have columns called LB1, LB2, LB1_ID, LB2_ID and in my comp table I have ID and CompName. I need to update my master table the following way
If LB1 in master table has a value of 'XYZ' then I need to find that value in Comp Table in column compName and then put the ID from comp table to master table in LB1
master
LB1 LB2 LB1_ID LB2_ID
XYZ HIJ
ABC KLM
DEF RAW
PQR VQS
Comp
ID CompName
1 XYZ
2 ABC
3 RAW
4 DEF
5 VQS
6 HIJ
7 KLM
8 PQR
I need to poulate my master table like this
master
LB1 LB2 LB1_ID LB2_ID
XYZ HIJ 1 6
ABC KLM 2 7
DEF RAW 4 3
PQR VQS 8 5
Was wondering if someone can help me out with this multi update problem
I have a webform that populates a single table but due to certain dropdown data conditions it could also potentially populate 3 other tables
The tables information populates a gridview with amounts from accounts etc..
e.g.
Table 1
Site DataType account update
34 SS 12.50 N
Table 2
Site account
34 12.50
Say the above entry has the updated column changed to Y via the webform the amount 12.50 should disappear from the gridview. I was
a bit shortsighted and added the additional tables afterward. The information on the gridview pulls from the additional tables and since
the first table and the additional tables are not linked the data still stays the same in the gridview
I do have an Id column on both tables but unfortunately I added the rest of the tables after the first one so the Id's do not really match.
I've got an MVC 1.0 View that is more-or-less an attempt at reproducing WSAT.
On the Security->Manage Users page there's a column of checkboxes for "Active" for each user. Also when clicking the 'Edit roles' link a set of roles shows up in the Roles column of the table.
I'm using the standard SQL based Membership and Role providers that come out of the ASP.NET box.
For some reason, when I run the app from VS2008 all is well and I can update the Active and Roles values. However, when I deploy to a remote server, either my test server or in production, the checkboxes don't update the databse. Note that the links for 'Edit user', 'Delete user' work fine. I can create a new user or delete a user with no problems in any of the deployed locations. Also the 'Edit roles' link also works fine in that it brings up the list of all possible roles and shows which roles the user is in. The problem is specifically with the Checkboxes.
Interesting to note is that the JavaScript alert() (see below) does fire when clicking on any of the Role checkboxes. However, although the box is checked, the database is not updated on the any but VS2008 Casini. The database connection string is not changed on any of the execution sites which are running SQL 2008. IIS 7 on one deployed server (an ISP) and 7.5 on the other my in-house test server.
Here's the code I'm using to create the Roles portion of the page:
[Code]....
So I have two tables in my database, Contacts and Addresses:
Contacts : ContactID | AddressID | FirstName | LastName
Addresses: AddressID | Address1 | Address2 | City | State | Zipcode
I have a page where you can add a contact. It contains all the information for a contact and an address for a contact. Here's my code for when you submit the form:
[code]...
Now my main concern is that the address is added successfully, but then an error occurs when I try to save the contact, leaving the address in the database with no contact.
What's the best practice here for rolling back any changes if an error occurs?
Maybe this could be a simple questino, but for me it's difficult to do this action: I have a table in sql server 2005 with some records stored, for example 10 records. The primary key of this table, let's call it "Employee", it's a number field with an autoincrement constraint. I want to store more data into the table by using a OdbcDataTable object and OdbcDataAdapter and adding new rows to the datatable and afeter that use the "Update" method from the OdbcDataAdapter object.
The big deal is this: let's suppose that I want a add a new record to the datatable object, using any method or code sequence that you want. if I have 10 records stored on the data base table, when I retrieve this table schema by using the OdbcDataAdapter "Fill" method, I have a copy of the data base table schema in the DataTable object, right?. if I add a new row on the datatable object, it's suppose that the primary key column of that table must AUTO-INCREMENT the value of the key, I mean if the last value that I store on the table was the number 10 on the PK field, when I add a new row on the datatable object, the PK value on the datatable object must be the number 11 if the autoincrement constraint is present into the DataTable object, but in my case, it doesn't work
So, How can I define the conditions or set the c# data objects properties to wor in that way???. In this moment the PK column on the odbcDataTable doesn't auto-increment its value when I add a new row on it.
Please helpe with this.
PD: I have another question about the DataTable object, how many records can store this object?? I have some problems with this because sometimes when I use the Fill() method to get data into the DataTable or a DataSet object there's no problem if the Fill() method retrieves about 142000 records, but when I retrieve over the 145000 records, when I inspect the DataSet or DataTable object by using the debuging mode, they have null value. Any of you can tell me why this situation ocurrs??
I have an excel sheet with 2 tabs and has data in those 2 sheets(sheet1, sheet2) which correspond to different tables in the same database. This excel sheet gets updated daily, I am wiriting a console app( which will later be a batch build). I have to insert the data from the excel sheet to corresponding tables (table1, table2,table3) in database when i run it and and also if the table has the same data already present it should ignore and if there are any modifications done the data it should update the table. I know we can do this using ado.net or LINQ, I am a little new to database based programming .
View 4 RepliesI am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
View 5 RepliesSo I sometimes use app_offline.htm to take an app offline while I upload a new version.However, while I am in the process of uploading larger dll's, I get the yellow error-screen saying the dll could not be loaded.This seems to be out of sync with my expectations of what app_offline.htm does (stops the app entirely), and also provides the users with errors in stead of the nice app_offline.htm I put up.Am I doing something wrong or is this behavior by design?
View 1 RepliesI need a submit form in my site and tried to use this code to create one. It works on one of my sites but won't on this one (see the problem at [URL] I am posting my code below that goes with the page published at the above URL. Can anyone tell me why it displays the way it does instead of as a submit form?
View 2 RepliesI have problem that just started showing up and I have no idea where it is coming from. I am making a website (ffctestsite.com) that uses the CSSFriendly.dll and .browser files to make a menu control look pretty. Unfortunately, it looks great when I preview the page from VS2010, but as soon as I publish it, the menu turns into a text menu and it doesn't render any of the ul's and li's that I expect to see. If you go to [URL] I've posted a picture of the code before and after publishing. I am using .net 3.5 because my host is slow at adopting new frameworks versions, but it worked until about a week ago. It just stopped working after that.
View 3 RepliesI have a simple file input field that utilizes a File.Copy routine to move the file from the local store to the server. This part of the application works fine in staging but in production I had to establish a work around in order to get it to work. I have the users do a Save As on the file they want to upload and then slightly change the name of the file and then it will upload. I do not have to do this in staging with the same file in order for it to work. I am racking my brain as to whether this is a permissions issue or code issue or what.
View 4 RepliesI have a url which I wish to encode that contains a couple of encrypted querystring parameters:
[URL]
I've been asked by a client I'm working with to html encode this url. I've used HttpUtility.HtmlEncode() to do this. This returned the following:
[URL]
This appears to be correct as the '&' has been replaced with '&'. However a problem arises when I try to use HttpUtility.HtmlDecode() on this new value as I get the following returned:
[URL]
What appears to have occurred is the '&' has had the 'amp' removed and the ';' has been html encoded (I checked the value of '%3b' and it corresponds with the html encoded value of a semi-colon). I'm not sure why this is happening?
I realise I could manually do a .Replace("%3b", "") as a temporary fix but I can't see this being a good long-term solution.
i am using visual basic 2008 with sql server 2000 ,, since sql2005 is not compatible with my vista. how can i connect to my database (default) i am facing a lot of problems .
View 2 RepliesI am rewriting a website for a company who want to keep the existing stock listing format of asp pages pulling info from an uploaded access database. I have left all the asp code alone, just changed the html around it to accommodate a better (albeit not perfect) design than previously used. I have also been adding items to the database exactly the same way the staff do it now.
However, when I view the pages, there is no content, only the html "wrapper". I get the error message displayed where the content should be: "An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error."
I am running IIS on my local machine and as far as I am aware, it is configured correctly. I can view asp pages that do not request content from the database fine.
Pages are served on my local machine under
c:inetpubwwwroot
Database is served under
c:inetpubdb
I make use of SMO namaspace to get Table, Function, Procedure names from the DB.
Now I've intended to get the tables [Column] name and the relation (dependency) among the tables. Is this possible?
