I have a asp.net page that has several SqlDataSources defined that feed data into some graphs. The problem is that the graph product does not handle "no data" very well, and throws an error. I'd like this to handle the situation more gracefully-- so I need to check whether the SqlDataSource returned data or now before rendering the graph (and if not, just post a message saying "No Data" or something).
Is there an easy way to check if the data source returned data, and do this if/then without a bunch of code behind?
I have an SqlDataSource object, linked to a GridView, which receives data from a database when executed.I'd like to add the values of the "Cost" column, to get the "TotalCost", and place it in a TextBox or Label on top of the GridView.Is it possible to just use (recycle) the data in the SqlDataSource object, instead of using another SqlDataSource object to just get the TotalCost"?
What I want to do is, while the query is executed (i.e. for inserting a data), then after the data has inserted successfully, it should appear a message sounds: "The data deleted successfully". I've solved it by using GridView1_RowDeleted method.
Now the problem is, I want to catch the error while the query is failed to executed. If the query has failed to execute, then it should appear a message: "The data failed to insert."
I have a stored procedure that has a if statement in it. This if statement checks a count select. If it's greater than 0, it selects a set of data, if it's 0 then it selects a different set of data. The problem I have is in the vb code, I have been trying to check a value to see if it's there. If it is, then I add the value to a couple labels, otherwise I don't Here is the vb I have commented it so you can see what I mean.
Try Dim lrd As SqlDataReader = selectCommand.ExecuteReader() While lrd.Read()
In my .NET application I have to get results from a MS Access database. I would like to add error checking to make sure a row was returned from my SELECT statement.
I have a basic page which has fields that I read from the database and write to it. I would like to know where I should call the insert and read commands. I know about age_load but heard about page_loadcomplete.I noted that when the user refreshes the page, for some reason the sqldatasource loads the old data(before the write) even though new data has been loaded on the form.
I am inserting a record in an SQL table and trying to get the record ID back so I can use it to insert subsequent/related records in another SQL table. I am missing something but have no idea what. Code is below.
I'm sure im just making a simple mistake some place but i just cant find it. I have datatable which I can and can make changes, save back to the database just fine. But if I reload the data after updating, no data is retrieved from the database. But if I stop debugging completely and then start again, it loads just fine...until i call Update.
Here is some code I am using for testing purposes.
Private myDataSet As New DataSet Private conn As MySqlClient.MySqlConnection Dim myDataAdapter As New MySqlClient.MySqlDataAdapter
[URL] Using this I have managed to use Server Side Web Methods to perform actions with AJAX.In most instances, I just need it to do stuff (save things to a database for example) so don't need to do anything with the response, but now I've come across a situation where I do, and I can't work it out!The Web Method returns a JSON object, which looks like this:
{"d":"[{"validDetails":"True","lateAlert":"","LoginResponse":"Logging in Jamie at 16:53 please wait"}]"}
This is the output shown from Firebug. I am not sure what the 's are, but bear with it...The AJAX call and attempt at outputting this response is:
$("form").on("submit", function () { var LogonObject = new Object; LogonObject.password = $('#password').val();
[code]....
And several other variations from info I have found on Google and SO, but it seems to treat the results variable as a string, not an array, and the output I get on the alerts is each individual character, ie;
[, {, ", v, a, l, i, d, D... etc
So I wondered if results needed to be converted to JSON again (though I don't know why) so I tried
results = $.parseJSON(data.d)
But that didn't work either.
EDIT, the code which generates the response (missing out tons of logic, but this is the important bit):
Public Class OutputObject Public validDetails, lateAlert, LoginResponse As String 'content of JSON output' End Class
how to read all the tables returned by SQL Stored Procedure? My Stored procedure returns two tables:
ID Name ----------- 1 Jeff 2 Joe
[code]....
i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it?
I have been prototyping a simple site search tool.I found some online references to using webclient.download data. I have a (mostly) working prototype, but it only returns static HTML on the page that is being searched.I also would like to be able to search the contents of controls (such as text in label controls that are set at run time.) In the code below, the data in label1 is not returned.[code].....
1) The first function (call it GetValues()) returns values in a SQL database as a list via a stored proc. One of the fields is DateTimeSubmitted. All of this data is displayed on my webpage using a repeater control. It works fine.
2) The second function (call it NiceDate()) I created to change the DateTimeSubmitted to a nice date such as "one minute ago" or "yesterday".
My problem is I have no idea which is the best part of the process to do the conversion (at point of data extraction or in pageload etc.) or in fact how to do the conversion.
Can any one provide me the link or give me an idea how to read all the tables returned by SQL Stored Procedure?
My Stored procedure returns two tables:
ID Name ----------- 1 Jeff 2 Joe
ID Pages ---------- 1 2
i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it? please let me know if you guys have any ideas how to deal with this.
The problem is that for some columns it sets the data type to be Double even though the spreadsheet column format is "Text" and teh column contains non-numeric data. Then when it gets to that cell it returns DBNull instead of the text value.
My application is like this : i have to search my data from database with some check box and text box when user select check box specific function go on and then when user enters some range of value in textbox then the result will shown in data grid view after that i can print it by selecting data my vb.net code is as follow:
I need to create an application, which it connects to a IBM AS400 ATL to query LTO3 tapes that have expired and to be returned back to the datacentre. Tapes that have data written on them and not expired will need to be sent to an offsite location. Even if not an application, possible a script to do so.A email from the server will report the tapes require to go offsite and which tapes came be returned which can be overwritten with data again.
I am retrieving the scope_identity of a db entry, and I want to use that variable in a different SqlDataSource, primarily as an but I am unable to access the variable.I have the variable being displayed in a msgbox, and it is displaying properly, I am just unsure how to access it in the SqlDataSource. Here is my code;This is the datasource that inserts the first information and received the scope_identity, as well as the _inserted event; Code:
After the SQLDataSource gets the values from the database, I want to be able to use these values in the code behind. Kindly spare 5 minutes and give me some suggestions.
I have a SqlDataSource that is supplying data to my GridView. Thats all i am using on my form, thus i have NO code behind at all. But somewhere i need a TRY CATCH block just in case my connection get's lost. What code must i place where?
If i get a error i want my lblMessage Text to be "No connection".
I want to call a Stored Procedure using SqlDataSource. I've been reading the library documentation of the classes but i'm getting slightly confused. To call a stored procedure, I understand that I have to change the selectcommandtype and then set the selectcommand property to the name of the procedure.
'Change command type to stored procedure SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure 'set name of stored procedure
Public Sub CreateXml() Dim db As New MDataContext Dim Customers = <gallery columns="3" rows="3">
[code]....
Could i mix local values with the ones returned from the LINQ query...Something like the following?
Public Sub CreateXml(ByVal **Col** As String, ByVal **Row** As String) Dim db As New MDataContext Dim Customers = <gallery columns="& **Col** &" rows="& **Row** &">
