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:
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.
Let's say I have DropDownList ddlRooms bound to the datasource which returns list of available rooms from table tblRooms. On the other hand I have users, and their info is stored in table tblUsers. Using FormView frmUsers can be inserted, edited and updated... frmUsers is be bound to separate datasource. To each user, I would ilke to assign a room, so the value of txtUserRoom will be populated based on the selected value from ddlRooms. How can i pass the selected value of ddlRooms to txtUserRoom while keeping txtUserRoom stil bound to user datasource? Do I need two separate fileds or can i just put value of ddlRooms into datasource user?
I have a remarks column which allows null values.. When i try to load a selected row from gridview
Which has nothing in remarks..I get displayed in the textbox where i need to load the remarks.. I do not want to be displayed.. If nothing is there in that remarks column textbox should be blank.. How do i do this?
I have a form with a combination of dropdownlists and textboxes that I want to be able to show a user as a summary in another page before submitting to a sql server. Page 1 will have a verify button which will then pass the dropdown and text box info to page 2 where end users will be able to either submit the page or cancel the action. What's the best way to pass the values from page 1 to page 2?
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
I have a ajax Popup extender which contains a grid and when i select a row a value should pass into the textbox in the parent page. i created every thing but the value is posted in the textbox. The Grid is loaded perfectly and the popup shows but when i click the select command field inside the grid the popup disappers but the value is not loaded in the textbox. help me am struck up with this for a very long time.
I have a page, which contains 2 textboxes. When i click on the first textbox, i have to open a child window (tool), that contains a gridview control with 2 columns (corresponding to the 2 textboxes). When the user clicks on any row in the gridview, it should send back the 2 column values back to the parent window to the corresponding 2 textboxes. how do i achieve this?
I 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?
function LogInUser() { var LoginName = document.getElementById("<%=txt_LoginName.ClientId %>").value; var Password = document.getElementById("<%=txt_Password.ClientId%>").value;
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
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.
How do I pass a dataset object to a stored procedure? The dataset comprises multiple tables and I'll need to be able to access them from within the SQL.
I have 3 parameters say A,B,C. I want that when I select values in A and B only then C comes alive. I am using cascading parameter in SSRS 2005.
I know that in cascading parameters, one parameters passes a value to other one and it comes alive. But I want that 2 parameters pass the value to a single one.
dont say to use multi select as multi select is used only when we have to multi select from one parameter.
Also one thing how can I use radio buttons in SSRS 2005 and how to hide null checkbox when allowing null values in calender control.
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 };
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#.
i wanted to store image in sqlserver database image field and i did. But now in some cases i want to store null value in that image field how to do this using file uploader.
got 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
