the error occurs in the first line of the if statement...i really dont know how to fix this problem..
Dim GW1 As new GridView
GW1 = CType(Me.LoginView1.FindControl("GridView1"), GridView)
If GW1.PageCount < 1 Then
[code]...
I'm looking for a way to format a drop down list's selected value property such that if the Bind value is not found in the db then display "Empty".
I saw something a while back like <%# Format { Bind("Account_Type") ? Bind("Account_Type") : "ALL"} %>.
Using vb.net/asp.net 2005.
I have a gridview that is using a SQLdataSource with an update statement and I am able to print out the update statement listed in the SQLDataSource by doing this:
[Code]....
but for some reason the record is not being updated so I want to know how do I print out the entire Update statement, including the value of the EmailAddressID to make certain that the update statement is being set correctly?
I can test the update statement above manually, taking the EmailAddressID for that record and then run the update statement manually using SQL Server Mgmt then it updates the record correctly so I know the update statement set in the SQLDataSource is ok. However I still want to print out the update statement that is supposed to be executed in the vb code, how to do this?
I see there is an event called "SqlDataSource1_Updating",
is it possible to print out the actual update statement there?
Just to be clear in the asp.net page I want to do something to print out the actual full update statement, ex:
<SQL>
UPDATE [EmailTable] SET [EmailAddress] = @EmailAddress WHERE [EmailAddressID] = 22
</SQL>
how to get the sql statement query or table name if oledbexception occurs - table or view does not exists.
get the DB details from the oledb exception.
I'm quite new to asp.net. I use MS Visual Studio 2008 and MySQL database. When I try to edit a record via gridview and the generated UPDATE syntax I get an error.I inserted a gridview into my asp.net web application and connected it to my database (all is OK). Then I checked for auto generation of update and other syntax:
[Code]....
When I test in a browser I get a pop window form for editing a record. But when I click "update" I get the following error:"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, strSkrajsanNaziv = ?, strKraj = ?, strDavcnaSt = ?, SkupinaID = ? WHERE Stran' at line 1"what's wrong with the UPDATE syntax? Is this syntax only valid when using MSSQL?
I'm having a wicked time trying to redirect the different error scenarios to a custom error page. Basically, I have put some code in Application_Error in global.asax, and done the necessary web.config settings to use Custom Errors.
In global.asax on Application_Error, I stored the Server.GetLastError in Session. The reason I have to store it in Session is because (as far as I know) you lose the exception when using "ResponseRedirect". And the reason I have to use ResponseRedirect is because I am using an UpdatePanel with AJAX calls, and any exception during the AJAX call shows up as a JavaScript error, and doesn't get handled using the custom error page (see this post).
void Application_Error(object sender, EventArgs e){ ////must perform this check to avoid the "Session state is not available in this context" errors if (HttpContext.Current.Session != null) { Session["LastException"] = Server.GetLastError(); } else { // (I think this happens when there are compile-time errors) Server.Transfer("~/Oops.aspx"); }}void Session_Start(object sender, EventArgs e){ //must perform this check to avoid the "Session state is not available in this context" errors if (HttpContext.Current.Session != null) { //initialize the session (http://forums.asp.net/t/1405077.aspx) Session["LastException"] = ""; }}
I want to redirect to Error.aspx page if runtime error occurs.How to acomplish this task.
View 8 RepliesI am using three listviews on a page ... the first is always populated ... the other two are sometimes populated I want to total amounts and counts from all three ... so I set up steps in the DataBound events works great when all three listviews are populated the error "Object Variable or With block variable not set." occurs when LV2 or LV3 is not populated I've tried testing DataItem ... Is Nothing but get the failure on the If test instead
View 3 RepliesI have tested and tried to fix this until I am blue in the face and can not figure it out...
[Code]....
The SQL works fine if I just query in SQL - I only get the error when I try to get anything from the SalesPerson table and display it in my gridview.
In my application I am accessing my DB using simple stored procedure..but My code got exception....while I debug the code I have seen that the code is executed successfully and while the whole try block has been executed then the code call the exception but more ridiculously without any kind of error..here is my code
[Code]....
I am using a textbox to populate mySQL database. My problem is when I recall the text it displays without line brakes or line spacing, inserted in the input textbox. I have tried all the field types i.e. Text, Small, Medium Text and Chars. I have tried gridview, repeater and datalist all displaying continuous text without line brakes.
View 4 RepliesI have a gridview which i want to update line by line.Its for confirmed users.SO i have a list of users and they are confirmed by clicking the checkbox and updating the value in the database.But how can i find the checkbox on the gridview and get the value. Ive tried the following code but no joy
[Code]....
i have a webform which has got required field validators. when the user doesnt enter values and clicks submit button it should not cause postback. i have set CausesValidation="True" on the submit button.hen the user clicks submit button without entering values, validation occurs( red * marks are shown) but the postback also occurs.
<asp:TextBox
ID="txtContact"
runat="server"
Width="290px"
CssClass="default"
[code]...
When a server error occurs for whatever reasons (YSOD), the server will send a message via SMTP class. In my case, my company employs microsoft exchange and uses NTLM authentication for all domain users. I am authenticating users via NTLA windows integrated authentication. My question is, is it possible to utilize this authentication data, and pass it to the system.web SMTP username/password authentication scheme to send an email to me (the web developer) when the error occurs? I am pretty sure my company requires a username/pwd to send emails via SMPT on the ms exchange server.
View 1 RepliesI have a method which perform following task
1.save file to a folder
2.save data to database
3.send email to client
I want if any exception occur then non of them will work.
currently it save file even if there is some exception in databse connection or sending email. Which make my folder heavy.
I get and error when I run a sub select statement. What is wrong with the statement?
[Code]....
[Code]....
ERROR:
System.Data.SqlClient.SqlException: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
How do I continue a VB statement on the next line, to improve readability?
View 4 RepliesHow to send group of sms and email to many people at the time of error occurs in my application (vb.net) so the everyone get alert...
View 1 RepliesRangeValidator validation occurs on CancelCommand
[Code]....
I have written some vb code that inserts whatever has been written on my page into an Access database. Only problem is VWD throws up an error saying that the syntax of my SQL statement is wrong. I am 95% sure that this statement is correct because when I saw the statement in Text Visualizer and tried that statement in MYSQL the data went in perfectly.
I have pasted the code below:
strSQL = "INSERT INTO User (UserID, FirstName, LastName, Password) VALUES "
I have a user control with a datalist loaded on my web page and also a web form to add another entry to the datalist when the button to submit the new entry I need to reload the user contol to show the new entry
<h1>Admin</h1>
<h2>News</h2>
<asp:label ID="lblSearch" Text="Select News: " runat="server" />
<asp:DropDownList ID="NewsList" runat="server" CssClass="DropDownMenu" />
<asp:Button ID="btnSearch" Text="Search" runat="server" OnClick="btnSearch_Click" />
<br />
<br />
<asp:Label ID="dbErrorMessage" ForeColor="Red" runat="server" />
<asp:Label ID="Successfulmessage" runat="server" />
<br />
<asp:Label ID="lblTitle" runat="server" Text="Title" CssClass="TextBoxLabel" />
<br />
<asp:TextBox ID="txtTitle" runat="server" CssClass="TextBox" />
<br />
<br />
<asp:Label ID="lblNews" runat="server" Text="News" CssClass="TextBoxLabel" />
<br />
<asp:TextBox ID="txtNews" runat="server" TextMode="MultiLine" Width="500px" Rows="10" CssClass="TextBox" />
<br />
<asp:Button ID="btnSubmit" Text="Submit" runat="server" Onclick="btnSubmit_Click" />
<asp:Button ID="btnUpdate" Text="Update" runat="server" OnClick="btnUpdate_Click" />
<asp:Button ID="btnDelete" Text="Delete" runat="server" OnClick="btnDelete_Click" />
<br />
<br />
<uc1:NewsList ID="NewsList1" runat="server" />
<br />
protected void btnSubmit_Click(object sender, EventArgs e)
{
// Define data objects
SqlConnection conn;
SqlCommand comm;
// Read the connection string from Web.Config
string connectionString = ConfigurationManager.ConnectionStrings["platiummindproductions"].ConnectionString;
// Initialise connection
conn = new SqlConnection(connectionString);
// Create Command
comm = new SqlCommand("INSERT INTO News (Title, Date, News) VALUES (@Title, @Date, @News)", conn);
// Add command parameters
comm.Parameters.Add("@Title", System.Data.SqlDbType.NVarChar, 50);
comm.Parameters["@Title"].Value = txtTitle.Text;
comm.Parameters.Add("@Date", System.Data.SqlDbType.DateTime);
comm.Parameters["@Date"].Value = DateTime.Now;
comm.Parameters.Add("@News", System.Data.SqlDbType.NVarChar, 4000);
comm.Parameters["@News"].Value = txtNews.Text;
// Enclose database in try-catch-finally
try
{
// Clear message labels
Successfulmessage.Text = "";
dbErrorMessage.Text = "";
// Open the connection
conn.Open();
// Execute the command
comm.ExecuteNonQuery();
DataBind();
// Display sussessful message
Successfulmessage.Text = "News Updated successfully!";
}
catch
{
// Display error message
dbErrorMessage.Text = "Error updating the News details! Please try again later!";
}
finally
{
// Close the connection
conn.Close();
}
}
I have the following gridview inside an updatepanel that makes the bind from a datatable:
[Code]....
What I intend to do and I'm not getting is the following: When i edit a textbox in a row with a new value, like Desconto textbox, i want that when that textbox looses the focus, to refresh the gridview with new values that result from changes in the value of the textbox. It's a new bind as i know, the problem is how to find the correct way to trigger the textbox textchanged event, at the moment nothing is happening. I created the Desconto_TextChanged event but when compiling, i receive a compilation error:
Description: An error occurred during the compilation of a resource required to service this request. review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30456: 'Desconto_TextChanged' is not a member of 'ASP.index_aspx'.
Source Error:
[Code]....
using vb.net/asp.net 2005 and SQL Server 2005.I had similar issue yesterday: I created a unique index on a table to prevent duplicates when user tries to edit existing records in a gridview.This works fine and I am seeing the "cannot insert duplicate key row message...." however I need to catch the exception because I do not want to display the table and column names.I have this set up but its not catching the exception, the exception is displaying but not my version, does anyone know in what gridview event and how I can catch and customize this exception? what i have now (but not working ) is:
[Code]...
I have a data driven asp.net website with frames on the top, left, right and center screen. If a page generates an error on any of the frames, I want to redirect the whole site back to the Default.aspx. Currently, when a frame page errors in one of the frames, that frame gets the error pages. Site is URL.... Is this something that can be handled?
View 1 RepliesI'm here again to share a problem that I'm fighting against for days. I'm developing an eCommerce Cart.
Within it, I have a repeater, inside of ITEMTEMPLATE I put one TextBox for product quantities and one Button, for update the quantity inserted on that textbox.
When the customer clicks over the Button, it fires a function that gets the content of the TextBox and do an update on my Database.
It works perfetly when it is done with the mouse click. But I need to fires the update function WHITHOUT the manually click event. When the customer just put the mouse out of the TextBox (onblur event), I want to fires that function.
REPEATER CODE
[Code]....