DataClasses1DataContext dc = new DataClasses1DataContext();
var q =
from a in dc.GetTable<Order>()
where a.CustomerID.StartsWith("A")
select a;
}
i have run this query but through using dataGridView1.DataSource = q;
i have get the out put
but i want to select each record through loop because i want to store it in variable
i have a website that needs to retrive some records in the database, to be specific, example is their Email Address, its more or less 10 records out of 100 records in a table but that number changes from time to time. upon retriving their Email Address, i need to Email them some messages one email at a time.
So to summarized it all:
1. Retrive data from a table (Email Address)
2. Make a Loop on each Email then send Message one email at a time.
give me a sample codes for the retriving and looping process?
I try to access to the fields of each single record in the table without writing the specific name of the field,
For example , checking each property of the record whether it's null or not,
something like that:
var myUser = from u in dataContext.Users
select u;
foreach (User item in myUser)
{
// Here I wand to access to the fields by their ordinal number.
}
is there any way I can retrieve the identity value (auto generated primary key value), of a column after inserting a new database record using linq to sql? i could i achieve this like this using stored procedure: //***insert some recor*** return @@identity. how do I achieve thesame with linq to sql
View 2 RepliesI am in a serious trouble right now, i wanted to know that how to write a query in LINQ to SQL to retrieve identity column's current value before inserting any value.
I need this cos i m building a windows app n i need to display this value before inserting a record. I have tried DataContext.ExecuteCommand('DBCC CHECKIDENT (Tablename)') but it returns the number of rows modified.
Not sure why this is messing with my brain so much today, but I have a SQLDataReader that loops through "Customer" records. In each loop there are MANY other conditions that need to be validated. When a condition fails I want it to move on to the next record in the reader. As you see from my code below, I have simply been exiting the for loop and then checking if I should run other loops all the way down. I want to simply move back to the top of the While Loop for another pass when something like this happens:
[Code]....
I am currently looping through all the controls on my page and setting certain types (TextBox, CheckBox, DropDownList, etc.) to Enabled=False under certain conditions. However I notice an obvious page load increase looping like this. Is it possible to only get certain types of controls from the Page.Controls object rather than Loop through them all? Possibly with something like LINQ?
View 3 Repliesforeach (GridViewRow row in gridView.Rows)
{ // Access the CheckBox
CheckBox cb = (CheckBox)row.FindControl("SuburbSelector");[code]....
I tried the following and got error
Linq:
var Str = SuburbGridView.Rows.Cast<GridViewRow>().Where(r=>(CheckBox)r.FindControl("SuburbSelector")==checked);
Error:
Delegate 'System.Func < System.Web.UI.WebControls.GridViewRow,int,bool>' does not take 1 arguments
this is my code
[code]....
basically, the InstellingGegevens table gest filled in by some procedure from another server.
the thing i then need to do is check if there are new records in this table, and fill in the new ones in Instellingens.
this code runs for like 4 minutes on 15k records. how do I optimize it? or is the only way a Stored Procedure?
this code runs in a timer, running every 6h. IF a stored procedure is best, how to I use that in a timer?
[code]....
[code]....
i am using asp.net and datagrid i want to show record on datagrid with 3 column but data will be unlimited i want to show record data into datagrid
my table name is user_detail and fields are User_name.Name,Passwordwell i m confussed i m using vb6 which i use recordset in replacement in asp.nety wht i use using access.
i cannot retrieve the new identity value from an inserted record(via DataAdapter.Update) in my DataRow.
I'm using a strong typed Dataset as DAL. The table i want to update is joinded with other tables in the SelectCommand, hence the designer cannot automatically generate the insert-/update-/delete-commands and also it cannot "Refresh the DataTable" automatically. [URL]
I've tried to set AutoIncrement=true/false on the primary-key's DataColumn but the result is the same: last MAX-ID+1 instead of the actual ID the database generated(SQL-Server 2005 EP; pk datatype:int, Is identity:yes, Identity Increment:1).
This will be the wrong value f.e if another instance of the application inserted a record that the first instance yet not knows and therefore generates an ID that already exists.
To retrieve the new identity from db i've appended following to my insert-command's CommandText:
;SELECT CAST (SCOPE_IDENTITY() AS int) AS newIdRMA
Also i've tried to add an Output-Parameter to it's parameter-collection:
This is part of my code that updates the database and sets the new ID(that doesn't work):
[code]...
I have a question about linq delete.
I have 2 table in database and they are joined.
First Table: UserID, UserName, UserSurname, UserPhone, CompanyId
Second Table: CompanyId, CompanyName
First Table I have many recods with related second table.
I want to delete one company in second record, But firtly I have to delete users (more than 1)
How can I delete it with using linq?
I want to retrieve the data from the last record of a table. For eg: I have sorted the data in my table and want the value from the last record? How can I do that?
Is there a way to check that "saving" data to a table was successful and then do something after that?
I want to be able to retrieve a record from the database and change it than update the record in the database with changes.
what's I am doing
1- select the record for the data base
2- on loading the form set the content of each component woth data (eg: textbox1.text = "content")
when I edit the value and submit the form
3- I get the changed text (changed = textbox1.text )
but it get the old text not the changed one
how to retrieve primary key field of the last inserted record?
My primary key is not IDENTITY
I'm using a detailsview control to update a record, however in this particular case there's only one field that can be changed out of a many. The update method for my object takes all fields as parameters. When the detailsview's updating method fires, the values for the readonly fields (those rendered as a Label) are not available in the e.NewValues collection.
I'm currently grabbing a reference to the object when the detailsview is databound (in the objectdatasource selected event handler), storing it in session and manually adding entries to the e.NewValues collection when updating fires. It works but seems kind of heavy handed. So, is there a better way to get the read only values back into my update method? Or is there a better way of doing this altogether?
i want update record of Photo table with linq to sql so i create a sproc for it
i dispaly records of Photo table into the Gridview untill when user click on the update command
can updating selected row in a set of textbox
how can i fetch Fields value of selected row for put in the textboxs and updating them?
how can i bind DDLCategory(dropdownlist) to CategoryDatasource(LINQdatasource) with coding?
i want when i select cotegory from DDLCategory ,gridview has been changed?
[Code]....
i have textbox1 and textbox2 and 8 checkboxes in my ASP.NET (VB.NET) webform. i want to retrieve the seats on the particular dates means if i enter 11/12/2010 in textbox1 then in textbox2 the output would be from seat_select column, let say (1,2,3) where date would be 11/12/2010 If i enter 13/12/2010 in textbox1 then in textbox2 the output would be 1,2
View 3 Replieshow to select the mac element value. Here is my code that not working.
[Code]....
I wish to retrieve data from a DataTable using Linq, and I do this by first creating a DataTable with the data and then using Linq to query:
[Code]....
My problem is, that the column "enddatee" has 'holes', meaning that some rows does not have a value. This means that the convertion to DateTime will fail for some rows. How can I get around that?
I want to get the customers info and companies of this companies of products they deal with here is my query in linq
var query = from sd in db.Survey_Details
select new
{[code]...
customer table has about 3000 customer who every one of them fill a survey of 2500 product till now survey_details table has about 90,000 recored an will increase by 100% every year this query run good without binding in RowDataBound when i want to work with RowDataBound this is too slow and data never come i think i may take about 5 hours to come
i have a link query that retrun all the records that have their status = 'completed' ordered by their ids, but i want to return only three records not all the records
View 2 RepliesHow can I retrieve the row ID immediately as I insert a new record with LINQ? I need to refer back to it to update the row since it will be the only unique data in this particular table ( it's the primary key and the ID number is auto generated)
View 3 RepliesI'm inserting data into a database with Linq to SQL and would like to access the primary key of that record WITHOUT doing a query for the values I've already captured.
Here is my insert startment:
[Code]....
There is a value in the table that is an auto increment integer.
Rather than doing a query for the pagetitle, description and content I'd like to just access the primary key that I would have just generated by performing the insert.
Is this possible or would I have to perform the query as I've just mentioned to retrieve it?
I have the following xml:
[Code]....
If I have an ID, I would like to retrieve the next item that also has the same category as the item ID I have. So, for example, if I have ID=2, I would like to return the item with ID=4 (as item ID=3 has a different category).