Just a fictional code, but why this won't work? (as the date variable is nullable)
DateTime? date = textBoxDate.Text != "" ? textBoxDate.Text : null;
The error is "There is no explicit conversion between System.DateTime and <null>
Code:
SELECT one, two, three, four FROM tblFixedLine_onenet_callLog WHERE (one LIKE '%' + ISNULL(@one,'') + '%') AND (two LIKE '%' + ISNULL(@two, '') + '%') AND (three LIKE '%' + ISNULL(@three, '') + '%') AND (four LIKE '%' + ISNULL(@four, '') + '%') ORDER BY one, two, three, four
@one, @two, @three and @four are textboxes on my ASP.NET page all of which by default have no value(therefore i assumed NULL).If i test the SQL in the VS2005 SQL Configuration (and put the values in manually) it works but the ASP page returns no results... i assume therefore the Textbox value is "" not Null.
This is an ASP.NET 3.5 web app written in C# using VS2008 and connecting to an MS SQL backend. It is using ad hoc queries in a strongly typed dataset to pull from the database. This query (shortened for clarity) is designed to allow optional input of parameters (a requirement) or pull all records if no parameters are input. It works normally in SQL Server Management Studio with the addition of Declare and Set statements and it works normally in the TableAdapter's Query Builder:
[Code]....
The markup contains this ObjectDataSource, which is tied to the TableAdapter with the above query:
[Code]....
The problem I'm having is in passing null values to the ODS to feed to the query. Tying the ODS parameters directly to the dropdownlists and textboxes didn't work. Got an error message that there was a mismatched data type. Tried several combinations of code to feed the right values to the ODS parameters but couldn't find one that worked. Is the problem in the query or am I setting up the code-behind wrong? Here's the code:
[Code]....
I have req where i have to check the value coming from db is null or not and assign value according to that.Problem here is the field datatype is 'Datetime' so all the time when I tried to use the below line of code its giving me error.How can I pass a null value to datetimefield if value coming from db is null.
(reader["FieldName"] == DBNull.Value) ? string.Empty : (DateTime?)(reader["FieldName"]);
I came to know that string.empty is making problem,what value we can pass instead of string.empty for a datetime column in C#.
What I want is ,Field value will get null value assigned not zero.
I am using VS 2008 SP1. My also have included CSS Friendly adapter [URL] in my project ( I mentioned this because my GridView Empty data template is not showing when using GridView's CCS Friendly adapter). I have a GridView and a DetailsView. When a record in GridView is selected its details information is shown in the Details View. Type of Data source I am using is ObjectDataSource. My Insert and Update methods works perfectly. It is only the Delete method that is passing null values to the underlying object delete method. My source codes for both the UI, BLL, DAL is shown below
[Code]....
My Business Object code is below :
[Code]....
My Data Access Layer Code is:
[Code]....
Is it possible to use a condition inside an actionlink ?I would like to do this :
[Code]....
This will be used for some column sorting and if the current sort was asc the next sort has to be desc. The code above is not valid while compiling.
I want the text box and the Apply button to be on the straight line. What am I doing wrong?
<tr align = "center" valign ="bottom">
<td align="left" style="padding-top: 15px; height: 30px;">
Promo Code</br><asp:TextBox ID="txtCouponCode" runat="server" MaxLength="10" TabIndex="5" Width="130px" />
<asp:ImageButton ID="ImageButton1" ImageUrl="../images/apply-blue.gif" runat="server"
OnClick="imgApply_Click" ValidationGroup="0"/>
I am using ajax table and i have more than 10 tab panel.
The table panel occupied three line.
I need to make it in a single line.
It may be can have the button on both the end.
Initially 5 tab panel should be displayed.
When the >> buttoin is clicked, one by one the tab panel should ne visible.
I have a Perl script that calls aspnet_compiler.exe to compile a large ASP.NET website. The problem is that it takes very long to run. Is there any way to compile just a single .aspx file from the command line? (I think that would suit the needs of my script) It seems that all aspnet_compiler.exe can do is compile at a directory level.
View 2 RepliesI have a gridview containing serial-numbers.
I would like to format the background each data-row that contains a duplicate serial-number value.
I'm planning to do this using a DataBound event handler.
So, in English:
Set background colour of THIS_ROW to red where the Serial_Number of THIS_ROW is the same as the Serial_Number of ANY_OTHER_ROW.
All rows with duplicate serial-numbers would be red.
I'm not sure how to write the code for this event.
The gridview is bound to a SQL datasource. Getting the dupes in SQL is easy:
SELECT Serial
FROM Table
GROUP BY Serial
HAVING (COUNT(Serial) > 1)
I have read plenty of tutorials on taking a datagrid to a text file, but I haven't seen anything about taking a single cell from a datagrid, formatting it, and writing it to a text file. Is this possible, am I going about it wrong?
View 3 RepliesI wanted to know if we can pass values from Parent page (in this case from Default.aspx page) to the user control and maintain those values on subsequent "Add/Load" of user control.
So in short, if I click the "Add" button it loads my "webusercontrol" and also I am able to pass my default.aspx dropdownlist value to this dynamically loaded user control and assign it to a "Label or Textbox" which resides in my "webusercontrol", now the problem is that the value doesn't persists! What I meant is , when I click "Add" button again the "webusercontrol" gets loaded again perfectly but now all my "Label's" in webusercontrol has the new selected value from the default.aspx dropdownlist.
So say for instance I have a Dropdownlist in Default.aspx page with Values "Apple, BlackBerry, Nokia" and initial value to be passed is "Apple", I click the "Add" button, now my "Label" inside webusercontrol has the value "Apple", perfect! Next when I click "Add" button again and select a different value to be passed this time say "BlackBerry" now I have 2 webusercontrol loaded on the page, so that means I have 2 "Labels" with different ID's, but now my first Label initially had the value "Apple" because that's what I had passed and now when I passed the value "Blackberry" both the labels of my webusercontrol has the value "BlackBerry" instead of one being "Apple" and another "BlackBerry"
Is there a way to resolve this issue? may be Dictionary List?
I am creating a Data Tabel in code behind and binding it to Gridview. I am trying to format by creating new line in a single column. Here is the code:
row("Employee Name") = empName + ("<br/>" + empTitle
GridView1.DataSource = myDataTable
GridView1.DataBind()
i am using a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
<Columns>
<asp:BoundField DataField="slno" HeaderText="SerialNo"
SortExpression="slno" />
<asp:BoundField DataField="ecode" HeaderText="Employee Code"
SortExpression="empcode" />
<asp:BoundField DataField="ename" HeaderText="Employee Name"
[code]....
Passing onto a stored procedure a value from a GridView. The particular fields are a date type, and numeric type. Problem is, its plausible and conceivable in this case one or both could be null or empty.
Through searching I've seen suggested such ideas as Convert.ToDate(value), CDate(value), and so on.
None of these work. You cannot convert an empty string or null value to a date. I don't know about the numeric value.
So, barring any non-working examples already given. What is standard. Its not like I've stumbled across some never afore seen problem.
Here is my code, but its quite typical.
Dim txtctlHireDate As TextBox = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("txtHireDate"), TextBox)
Dim txtctlGradYear As TextBox = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("txtGradYear"), TextBox)
Dim txtctlBU As TextBox = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("txtBU"), TextBox)
Dim ddlctlEvalGroups As DropDownList = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("ddlEvalGroupSelection"), DropDownList)
Dim chkctlActive As CheckBox = CType(gvEvaluatees.Rows(e.RowIndex).FindControl("chkActive"), CheckBox)
UpdateEvaluatees.MGEvalUpdateEvaluatee(gvEvaluatees.DataKeys(0).Value, txtctlHireDate.Text,
txtctlGradYear.Text, txtctlBU.Text,ddlctlEvalGroups.SelectedValue, chkctlActive.Checked)
gvEvaluatees.EditIndex = -1
gvEvaluatees.DataSource = EvaluateesForDataGrid.GetData
gvEvaluatees.DataBind()
I've bolded the parameters in question. A date value and numeric value are expected.
i have some problem in passing null value to an integer datatype in sql. Here is my code:-
[Code]....
The if statement within query is where i am having problem!
This might be confusing but ill try to explain the best as i can. I have a gridview that get the data from datatable. This is simulation my grid view.
key data
1 data1
2 data2
2. data2
2. data2
3. data3
3. data3
what i want is make some conditional statement, when value "key" is changed i want to add empty row. so its suppose to be looks like this as result.
key data
1 data1
EMPTY ROW
2 data2
2. data2
2. data2
EMPTY ROW
3. data3
3. data3
Where do I validate my date values prior to passing them as insert programs ?
I am trying to pass some Null dates.
In my property ?
[Code]....
[Code]....
[Code]....
I have a SP db.sp_GetProfitMatrix , it takes nullable integer parameters, for which I have a default . It refuses me when I try to pass a null value (the two date parameters are nullable in the Linq designer) I get {"Nullable object must have a value."} error. here is my code:
int? nlDt = null;
var pms =
from p
in db.sp_GetProfitMatrix( nlDt.Value, nlDt.Value)
select
new
{
p.Volume,
p.GrossSales,
p.NetSales,
p.COGS
};
I'm working on a piece of code at the moment that allows the user to enter values into fields. Once the user clicks on the 'save' button I am checking those fields against certain conditions (essentially calling a bunch of stored procedures to assess the values). If any of these 'rules' are met, I need to generate a popup that informs the user that certain values need to be fixed before they can continue for some of the conditions, and for others just to inform them of what conditions may need their attention.
The main thing I need help with is, how do I generate a popup box in my codebehind if the conditions are met?
We have an ASP.NET web service that invokes a stored procedure on our DB (Oracle 11g). The problem is that the call to the procedure blows up every time an empty string is passed as one of the parameters. We're seeing an ORA-01084 error, which indicates to me that call is failing before the procedure is actually run.
Here's the procedure, minus some logic that I believe is not relevant:
[Code]....
As an experiment, I modified the web service to pass null rather than an empty strings. When null is passed in, I see an error indicating "wrong number or types of arguments in call to 'CREATEREPORT."
I also tried passing DBNull.Value whenever the params were null/empty, but that resulted in the error
Parameter 'p_column_id': No size set for variable length data type: String.
(Of course, p_column_id was the empty parameter in this case).
So, how can I successfully pass empty strings as parameters to my stored procedure? We definitely want to allow the p_column_id parameter to be empty.
I have req where i have to pass null value,if value coming from db is null.Problem here is the field datatype is 'Decimal' so all the time even though value is null ,its passing as zero.How can I pass a null value to decimal field in C#.
FieldValue = (reader["Field"] ==
DBNull.Value) ?
Convert.ToDecimal(null) :
Convert.ToDecimal(reader["field"]);
What I want is ,Field value will get null value assigned not zero.
i have in grid view that grid view have very long string. when i export grid view export in excel it that string shows in single line
View 1 Repliesgot a wired problem (well I find it a wired problem :P)
I have an order page done in asp.net c#, and which a user adds ingredients to a set of list boxes, once the user and finished adding items, they get combined to make a sandwich then added to another list box that shows the sandwiches and their ingredients. I also have a button to allow the user to remove the ighlighted sandwich from the order, this all works fine until the page loads up with a query string that skips the adding of ingredients and just shows the sandwiches on a order, the listbox of sandwiches populates fine but I then get an error when the remove button is clicked which is
[Code]
I got a grid view, at certain cells, the data length is long, that it will display like 2 or more rows.
Some sort like multiple line in single cells in Excel.
How can I make the cell only a single line cell. I want the columns to be expandable instead of rows.