i have a web application with sql server 2008 i wanna know if its possible to load the data automatically after its been inserted to DB..i have a alerts table which store message and user name to which the alert is to be send i wanna display the alert msg to user after it has been inserted...
View 3 RepliesI have a listview to display items from database and I need to automatically select the first item when the page first loaded, how can I do it?My listview is in one of the steps of a wizard control, and this wizard control is inside a popcontrol extender with updatepanel.
View 3 RepliesI have an issue that I've spent quite a bit of time trying to solve. I have a Detailsview and a Gridview that I have linked using the ID field, It has now been decided that they want to have individual pages for each Unit. I have this working for the most part, however the detailsview is not being displayed until I hit select the row in the gridview.
How do I get this to automatically display on page load?
I want to set the div to automatically print when the webpage loads how????
View 1 RepliesLets take an example of online ticket booking system. Many users could be booking the tickets at any point of time. a GridView displays the list of Allotted and Free seats If a seat gets booked, this information must get updated in all the opened pages in user's browser. User need not require to refresh the page to see if a seat is booked or not Should i put GridView in update panel and keep looking into the databse constantly ??? This could turn out to be a heavy work if databse is too large any other alternative?? or should i stick with the above approach....?
View 10 RepliesI had created Data Entry webform. Data is stored in Database. I have created 'Date' coloumn in database table with data type datetime. I want to isnert todays date automatically when data is inserted through form in DataBase.My current query to store data in database is:
public bool MyData(string COL1,string COL2,string COL3,string COL4,string COL5)
{
string SQL = "insert into TABLE values('" + COL1+ "','" + COL2+ "','" + COL3 + "','" + COL4 + "','" + COL5 + "')";
}
Users turn on their computers and XP boots up.I have an ASP.Net website.Is there a way such as a login script that runs that will run the default.aspx inmy ASP.Net website so that the first thing that the user sees after XP boots up is the default.aspx web page in my ASP.Net website?
View 1 RepliesI am using 2 combobox , In form_load event i am loading the combobox using dataset and In selectedIndexChanged event of the combobx1 we have to load combobox2
I am having a problem that when i load the form, combobox selectedIndexChanged event is firing automatically So how can i avoid this.
I understand that if it's a web application then IsPostBack method will be useful, but what to do as it's a windows (desktop) application.
need to save autonatically after 10 am.
View 1 RepliesHow 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.
URL....To this same gridview how can i load data from database? I want to load data in the gridview in the above link
View 1 RepliesI want to take first Full backup of my database then Differential backup of database automatically on a fixed interval of time and save it into my files of system. After that i want to upload these files on server. when uploading is successful then i want to delete these files from the system. If backup of database is failed then a mail should go to the related person. How i will do it.
View 1 RepliesThe sequence of events is as follows:
1. A piece of software running locally on my pc periodically uploads (approximately every three minutes) to my webserver an xml file comprised of six fields. The file size is < 1K.
1a. The file name is always the same. ie. filename.xml is uploaded. Three minutes later, filename.xml is uploaded again, this time with different contents. I have no control over renaming this file.
2. A chunk of code that parses the xml and inserts the six fields into a database
3. Deletes the xml file
4. Waits for the next xml file to appear in the folder
5. Goto 2.
The locally running software uploads the file without issue. So far, I'm able to parse the xml, do the database insert and delete the file manually by refreshing the browser window and subsequently running the code in the .cshtml file. What I'm having a hard time conceptualizing is what the best way is to set up an automated event/method that watches the folder and when a new file appears, write it to the db without user intervention. Also, where would I put this code? _AppStart? Do I need to start a FileSystemWatcher event on the server somehow? I'm kinda stumped as to how best to proceed.
How to fill username and password automatically when load a web page in asp.net ....
View 1 Repliesmy requirement is to delete database value automatically on a given date. In my application i am inserting records in database, now admin will give the expiration date for the value inserted in db. On that particular date, the value should be deleted automatically. I want a logic for this in asp.net. I am using SQL 2005 with C#.
View 5 RepliesI have Dropdown for Quotenumber(auto increment ).i have created a function to retreive the data from database.data loading into dropdown. when i click on Addquotenumer button the new quotenumber generated and same loading into dropdown but 2 set of Quotenumbers are displaying rather than singleset, i debudded the code the reason was i have called this function twice one is form load and another one in AddQuotenumber button event,both should manadetory as per my requirement. how can un load this dropdown before AddQuotenumber button
Function to retreive data to dropdown
Public Sub retriveDataToDropDown()
Try
Dim connectionString As String = "Database=fabdb;" & "Data Source=localhost;" & "User Id=root;Password=pacvision"
Dim query As String = "SELECT QuoteNumber FROM quotes"
Dim connection As New MySqlConnection(connectionString)
Dim da As New MySqlDataAdapter(query, connection)
Dim ds As New DataSet()
If da.Fill(ds) Then
DDQuote.DataSource = ds.Tables(0)
DDQuote.DataTextField = "QuoteNumber"
DDQuote.DataBind()
'DDQuote.Items.Insert(0, New ListItem("Select", "Default value"))
End If
connection.Close()
Catch ex As Exception
'Console.WriteLine(ex.Message)
End Try
End Sub
AddquoteNumber button code
Protected Sub btnAQ_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAQ.Click
Dim connectionString As String = "Database=fabdb;" & "Data Source=localhost;" & "User Id=root;Password=pacvision"
Dim rowsEffected As Integer = 0
Dim Query As String = ""
Dim connection As New MySqlConnection(connectionString)
'Dim cmd As New MySqlCommand(Query, connection)
connection.Open()
Query = "insert into Quotes(query follows...................)
retriveDataToDropDown()
retriveDataToDataGrid()
connection.Close()
End Sub
When I use RequiredFieldValidator inside a DetailsView control field template, it automatically prevented DetailsView from inserting new records into the database, when triggered. JavaScript was disabled.
I'm a bit surprised and I'd like to know whether this is caused by the validator or is there a built-in feature in DetailsView that prevents database from being updated if some validators on the page are triggered?
If so, how is it possibly implemented (e.g. inside when eventhandler)?
I want to send clients remainder automatically when he set remainder for particular date. mail automatically send to his mail on that day.
View 1 RepliesHow to generate a employee code in textbox automatically while in run time in web application.......when i run the page it will check the employee code in the database and it automatically shows the next value in the textbox how?
View 1 RepliesI am developing a small web site.web site has some links on the right side of the page.
I'd like when user clicks every link , related data load in the center or left side of the page.
how can i do this?
I use MS-sql server. how can i use DynamicpopulateExtender control to do this? is there other way to do that?
Like this pic : When i'm add new or delete Item, I want it's auto reload quantyti(The Quantyti I'm count from database). How to do that?
View 4 RepliesI tried to make an Update Panel to not load the whole page every time I need to load data from the Database server so I add Update Panel and add this java script code in every content page in my web site.
Code:
<script language="javascript" type="text/javascript">
<!--
with( Sys.WebForms.PageRequestManager.getInstance() )
[code]...
It works good but after end of the request I got a popup message say "NaN" every time I don't know from where it comes and of course it looks very bad for the client if got this popup.
At current we have about 100 websites that we host, a lot of those are database drive, what i wanted to do is build a script that would let me enter the details for this website into a DB (domain name, ftp username, password, database name, username and password etc) and then download that website / database on a regular basis
I wanted to do this in .net so i could add it into our intranet and add some reporting so when our clients log into the extranet they can see their website has been copied etc
How does UpdateModel() works? In the mvcmusic application the postback code contained the following:
UpdateModel();
storeDb.saveChanges();
How is this automatically saving changes to database?
My previous impression of RequiredFieldValidator and similar have been that they show you an error label and set Page.IsValid false and that is it. Meaning they leave the rest of the task (preventing the use of wrong input data) to you. But today I have realised say if you use a DetailsView to insert a new record to a database, and you use validators to check the TextBoxes inside the DetailsView, they automatically prevent the database from being updated.
I would like to know how this is implemented behind the scene. I'm guessing it aborted the Page Lifecycle at Validator.PreRender event, so that database connections at later stage could not be reached? I'm probably wrong. I'm trying to use Reflector to get inside the RequiredFieldValidator to see how it is implemented, but I don't really know where to look.