DataSource Controls :: Clean Or Refresh Database?
Jan 22, 2010Is there a way to clean all tables or objects within a database and make it like a brand new database?
View 3 RepliesIs there a way to clean all tables or objects within a database and make it like a brand new database?
View 3 RepliesI got a column which contains html content. The problem is, the content is not properly formatted. Meaning they consist of a big bulk of text, but without <p> or line break or proper <li>. Can anyone think of a quick way to write a script to tidy it up? I can't go through each and edit as there are like five thousands rows of them...
View 1 RepliesIf I make changes to a table or view in the datacontent (dbml), is there any way to refresh the fields in the dbml without deleting the datasource and inserting it back again?
View 1 Replieswe have a sql server 2005...that has 70-80 databases and hundreds of tables....
It is supposed to refresh every night.... refresh is done by other vendor(3rd party).... we dont know what method(technology) they use to refresh the databases....
My question is .....
Is there a good way to know when the last refresh has happend...can we determine it from sys tables.....
the sql server is installed in window server 2003 box.... we have access to the box as well as the sql server.....
I'm still relatively new to asp.net I'm trying to figure out the best way to write and implement this.
I have a cell that needs to autoincrement by 1 for every new database row in my table, Unfortunately I have to have the autoincrement restart at 1 at the beginning of each year so I can't use SQL Server identity increment. Maybe i'm wrong about the last statement and I just don't know how to do it.
The code i have is something like this:
If thereadedyear <> Now.Year then
theReadedYear = Now.Year
SomehowWrite readedYear
StartNumber = 1
Else
StartNumber =+ 1
End if
How do I implement this in a Insert Template?
I have LinqDataSource ID="LinqDataSource1" with values - EnableDelete="True", EnableInsert="True" EnableUpdate="True" on my ascx page, furthermore GridView, button a few textboxes, where a fill new values, which I would like save in my database. After click on button I insert new value to the table throught in function stored in ascx.vb page. It is works, but I don't know, how I refresh GridView on ascx page. I tried
LinqDataSource1.DataBind()
GridView1.DataBind()
without any good result, I must refresh page manualy (F5).
yes i know half post ack occurs but it does occur right?so why doesnt the dropdownlist get refreshed when the timer ticks on?. for alternative i tried manually clicking a button to create postback but still no refresh of connection of th list
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<br />
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<ContentTemplate>
<asp:Label ID="Label1" runat="server" Text="Status"></asp:Label>
<asp:Timer ID="Timer1" runat="server" Interval="6000">
</asp:Timer>
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataKeyNames="Username"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="Username"
HeaderText="Username" ReadOnly="True" SortExpression="Username" />
<asp:BoundField DataField="Password"
HeaderText="Password" SortExpression="Password" />
<asp:BoundField DataField="Code" HeaderText="Code"
SortExpression="Code" />
<asp:BoundField DataField="Validated"
HeaderText="Validated" SortExpression="Validated" />
<asp:BoundField DataField="Silenced"
HeaderText="Silenced" SortExpression="Silenced" />
<asp:BoundField DataField="Full_Name"
HeaderText="Full_Name" SortExpression="Full_Name" />
<asp:BoundField DataField="Batch" HeaderText="Batch"
SortExpression="Batch" />
<asp:BoundField DataField="Department"
HeaderText="Department" SortExpression="Department" />
<asp:BoundField DataField="abuse" HeaderText="abuse"
SortExpression="abuse" />
<asp:BoundField DataField="Status" HeaderText="Status"
SortExpression="Status" />
<asp:CommandField ShowDeleteButton="True"
ShowEditButton="True" ShowHeader="True" ShowInsertButton="True"
ShowSelectButton="True" />
</Columns>
</asp:GridView>
<br />
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource2" DataTextField="Username"
DataValueField="Username">
</asp:DropDownList>
<br />
</ContentTemplate>
</asp:UpdatePanel>
I have an admin page in which I need to change the list whenever a user signs up on our web site.How can I put and event to MySql database so that whenever the count of a table row changes it refreshes my update panel for me to see the new user.
View 2 Repliesi have in my asp.net web-page `label` that contain result of count record query.
i need to see refresh this query and see the correct record count.
how to see it ? i need any timer ? how to do it without Flickers ?
can i get any sample C# asp.net code ?
I am learning how to use repeater and datagrid. I've been able to update a datagrid successfully. I have two text box, which take an item description and quantity, save them in a database, and display them back in a datagrid whenever the user access the page again. If the user were to enter a value, let say description ='coffee' and quantity= '15', it would save them in the database properly. However, if the user refreshed the page, a second row with the same value ('coffee', '15') is added to the database again. How can I avoid this from happening?
View 1 RepliesI have created a simple dataset with my ObjcetDataSource to my SQL table named Invoices and a new FormView. My form inserts are working 100% correctly, however after some testing i noticed the insert happens again if i hit the refresh button on my browser after an initial insert. I am currently submitting the form back to itself with a success/fail message returned on the page so that the user can keep inserting more records if they choose. This is done in my Inserted behaviour.
In my ObjectDataSource_Inserting code i am setting the values of a date prior to my insert. How do i stop a second INSERT from happening when the user refreshes the browser? I thought it was what IsPostBack was used for? Here is my code:
[Code]....
I have a problem when I try to pass in paramaters for a report in my report viewer. I have set up the ObjectDataSource and set the paramaters for 3 text boxes that are on the page. The only way I have found to set the paramaters for the report is the user must fill in the paramaters and hit the refresh button on the Report Viewer toolbar ,but I would like to have the user click a asp.net button insted. Is there anyway to call the refresh method from codebehind?
View 1 RepliesI'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 Repliesi would like to ask about how to sync data from client sybase database import to our sql server database regularly(set time to sync everyday) by create a file in our sql server database
View 1 RepliesI have a development database and one in production. There are two different sets of data in each database. On my dev system, I have mostly dummy data that I test with and in production is the real data for my web application. I recently added a new feature to the app that required a new table, and a new field for a foreign key in an existing table. I now need to upload that new structure to the production database without overwriting the live data with my test data.
If I run the Database Publishing Wizard, and choose "Schema Only" will it import the new structure and leave the existing data alone, or will it drop the records in my production database tables?
I am building an image gallery, and decided to try out LINQ to SQL in it. My problem is when I try and remove an image from the database, it gives me the error:
"An object specified for refresh is not recognized. Right before this, I call a stored procudure that removes the the row, then I tell the DataContext to refresh (Otherwise it seems that the changes never get applied).
Here the code:
[Code]....
The last line is where the error is thrown. I've tried removing the last two lines both one at a time and altogether, and the code executes without an error, but the changes never seem to be applied as subsequent SELECT statements return the deleted row.
The whole application has access to the same instance of the Shared DataContext.
I have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 Repliesi want insert,update,delete,select records from databse with out refresh page and show a loading icon while intraction completed
i looked and you gave me this links
How to call server side functions in JavaScript ASP.Net
How to automatically refresh a page after some time interval?
In my website, I want to automatically refresh the page data(from database) after some time interval. I dont want to use any button click event to update the page data.
I've had to update my datasource as a field on my report has change. he StoredProcedure works just fine. However the report data source WILL NOT UPDATE so I cannot add the new field to the report!
View 2 Repliesi have in my asp.net web-page label that contain result of count record query.
i need to see refresh this query and see the correct record count.
how to see it ? i need any timer ? how to do it without Flickers ?
can i get any sample C# asp.net code ?
One of my radionbutton has to be checked for the first time . let user check depend on ( on OR off). And then save the value in the database. After save, when page refresh radion button will be checked its depend on which one user choose. I am struggling for that.
View 7 RepliesHow to add queries in to database using ajax (without page refresh).
View 1 Replies