i have a vb.net application that contains and MDF file that holds 2 tables, when i execute an SQL update command it executes fine and the data are updated only in cache, so when i clean my solution the updated data disappears ( database gets back to its original state ) and does not actullay commit in the tables.
View 4 RepliesI have dataset which is called at page load event. Also every time i clicked on refresh it will call refresh function where it store updated values from database.
Now I want only updated fields row and want to store into datatable or another dataset.
I dont want to cmp each and every iteration of the dataset. I used Getchanges() of dataset but not working.
I have a Iqueryable problem
<%= Article.Replies.OrderBy(r => r.Created).First().Member.Username %>
I want to get the most recent Replies that is part of the Article
"Article.Replies" gets all the replies
So now I want to Order by Replies.Created by descending And then just take the first one from which i can get the members username fine. Im having a syntax problem with doing the orderby descending and by picking the first.
have detailsview
<asp:DetailsView
ID="dtlviewRecommendation" DataSourceID="LinqDataSourceRecommendation"
DataKeyNames="PK_TT_RecommendationsSysId">
[code]...
We have a SQL agent job tied to an SSIS package that process does an Update process on the dimensions and a full process on the Facts. In the morning the cube is showing that it is processed but the new data is not present. When it is manually run the SSIS package, it seems to work fine. Basically there is job having two steps, one is to update the BI Cube and next step is to update dimensions and facts. This jobs runs perfectly without any error, but first step executes as per the expectation and second fails to update with latest data. If we try to manually run the SSIS Package of the second step it perfectly updates with the latest data.
View 2 RepliesA ListBox is being filled from the database, from a SQLDataSource. Im setting the parameters in its _Selecting event. Except when it is done getting its new Data, the ListBox isn't updated with this new data. Eventhough i rebind my ListBox to the DataSource.
View 3 RepliesIs there a way I can automatically update a 'Date' column in my database table to the current date whenever any cell in that record is updated?I've started looking into table triggers a little bit and I'm wondering whether I can do it using this?
View 1 RepliesI am having a table named Invoices.From that table I want everything the newly inserted and updated rows from that table.
View 3 RepliesI'm trying (poorly I might add) to set up a select statement and due to my noobishness I simply have not found a way to do it RIGHT. Then again - I'm probably starting entirely wrong - but I've gotta' learn somewhere.I'm attempting to track product usage (think mild inventory tracking). In the system, I have independent parts and builds (combination of independent parts) - each has its own SQL table. Each time a "build" is completed, I want to update my part inventory with an updated count of that item.
Build_tbl
Build_ID (int/spec)B_nameB_desc
Part_tbl
Part_id (int/spec)P_nameP_cost
Build_asmb_tbl
[code]...
I have a GridView, and its GridView_RowUpdating() method is called, and NewValues are set correctly... but at the end the database is not updated.
[Code]....
[Code]....
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE M_T1 SET c_name=@c_name WHERE rowid=@rowid";
cmd.Parameters.Add("@rowid", SqlDbType.Int).Value = Convert.ToInt32(grdmsal.Rows[e.RowIndex].Cells[1].Text);
cmd.Parameters.Add("@c_name", SqlDbType.VarChar).Value = ((TextBox) grdmsal.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
[Code] ....
I have the above but fater editing value when i update its not updated no error...
if we overwrite the db backup(using restore database) then is it posible to recover data of previous backups?
View 2 RepliesWhats the best way to read data from cvs file
View 2 RepliesI have an image file to be uploaded and to be updated in my database. I've already write the C# code based in a VB code.
However, I have some trouble to pass a data to be updated through DetailsView Control, by using
DetailsViewUpdateEventArgs e
The column in database is "ImageData"...
In VB the Code is:
e.Values(
"ImageData"
) = imageBytes
ImageBytes is an array of bytes..
I have a lot of members data to enter into the ASPNETDB database. How can I read this data from an Access data file and input into the SQL database. All data is for user Names and Password,
View 1 RepliesI have a data bound control (using <%# Bind %>). I am trying to change the value of it before it gets udpated.
I use:
[Code]....
But the value is not changed to 1.
Also, e.Keys, OldValues and NewValues are all empty for whatever reason.
I have SQL Server Database Primary Data File.
I want to recover the data from that file in to my data base which has the empty tables.
I have Microsoft SQL Server Query File which contain the table structure.
i want to compare my database value with my new updated value. what should i do ? e.g : on page load i am excuting one procedure which bring 10 columns and fill it against the 10 fields using for loop on the page. then i am changing value of two columns. ok. when i press update button then there is one more procedure which updates all the new and old columns into database. Its working fine. just i want to know that, should i update only two columns(which are modified) insted of updating all 10 columns ? Is there any csharp code that brings my page load columns into array and then compare it with new ones and updates only those columns which are mismatch with array. i am not sure but there is some way to do this.
View 4 RepliesI have a gridview bind to an object datasource Now there is an edit button to edit the entriesUser selects new entries and clicks update Gridview gets updated (all previous entries replaced)Now the new records dont contain the table id of the previously added rowsOn form update, how do I know which entries to drop from database and which entries to insert as the previous rows are all gone?the results are in form of collections of objects returned by object datasource.
View 6 RepliesI had made a change to the MasterPage and I would like to publish this to my production server at Server Intellect.
I wanted to know, that since I re-compiled the site, and saw the changes locally, do I now need to FTP all of the files?
Or can I just upload the file that I changed- the MasterPage?
Also, Im planning on making a change to a Class. Can I just upload that .cs file by itself?
I want to export query data to CSV format using a DTS package. In sql 2000,it's giving lot of issues.
View 1 RepliesI have a requirement to fill the pdf file.
We are using Sql server and i want to transfer data from SQL server to pdf file.
I have used the same steps that you have used on your sample for inserting, deleting and updating. This is my code
private String strConnString = ConfigurationManager.ConnectionStrings["CustomerConnectionString2"].ConnectionString;
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
BindData();
[Code] ....
It is deleting the data but not updating the data,it sticks to the same data after clicking on the update button...
Here is my code. I just wanted to update one column. Why is everything getting NULL put into it?
[Code]....
[Code]....
On one (aspx) page I have a GridView (GridView has multiple pages). After a user selects a row/record and clicks "edit" he's redirected to another (.aspx) page where he edits the selected record via DetailsView. fter clicking update on DetailsView he's redirected back to the page containing the GridView.What is the simplest/shortest way that the updated record is automatically selected on the Gridview (e.g. at Page_Load event)?
View 7 Replies