I have an entitydatasoruce that is driving a gridview. I have a WHERE parameter that i want to include 2 default values (example Work_Area = 1 OR 2)But it seems I can not input this query when making a querystring within the expression editor
<asp:EntityDataSource
ID="RequestQueueEntityDataSource"
runat="server"
ConnectionString="name=tranreqEntities"
DefaultContainerName="tranreqEntities"
[code]...
I am trying to program the where prameters for this in code behind in C#, and is there really no way to do more than one parameter? Or am I not understanding this correctly? It seems only the 2nd parameter gets executed, no matter which one is at begining. I debug and seems they both get executed fine, but my listview doesn't get filtered and instead only the 2nd paramter works. Look at my code:
Also, if I do myLinq.Where = "division ==1 and someotherInt = 2", it works fine, but if I do two different data types, it will throw error. Since I want to filter with two different data types, hwo do I do this?
Parameter pram1 = new Parameter();
pram1.Name = "division";
pram1.DbType = DbType.Int32;
[code]...
There is likely an easy solution to this problem, but I'm stalling on it.Problem:Using EntityDatasource with a where="filed_id = @xxxx" the parameter is tied to a dropdownlist and works fine except I want to be able to select all records or basically no where condition. Is there a some way to do this without going to code behind?
View 2 RepliesI have an EntityDatasource that is bound to several TextBoxes used for querying (filtering) data in a ListView. The problem I am having is getting a DateTime to work. I just want to ignore the time portion of the variable and only look at the Date portion. Here is the markup I am using to generate the where clause. Does anyone know how to force it to just "drop" the time in the comparison?
<asp:EntityDataSource
ID="EDSCalls"
runat="server"
ConnectionString="name=CSMSEntities"
DefaultContainerName="CSMSEntities"
[code]...
While debugging my Javascript, I've noticed that ComboBoxes always have an empty string as their defaultValue (as opposed to the actual original value). This is making it impossible to write even a semi-reliable client side script to check if a form has been filled out and warn the user if they attempt to navigate to another page or close the window.
View 5 RepliesI have an SQL table with a smalldatetime column. The Default Value is set to (getdate()), as I want it to insert the date in which the record is inserted. Null values are not allowed.In my corresponding Table Adapter in Visual Studio 2010, when I select that column and view Properties, under DefaultValue it has <DBNull>. If I try to change this to GetDate(), it won't let me.What's the proper way to do this?I am getting the Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.error when I try to execute a Table Adapter query that simply tries to return all the rows.
View 5 RepliesI'm working with Linq and I'm using with ObjectDataSource that have SelectParameters tag for inserting default parameters to object.
How can I set <DefaultValue> for an array parameter ?? (i.e : object that have 2 parameters - string and array of int , I can set <DefaultValue> for the string but I don't know how to do it for array)
I an expanding on the HotGridView control (http://msdn.microsoft.com/en-us/magazine/cc163612.aspx). During testing I noticed the "AutoGenerateCheckBoxColumn" behavior was returning true even if the user did not specify the a value in the markup but I expect it to return False if not value is supplied by the user - can anyone shed some light on why the AutoGenerateCheckBoxColumn is always true if not explicitly set to False in the markup?
[Code]....
I would like to know why somethimes DefaultValue in properties window is displayed in bold text and somethimes in normal weight text? What i know is that the Value in Properties Window should display bold only if the Value is different than DefaultValue.
So i have a situation, where i need to set DefaultValue's and i'm successfully setting the boolean Value but failing in Integer value...
aspx:
[Code]....
Now the reason why i'm using Int32 in this example is that i hovered the mouse over the DefaultValue and it's said that "represents a 32-bit signed integer" but still no luck.
Why is my StepHour displayed bold and how to display this DefaultValue in regular weight text?
below written question :
1.) What is the name of the OS process in which App Domain resides.
2.)if suppose There are Three Windows application hosted on a same envoirment and two instance is working for each application at a Time, means now total instance are six .what will happen among the below written cases :
a.) There will be six different app domain in a single OS process
b.) There will three app domain(one for each application) in a single OS process and some Parallel thread will be executed in each app domain for another instance.
c.) There will be Three OS process corresponding to each application.
3.) If eveything will remain same except there are three web application in place of windows in point 2, will there be any change in functioning.
The gist of the problem is that we have an alumni table (one record per person) and also a couple of other tables (one to many) that have degree info and interest info. In a search screen in our app you can search for criteria that spans all three tables (there are actually more fields and tables than shown in the example below but I am trying to keep it simple).
The code below works (properly returns people without degrees for example) but still feels a little clunky or over-engineered to me. Are there easier ways to do this? NOTE: I have been through quite a few iterations/approaches to making the correct data be returned.
[code]....
I have an inventory page with a gridview that shows 1 item per record, each item starts with a checkbox in the gridview. Currently users can select multiple records and hit the order button and everything has worked well. Now I have multiple pages in my gridview, and if a user selects a few records from the first page, and then goes to the second page, all the records (checked checkboxes) disappear from the first page.
[Code]....
I am able to export multiple gridviews in a single excel worksheet
My question is can I separate these gridviews in multiple tabs under the same excel file ?
This is my current method under the link button
[Code]....
I have a page with two gridviews and I want to export the gridviews content to excel in two separate sheets. How is it achieved?
View 1 Replies I create reports sometimes with a gridview and export the data to excel. Lets say I have like multiple gridviews and I wanted to export each gridview to excel under its own spreadsheet.
So gridview1, gridview2, gridview3 are exported to excel under $heet1, $heet2, $heet3.
I know how to export multiple gridviews to 1 excel sheet but I don't know how to export them separately under their own spreadsheet.
I've been researching online, and i'm continously searching, but does anyone know how to do what i'm trying to do with the gridview and excel or is this not possible?
My requirement/concern is to test web application locally in multiple browsers with various versions.
If any tool is available, please let me know..
I am not able to find the projects related to working with excel sheets by using ClosedXML to refer. I have an excel book which contains two sheets.
In sheet 01: In column A: In B: In C:
Student name01 Student's phone number blabla
Student name02 Student's phone number blabla
Student name03 Student's phone number blabla
In sheet 02: In column A: In B: In C:
course name01 computerscience blabla
course name02 dhfsthshbstgs blabla
course name03 garsfghsefrgs blabla
now, I would like to see in two comboboxes (all the words/text presented in the column A) from two sheets, the student name and course name and then I want select any student name and course name of my choice. Afterwards, when I click on a button, my program should display the students phone number and the course name (from column B from both sheets) and related things present in the Column C D E.. of the selected things in combobox in a label or a in a textbox.
PS: I solved the following problem: I can select student name in one combobox and print the the corresponding data from the only one column B (but I worked only with one sheet). It is bit complicated for me to continue with two sheets.
I was in need of exporting multiple tables in a DataSet to an Excel file with multiple sheets. I found a very good article in [URL].[URL] was able to successfully export each of my datatables in the dataset to excel worksheets. This solution worked for small number of rows. But when the data got larger I am consistently getting the system.outofmemoryexception. THis is because the code is using up the memory when creating excel.
Does anyone have another option to do the above?
i have multiple tables .
I have created one stored procedure where I am selecting the table values.
like
[code]....
I am using LINQ to retrieve the Data. So Using Linq I am calling the stored procedure.
So I ll get the table values in the C# Code the table values.
so in my UI i have 4 gridviews.
I want split the output values into four source and bind it to the grid.
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
I am listing about 20 rows, each row represents an Order.Each row needs to have 3 buttons, each button click will perform a different action.I have 3 actions to handle each button post request, I am just unsure how to setup the Html forms for each button.
<tr>
<td>
<form method="post" action="/orders/do1"><input type=button ... /></form>
<form method="post" action="/orders/do2"><input type=button ... /></form> [code]....
Should I create 3 forms for each button, per row in my listing?(that would mean 20 rows x 3 forms = 60 forms on a page)Is that 'ok' to do? (i.e. or is there a better way to do this?)
Would it be better to have a sp return multiple result sets and use NextResult() or have subsequent call to dr.execute.... () and hadle one result at a time?
To me using nextResult() on a multiresult datareader would be cleaner and easier - but it does not seem to be very "atomized". I guess I am wondering can the cost of executing multiple commands be neglected? Seems like executing multiple commands and receiving a single result set would also be easier to read/test/understand.
I have used multiple grid view on same page with multiple selectedindexchanged event but selected indexchanged event call only for first gridview.
View 1 RepliesI have been trying to export multiple div tags with data to MS Excel using multiple spreadsheets.
Below is an example of what I have used, but it only exports one div data.
Response.ContentType =
"application/force-download"
Response.AddHeader(
"content-disposition", "attachment; filename=testxml.xls"
[Code].....
I want search with multiple names in Name coloumn. example I have pass the criteria to Name cloumn is 'Atul', 'Mayur', 'Suraj' this three names how to pass in a query.
View 1 Replies
