ADO.NET :: Return Value When Empty Table?
Oct 19, 2010
I have the following code that i call from the page behind code.
when no records are in the table i get an error message
invalidcastexception
conversion from type DBNULL to type Decimal is not valid
I would prefare if the procedure did not throw this error message and returned a value to notify me that no records found when zero records returned
Public Shared Function invoicetotal(ByVal CustEmail As String) As Decimal
' Dim selectcommand As New SqlCommand
Dim CONNECTION As SqlConnection = MaintainDB.GetConnectionString
Dim sel As String _
[Code]....
View 2 Replies
Similar Messages:
Jan 1, 2010
I have a page that lists products from a table based on the querystring. So if I say foo.aspx?fam=1 all the products from family 1 will be listed. How can I make my code list all the values if query string is empty? My SQL command would have to be different...can't really see how I can do this.
<asp:SqlDataSource ID="ds_produtos" runat="server"
ConnectionString="<%$ ConnectionStrings:LocalSqlServer2 %>"
SelectCommand="SELECT DISTINCT [IdProduct], [Name], [Description], [IdFamily], [Price], [Stock] FROM [Product] WHERE ([IdFamily] = @IdFamily )">
<SelectParameters>
<asp:QueryStringParameter Name="IdFamily" QueryStringField="fam" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
View 2 Replies
May 7, 2010
I have th following code:
[Code]....
I got any error from the code, saying 'not all code path return a value', i suspect it is the catch block doesnt return a value. If so, what value should i return?
View 4 Replies
Jan 25, 2011
i always got the empty string in form data posting. can you describe what the hell happened in my code? always got the empty string to insert to SQL server even it is drop down list selected value is empty. Is this the error in visual studio cause sometimes i can get the value and sometimes can't (inconsistent!!!)
Protected Function sqlparameter_insert_newscat() As SqlParameter()
Dim sqlparam(4) As SqlParameter
Dim ddlstatus As Boolean
If rbActive.Items(0).Selected = True Then
[code]...
View 2 Replies
Mar 1, 2010
My program running good. But i try to add up-down icon on my gridView header. but if i make it, My break point should drop below "if comparison" For example; field.SortExpression=Category but every time CustomersGridView.SortExpression is empty when gridview.SortExp is not empty.
foreach (DataControlField field in CustomersGridView.Columns)
{
if (field.SortExpression == CustomersGridView.SortExpression)
{
return CustomersGridView.Columns.IndexOf(field);
}
}
i need :
foreach (DataControlField field in CustomersGridView.Columns)
{
if (field.SortExpression == "Category")
{
return 2;
}
}
CustomersGridView.SortExpression must not be empty!!!!!
MY source:
<head runat="server">
<title></title>
<link type="text/css" href="StyleSheet.css" rel="stylesheet" />
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:GridView
ID="gvCustomers" runat="server" CssClass="tablestyle"
AllowSorting="true"
OnRowDataBound="GvCustomers_RowDataBound" AutoGenerateColumns="false">
<AlternatingRowStyle CssClass="altrowstyle" />
<HeaderStyle CssClass="headerstyle" />
<RowStyle CssClass="rowstyle" />
<Columns>
<asp:BoundField HeaderText="Kategori" DataField="Category" SortExpression="Category" />
<asp:BoundField HeaderText="Tarih" DataField="Date" SortExpression="Date" />
</Columns>
</asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>
protected void GvCustomers_RowDataBound(object sender, GridViewRowEventArgs e)
{
GridView gridView = (GridView)sender;
if (gridView.SortExpression.Length > 0)
{
int cellIndex = -1;
foreach (DataControlField field in gridView.Columns)
{
if (field.SortExpression == gvCustomers.SortExpression)
{
cellIndex = gridView.Columns.IndexOf(field);
break;
}
}
if (cellIndex > -1)
{
if (e.Row.RowType == DataControlRowType.Header)
{
// this is a header row,
// set the sort style
e.Row.Cells[cellIndex].CssClass +=
(gridView.SortDirection == SortDirection.Ascending
? " sortascheader" : " sortdescheader");
}
else if (e.Row.RowType == DataControlRowType.DataRow)
{
// this is an alternating row
e.Row.Cells[cellIndex].CssClass +=
(e.Row.RowIndex % 2 == 0
? " sortaltrow" : " sortrow");
}
}
}
}
View 1 Replies
Mar 25, 2011
I'm using ASP.MVC 3 with SSRS 2008 R2. I have some reports which I want to render as PDF document. So I my controller, I've got this code
[Code]....
Problem is, that this code returns empty pdf. If I call PrintReport directly from view, then it works. But when I call ReportSwitcher, which calls PrintReport, then it returns empty file.
View 19 Replies
Feb 27, 2011
i want my query to return results where the field address is not empty or null
however, the query i have is still returning results where address is empty i.e. ' ' .
View 2 Replies
Jun 4, 2010
I am dynamically creating a table that contains a textbox in each cell. The table is put in a placeholder control. Everything displays perfectly. The problem is when I go to retrieve the values entered in the cells. I have the code to generate the table in a separate method called CreateTable(). In order for my program to find a table in the placeholder when I go to save, I have to run CreateTable() in a postback event AND in the PageLoad event. If I call CreateTable() in only one of those places and I try to save, it says the placeholder is empty and, therefore, I cannot save the textbox contents. I've tried calling CreateTable() from InitLoad but that doesn't work because it needs to reference values from three static controls: 1 dropdown, 1 listbox, and 1 calendar control, which I don't believe have had their viewstate rendered yet.
View 1 Replies
Mar 16, 2010
In reference to this question that I just asked, [URL] it appears that for some reason, an empty text box's value is not being fed to SQL Server as NULL, as it ought to be.
View 6 Replies
Oct 6, 2010
When user requests http://localhost/WebApp1/Default.aspx, txtApplicationPath.Text should be assigned "/WebApp1", while txtAbsolutePath.Text should be assigned "http://localhost/WebApp1/Default.aspx", but instead both textboxes display empty strings.
[code]...
View 1 Replies
Nov 29, 2010
[Code]....
How to use the ValidationSummary if the condition is not met, or the table is empty?
View 1 Replies
Jan 19, 2010
I just deployed my first ASP app to a remote server (using SQL SErver) and some data entry forms are crashing when the associated table is empty. The PageLoad method is empty, but the error occurs before the page becomes visible. The limited run time error I see says page not found error 404. If I put a record in the table using Mgt Studio, everything is fine. The form contains two LInq data source controls that populate dropdown lists, but everything else was hand coded - no data bound controls at all.
There is no attempt to access the actual empty table until the data has been entered and the Insert button is pressed. I have made sure that the tables that use the datacontrols for dropdowns have data in them, even though this should not matter. I did not have this problem on my local machine when developing. In summary, page does not load when table is empty, even though I do not access the table when the page loads?????
This is the entire codebehind file, and yet the page cannot even seem to load.
[Code]....
View 7 Replies
Sep 9, 2010
I have a textbox named txtOrderDate on my web page. I have a VB.net subroutine that saves various textboxes from my web page to my SQL table using a stored procedure. If a valid date is entered into txtDate, then my save works correctly. I have a column named OrderDate in my table. This is the column I am saving txtOrderDate to. OrderDate is defined as a date column and null is allowed.
But if txtorderDate is blank, my subroutine bombs saying cannot convert string to date. I tried various things like making the value of txtDate = DBNull.value if blank but nothing works. Seems like there would be an easy way to do this.
View 3 Replies
Aug 16, 2010
how to return two ids from the same table, i need to create a cursor, it has to use two
EID details of different LID of the same table.
[Code]....
The above query is wrong, it is getting duplicate rows, so i need to optimize it ti return the two values in two different variables in cursor.
View 4 Replies
Aug 11, 2010
I have a table on my web form that I need to populate at runtime. I can do this ok and add controls to it, and all works well. However in between each row in the table I am trying to insert an empty row using the following:
[Code]....
[Code]....
NOTE: The litEmpty.Text in code is assigned the non-breaking space character
Anyway when the table is created and displayed, the empty row is not displayed.
View 3 Replies
Jul 18, 2010
How to determine whether the table is not empty?
Using reader
View 9 Replies
Oct 1, 2010
I am new to Sql server 2005. I have a table in which contains many data. I need to take particular data. For example, I want to take value of 110652.795813712 from FTEBASEPAY column. So i have wrote the sql statment like in below. SELECT * From tblEmployees where FTEBASEPAY='53842.7782655718' But i am not able to get the particular value. Manually i have seen the tblEmployees table, in which contains the particular data ('53842.7782655718'). When i execute the above select statement, there is no result for it. What i have to for overcome this issue?I have to give one more information, the FTEBASEPAY dataType is float in tblEmployees table.
View 4 Replies
Jul 26, 2010
This question is regarding the ASP.NET webservice that i am creating using the DAL-BLL architecture for my final school project.I have a stored procedure, which is a select query with an inner join for 2 tables.Hence the stored procedure returns multi-table value. One of my DAL tableAdapter methods accesses this stored procedure. How do i retrieve the return value in the BLL? Do i have to create a class structure similar to the one supposed to be returned by the stored proc? or is there a direct way to achieve the same?
Here is some more information:I am using the SQL dataset (.xsd) in DAL. So i have a datatable called "Insurance", which has a tableAdapter. One of the queries in the adapter references to a stored procedure, which has an inner join. So my SP looks like:
ALTER PROCEDURE dbo.GetInsurancesPaged
(
@startRowIndex int,
[code]...
View 2 Replies
Mar 10, 2011
I have a table thats created dynamically, the table gets its contents from a custom class I've created that gets statistical data from a database. As the table is generated dynamically, I've put the contents class (the table data) into a session object and I populate the table initially inside a !IsPostback then on the page init I get the data from the session (its empty on the firts page load). I am now getting this error: Multiple controls with the same ID 'controlnamehere' were found. FindControl requires that controls have unique IDs. How can I avoid this?
View 4 Replies
Aug 31, 2010
i designed a gridiview, within that ItemTemplate i drew an table then tr then some of td's, now the problem is after every row im getting one empty row. below is my code
<ItemTemplate>
<table cellspacing="0" cellpadding="0" style="border-right:1px solid Black;" >
<tr >
<td width="1%" align="center" style="border-right:1px solid Black;">
<span style="">
<asp:ImageButton ImageUrl="~/inc/img/img1.gif" runat="server"
CommandName="Expand" Style="display: none" Width="11px" />
</span>
</td>
<td width="5%" style="border-right:1px solid Black;" > <%--onclick="ShowMenu( <%# Container.DataItemIndex + 1 %>);--%>
<asp:Label runat="server" Text='<%# Eval("data1")%>'></asp:Label> </td>
<td width="5%" >
<asp:Label runat="server" Text='<%# Eval("data2")%>'></asp:Label>
</td>
</tr>
</table>
View 6 Replies
Sep 29, 2010
I am inserting data into Employee table using stored procedure.In employee table EmpNo is identity column.Once i insert data into table stored procedure should EmpNo i.e identitycolumn value.
correct my stored procedure to returm EMpNo Identity column after inserting row.
alter procedure SAR_Sp_AddEmployee(@EmpName varchar(10),@CampaignID int,@startDate datetime) as insert into EmpMaster values(@EmpName,@CampaignID,@startDate)
View 5 Replies
Mar 24, 2010
I'm not so familiar with stored procedures but I'm interesting in moving most of my web selects to stored procedures. I'm working with .net based website and all my data access is something like this:
[Code]....
But now I want to improve some process and make tunings. For that I want to use stored procedures, so instead of the "SELECT ...." sentence I'll put stored procedure name. My problem is how to return a table from one.
View 3 Replies
Jan 16, 2011
I am wondering if jsonResult method can be used to return Data Table? If so, is it a json array or a json string?
View 6 Replies
Jun 22, 2011
I have three XML files that are auto-generated and placed into my wwwroot directory. From there, I need to be able to search through these XML files looking for a record by either first name or last name. So, I have three xml files: a_results.xml, b_results.xml, and c_results.xml.
I'm having trouble reading / scanning these files so I really need some hand holding here. Very novice ASP/asp.net programmer here. Basically, I want a "search page" where the user will enter their search criteria into a text box (either first or last name) and the page will search the first and last name fields in all three of my xml files and return the results in a table, including the resulting first and last names plus their extension number.here is an example of one of the xml files
Code:
<response method="switchvox.extensions.search">
<result>
<extensions page_number="1" total_pages="1" items_per_page="500" total_items="3">
<extension number="1111" status="1" can_dial_from_ivr="1" account_id="1446" display="John Smith" date_created="2009-12-23 11:57:36" type="sip"
[code]....
So, as an example... I go to the page - enter "test" into the search box and click "find". The page should search all three xml files for the word "test" in the first OR last name fields and then return ALL of the combined results in a table which shows first name, last name, location and extension number (all available in the XML file(s) as shown above).
View 2 Replies
Jul 12, 2010
I have a Procedure which should return only 1 Record on selecting record according to Priority.
BEGIN
DECLARE @Accounts nvarchar(MAX)
SELECT @Accounts = ISNULL([map_user_modules].[Accounts], '') FROM [map_user_modules]
WHERE [map_user_modules].[id_user] = 231 AND [map_user_modules].[id_module] = 5
IF ((@Accounts = '') OR (@Accounts = 'All'))
SELECT @Accounts = null
BEGIN
Select @@ROWCOUNT as Priority2
END
IF @@ROWCOUNT = 1
BEGIN
Return
END
BEGIN
Select @@ROWCOUNT as Priority3
END
IF @@ROWCOUNT = 1
BEGIN
Return
END
BEGIN
Select @@ROWCOUNT as Priority4
END
IF @@ROWCOUNT = 1
BEGIN
Return
END
In the above statement Suppose we take a scenario where Select @@ROWCOUNT as Priority3 is executed, I get two tables returned, One is the Table returned by Select @@ROWCOUNT as Priority3 and the other is the Table returned by Select @@ROWCOUNT as Priority2 which has no Records. How can I eliminate the Empty table that returns no records.
View 1 Replies
