Is there a way to list on the fly all fields in object context? in entity framework?
for example in my Log (object context) i have fields LogId, Name, CreateDate
I would like to loop through these dynamically and assign values. This would be useful when my current context changes to another table I would be doing this:
[code]....
I have a relatively complex dataset (numerous tables, some with multiple records) generated from reading in an XML file. I need to connect said dataset fields to an ASP form. At the moment I'm assigning them manually, like so in the pageload:
txt_first_init.Text = formData.ds.Tables["phrmHdrKey"].Rows[0]["first_init"].ToString();
txt_last_name.Text = formData.ds.Tables["phrmHdrKey"].Rows[0]["last_name"].ToString();
ddl_pregnancy_flag.SelectedValue = formData.ds.Tables["pPhrm"].Rows[0]["pregnancy_flag"].ToString();
And conversely when it's time to submit.
formData.ds.Tables["phrmHdrKey"].Rows[0]["first_init"] = txt_first_init.Text;
formData.ds.Tables["phrmHdrKey"].Rows[0]["last_name"] = txt_last_name.Text;
formData.ds.Tables["pPhrm"].Rows[0]["pregnancy_flag"] = ddl_pregnancy_flag.SelectedValue.ToString();
I did some looking into binding the textboxes (and dropdownlists, and checkboxes, and and and...) directly, but it seemed to be too many formats to use.
So this works fine, but as the number of fields increases, those load and unload lists are going to get unwieldy.
I'm creating an quiz application which queries the database and extracts the questions and choices. I use dynamically created controls such as a checkbox list and fill the values dynamically. How do I do this? Right now I have these functions:
array_random_init(); this creates a 10 element integer array from 1-20 - extract_question(i): this extracts a question indexed at i in DB, I created the controls and set the appropriate text in this function. - validate_question(i); this is called by button_click and validates the question i according to DB.
I understand I have to recreate the controls in Page_init on postback, but what should it look like? Do I need to add "if IsPostBack" in page_init, or do I create the controls in page_init() and reset their properties in page_load when I use extract_question(i)? Also, I cannot seem to clear the selected boxes on postback, I added page directive "enableviewstate=false" but it doesn't work.
I have created DetailsView in designer page with SqlDataSource, Details view is with autoGenerateRows="false" i.e. I have declared my own fields. it is fine there, but what if I want to add these fields dynamically from codebehind with select & edit commands. I want to to use Details View in designer page and want to add fields from codebehind
View 1 RepliesI dont understand how to bind grid view fields dynamically..
whenever user send question then i directly bind that
but whenever same user share their images then i want to bind that images into same grid...
so what can i do for that...??
I have a working gridView/DetailsView used as a member Lookup.
Some Fields in the Details View have data only some of the time, and when there isn't any, I want to suppress that row of the detail. No Go.
It seems that some of the function available in other controls don't exist so I cannot make the "field and its "header" Visible = "False"
FWIW, The control is nested inside a loginview control.
[Code]....
When I try and put logiin the control the error I get is:
Error 156 Literal content ('<asp:TemplateField ItemStyle-Wrap="false" HeaderText="PO Box:" Visible="') is not allowed within a 'System.Web.UI.WebControls.DataControlFieldCollection'. C:UsersBillDocumentsMy Web SitesNausetNewcomersMembershipCopy of Lookup.aspx 345
Have been trying to update some key fields but cannot get it working. I have the form working fine updating non key fields. I found some old threads on similar topics but none answering my question. I am using a FormView and a sqlDataSource
Question: What steps do I need to take to update key fields using a formview and a sqldatasource?
Additional Information: I have tried the following
Adding OldValuesParameterFormatString="old_{0}" to sqldatasource Adding to update parameters the old_myfield reference Adding DataKeyNames to the formview (note all key fields are in datakeynames and I only want to update the one)also when using the asp parameters do they need to be in same order as query and repeated as many time as used? Or just the same order as first referenced i.e. only defined once? Or any order?
I've been using the FilterExpression for the building of my GridView. I've built with this ability before, normally for searching for the name of an individual. However, the new project I'm working on has a small problem. I'm using an AND statement to filter the name via textbox and I'm also checking if the form was completely finished and if the form is reviewed via radio buttons.
Below is the code, but the problem is this. If any of the fields are blank (text field is left blank or the "both" is selected from the radio buttons) the form doesn't process my filter.
Is there an easy way to apply all three filters in a mix and match fashion (like no name, completed, not reviewed or any combination thereof)?
[Code]....
How do I check if my value is empty AND Isnull? I need to check for both, using ISNULL is not enough because the data can change just so that it is empty.
how I can change my query to accommodate this?
[Code]....
I have an SQL datasource that successfully enters customer details into a table. What it includes is the persons address. First of all we add the persons address, then we add the persons name to that address in a seperate physical procedure. i.e. on a different form.
What I need to do is try and stop users entering the same address twice. The way I have thought of doing this is by making a string field called AddressIdentity and have this contain the door number and the postcode of the address with all the spaces stripped out. Then when adding the address, it checks if this exists before adding it. However I cannot work out how to put the 2 fields together without using the codebehind file, which I don't mind doing if I need to, but I'm sure its avoidable.
Here is my code - I have only included the relevant parts:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo)"
<InsertParameters>[code]......
So how do I do it? I was trying:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo], [AddressIdentity]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo, @Postcode + @DoorNo)"
but of course AddressIdentity is a string. Do I use ' ' marks with an & sign? Or can't I do this?? Maybe I need to use the codebehind anyway to see if the field exists before inserting it?
ive a DB in access with a single table and no primary key, actually i dont need a primary key but i can consider a date field plus another to make an index. however i want to add a counter field based on every change of date field, for instance ill have many records of 20/May and all must have the same id then when the date is different, the next group of records with that new date must show 2 etc.. is it a quick way to update my database?
View 6 RepliesAt first, I had my datalist being populated by my class 'PM' - I did it all inside the Page_Load event. Since there was a dataset being returned, I could assign different variables to fields in the Datatable, like:
[Code]....
Now, for reasons I won't go into here, I'm changing to an ObjectDataSource, using the same method to do the 'Select' of data... How can I do the same variable assigning, with the ObjectDataSource?
I have created a .edmx for the northwind database. When I run the following statement, the correct number of detail records are retrieved and I can access the detail fields, but how do I access the order header record to view OrderDate, ShipAddress, etc...?
[Code]....
I have a situation where I have a file with each Account Record contains Monthly Expense Total Fields and Monthly Budget Fields for 2009, 2008 and 2007. I'm working with 72 fields (36 Expense and 36 Budget).
Need to create New Year Proceure that will shift data from 2008 to 2007, 2009 to 2008 and move Zeros to 2009 for both Expenses and Budgets.
I can do this using Parameters and Update SQL but I am under the impression that I must specificaly name each field in defining Parameters and SQL Update Command.
Since all fields are sequential withing a record, is there a way that I can use a For/Next loop to index my way through the fields moving data from one year to another?
When using DataReader I'm able to use reader.item(index) to access data record fields.
I would like to use a command parameter to concatonate two fields
protected void Notes0_Inserting(object sender, SqlDataSourceCommandEventArgs e)
{
e.Command.Parameters["Comments"].Value = Eval("LeadID")&" "&Eval("TextBox1");
}
Where the leadID is based on a query string and comments are entered in textbox1
[Code]....
Does anyone have any ideas on this? I have 20 parameters.
I have time card data collected onto an AS400, and have an establed TimeReview.aspx which allows the user to review Time In/Out, etc. I have a request to add some way for managers to review the time and add corrections. I cannot edit direct or add fields to the time table in the AS400. I do, however, have a SQL Server that I could use to collect this information, but I'm not sure of the best way to go about it.
Here's an example of what the table should look like, with the added fields on the right. "X" (Revise) would be a checkbok indicating that this line should be revised. An administrative staff member would pull up the report the next day and manuall edit the time within the AS400.
-- From AS400 table -- -- SQL table --
Time Card info - Empl ID | WO | Date In | Time In | Date Out | Time Out | ---- X (Revise) | Corrected Time In | Correct Time Out
My thought is use an Empl ID field in the SQL table and bind it to the AS400 Empl ID field (not sure how).
I am working on an application and am attempting to use Linq with and ObjectDataSource but I only want to display/update 50% of the fields that are in the corresponding table. It appears to me that for this to work correctly, I need hidden fields on my form for all of the data fields from the table that the user cannot access. Is this the only way to do this? I have the following in my update method of my ODS:
[Code]....
The problem is, only the fields that appear on the form have data in them.
I currently have a numeric field as numeric(5,2) which has 2 digits after the decimal. Now I need to be able to display 4 digits after the decimal. But if I change the field to (7,4) then it places 2 zeros after the last numbers. For example: 1.32 changes to 1.3200.
But some records will have exactly 4 numbers after the decimal such as : 2.4375.
My issue is I don't want all the data to have 4 numbers after the decimal. I don't think there is another data type that will allow this.
I am trying to use Linq to Entities with the Linq.Dynamic library (via Scott Guthrie) and I'm having some strange issues with querying dates.
[Code]....
This return no results, when it definitely should...
I have a method in my button code to run the query, it returns a value and save it to a Session variable to be used later, this code works.Dim connString As String = ConfigurationManager.ConnectionStrings("DBConnectionString").ConnectionStringUsing myConnection As New SqlConnection(connString)
Const sql As String = "SELECT Rate1 FROM Rates WHERE (LayerID = '01')"
Dim myCommand As New SqlCommand(sql, myConnection)
myConnection.Open()
[code]...
I have a gridview that is populating from a SQL DB and working fine. However, based upon certain data I find in fields in the SQL table, I want to place a 'n' or a 'y' in extra columns in the gridview that I am assuming need to be templatefields. My thought was I could maybe add 8 template columns and then I could put a 'y' in the appropriate column based upon the data I find the table. For the life of me, I cannot figure out how to do this. I want to do this at rowdatabound time ( i think) but I just cannot find out how to, in my code, put that 'y' in the columns. Is this the right way to do this or do I need to do it another way? How do I get that 'y' in the proper column?
View 3 Repliesi am developing an application using ASP.NET with C#.Net and SQL SERVER 2005. here i am importing data from excel sheet to database.in my excel sheet some fields have large data.and for those fields i had taken NTEXT as data type in my database.when i am trying to import the data,the fields which have large text are not inserted completly.i.e some data is missing. the field in database accepts the data upto some characters only.what would be the reason for this? and which data type can i use for inserting large data?
View 8 RepliesI want to insert username and password into two tables (say table1 as well as table 2) using stored procedure.
View 4 RepliesI have seen it on here or while googling, but never had a need for it with any projects, now i have a form that has 32 fields, PLUS up to 32 other possible fields.. Not sure how to go about this.. i dont think that having a form with 64 fields is the best solution as you may just need the first 32, but here is my attempt to explain it. I have a page which will gather configuration information, one of the things about this configuration is that you have a 1 to many relation with cameras.
So you have your set configuration for a location, but that location can have up to 32 possible cameras associated with it. But of course you may have just have one camara, so of course you would only need to add 1 new field. Any links to adding dynamic fields would be great.. the other thing is if fields are added dynamically, how to handle that in the insertign of the data into the database, since we wont know how many fields there will be until they hit the submit button.