DataSource Controls :: Ienumerable For Dropdown - Loop Through The Values Coming From Function?

Feb 8, 2010

Here is my code, using LinQ to get the data from database.

public IEnumerable categoryData()
{
db = new DBModelDataContext();
var cat = from c in db.Categories
select new { c.categoryname,c.categoryid };
return cat;
}

trying to get the values (categoryname and categoryid) into textfiled and valuefield of dropdown list.

dt = new clsData();
ddlCategory.DataSource = dt.categoryData();

what is the code that i need to write to assign the categoryname to textfield and categoryid to valuefield. I mean how to loop through the values coming from the above function.

ddlCategory.DataBind();

View 2 Replies


Similar Messages:

DataSource Controls :: How To Read Data Values Of A Table Using Loop In Sqlserver

Feb 10, 2010

I am using vs2008, Sqlserver2008.

my table: PostGL having data like thi

AutoIdx TxDate Id AccountLink Description Debit Credit
3 2010-01-22 JL 2 bcb 0 35.09
5 2010-01-28 JL 2 g 3.51 0

select AutoIdx,TxDate,Id,AccountLink,Description,Debit,Credit,(Debit-Credit) as Actual from PostGL where Id='JL' and AccountLink=2

AutoIdx TxDate Id AccountLink Description Debit Credit Actual
3 2010-01-22 JL 2 bcb 0 35.09 -35.09
5 2010-01-28 JL 2 g 3.51 0 3.51

I am trying in view like this

declare @cnt int
declare @i int
set @budget=20
set @cnt= (select COUNT(*) from PostGL where AccountLink=2 )
set @i=1
WHILE (@i<=@cnt )
BEGIN
set @tdebit=??

END

I am taking count the no of rows having AccountLink=2
I need to read all debit,credit and add all debit into totaldebit,all credit into totalcredit independently from table.
then i need to show the totaldiff as Actual.
i need ....totaldiff=totaldebit-totalcredit

View 3 Replies

DataSource Controls :: Convert An Ienumerable To A Datatable() VB.net?

May 24, 2010

I am having trouble converting a ienumerable to a datatabe here is the code:The problem is in the following line-

ViewState("dt") = elements.CopyToDataTable()
Dim dt As New DataTable
Private Sub DisplayAuthorLastName(ByVal strLetter As String)

[code]...

View 7 Replies

DataSource Controls :: Linq To SQL Does Not Implement System.Collections.IEnumerable?

Oct 21, 2010

I am having a lot of the same issue as this poster did with errors on initializing type.

I am trying to learn linq and am about ready to give up - don't get how this is easier...

I'm trying to do a simple update to product names in the product table based on the manufacturer ID

In order to do this I am looping through each record. I was initally successful with changing all names in the column but when I try to query the data, I continually run into multiple problems.

The following poster has had the same issue I have but his solution isn't working for me.

[URL]

I keep getting the same error on the opening bracket on the select statement in the SelectByManufacturerID function...

Error 1 Cannot initialize type 'DataBaseDataManagement.ProductName' with a collection initializer because it does not implement 'System.Collections.IEnumerable'

Button that does the actual updating...

[Code]....

The function that the button calls to get the query... ERROR

[Code]....

The class located in Query.cs...

[Code]....

View 3 Replies

DataSource Controls :: Convert Linq Query Into IEnumerable DataRows?

May 19, 2010

IEnumerable<DataRow> query = (from obj1 in objeDC.tmpPolicyRenewals.AsEnumerable()
where obj1.AgentCode == "Admin"
select new
{
obj1.Product,
obj1.PolicyNo,
obj1.Insured,
obj1.EffDate,
obj1.ExpDate,
obj1.GrossPrem,
obj1.Status
}) as IEnumerable<DataRow>;

Getting null value. whats error ?

View 2 Replies

Forms Data Controls :: How To Accept An 'object' As A Datasource (IEnumerable Or IList)

Nov 19, 2010

How do I accept an 'object' as a Datasource (IEnumerable or IList) and loop through the keys/values? I want to be able to pass anything that implements either IEnumerable or IList.

This same functionality exists on all of the .Net DataBound controls and I'm trying to figure out how it's done.

[Code]....

View 6 Replies

DataSource Controls :: Delete The Rows Present In The DataTable From IEnumerable DataRow

Jul 22, 2010

I want to delete the rows present in the DataTable by using LINQ (with out looping)

The deleted rows will be come from a LINQ as below

IEnumerable<DataRow> MobileQuery = (from d in dtBillDetail.AsEnumerable()
where (String.Compare(d.Field<string>("Destination"), "MOBILE", StringComparison.InvariantCultureIgnoreCase) == 0) select d );

The DataRows present in the "MobileQuery" should be deleted in the DataTable "dtBillDetail"

View 1 Replies

Using The IEnumerable Function Intersect() To Combine A Few List And Get The Similar Integers?

Jun 2, 2010

I would like to use the IEnumerable function Intersect() to combine a few list and get the similar integers from each list. The problem I'm faced with is that I don't know how many list I will need to compare.

Here is an example:

A{1,2,3,4}
B{1,2,3}
C{1,2}

results = A.Intersect(B).Intersect(C)

This works great, but the next time around I may have a D{1,2} next time I come across the function.

I'd like to use the Intersect method, but I'm open to new ideas as well.

View 1 Replies

DataSource Controls :: Data Source Is An Invalid Type Must Be Either An IListSource, IEnumerable, Or IDataSource?

Nov 9, 2010

I created one stored procedure.

/*
SP Name :sp_Par_SearchCourseFinder
Author :Mr.Ravichandran

[code]...

View 1 Replies

DataSource Controls :: How To Get The User Tha Have Birthday In The 7 Coming Days

Apr 20, 2010

In my user table i have birthdate fielI want get the user tha have birthday in the 7 coming days.

[Code]....

View 5 Replies

DataSource Controls :: Grab The Value Coming From The Output Parameter?

Mar 2, 2010

My stored procedure requires an input parameter -- @CompanyName -- and has one output parameter - @CompanyID. This is how I always handled stored procedures that did NOT use output parameters. How do I grab the value coming from the output parameter?

[Code]....

View 14 Replies

Visual Studio :: Retrieving Values Using Ienumerable Interface

Feb 25, 2010

I have been founding an effiecent way to retreive values returned by LINQ 2 SQL stored procdure on my presentaion layer. Am using following method rightnow:-

public List<String> MthInvitesBA()
{
List<String> lst = new List<string> { "" };
ISingleResult<USP_Actor_View_InvitesDetails1Result> invites = obj.USP_Actor_View_InvitesDetails1(p_UserName);
foreach (USP_Actor_View_InvitesDetails1Result c in invites)
{
lst = new List<string> { c.Invites_Used.ToString(), c.NoOfDoc.ToString(), c.Request_For_More_Invites.ToString() };
return lst;
}
return lst;
}

It works but at the cost of my performence due boxing unboxing on BA layer as well as on design layer. Now, I have one method which returns me 100 columns from table So in this way i have convert 100 coulmns value into type string then On design layer again have to type caste some values .Moreover, i could only access this list using index which is of type integer, which is very diffcult and tedious task to debug d code. i could effiecenlt retreive these values. Is it possible using IEnumerable? How to access Ienuemerable in design layer?

View 1 Replies

DataSource Controls :: Doing A Data Base Lookup - Where Is The Nvarchar Size Of 4000 Coming From

Feb 18, 2011

I want to grab some values with a form and then do a lookup via a datareader in a data access class (N-Tier).

I want to return a data list and bind that to a form view control.

Here is some code from the DAL, Business object and search form.

The parameterized query doesn't like the data being passed to it from my web page .

[code]....

[Code]....

Where is the nvarchar size of 4000 coming from ?

View 9 Replies

How To Loop The Server Controls And Clearing Values

Jan 4, 2010

I have some server controls both textboxes and drop down list box's that I placed on a panel control. My question is I would like to loop through the controls textboxes and drop down list and clear all values.

View 9 Replies

Forms Data Controls :: How To Handle Null Values In While Loop

Apr 16, 2010

i am unable to handle null values in while .even i tried to handle condition is breaking and coming null value comming inside loop.

[code]....

View 3 Replies

DataSource Controls :: How To Use Cursor In Recursive Sql Function (scalar-value Function)

Apr 25, 2010

how can i use cursor in this function ?

ALTER FUNCTION [dbo].[GetCatIDChilds]

(

@CatID [code].....

View 1 Replies

Forms Data Controls :: How To Loop Through The Check Box List For All True Values

Sep 13, 2010

How can I make the following code shorter and more efficient.

I want to loop through the check box list for all true values.

I want to get the check list item and complare with database value then check the box.

[code]....

View 4 Replies

Forms Data Controls :: Get Values From Dynamic Fields In A For Loop - Autopostback And Comparing

Jan 31, 2011

I am dealing with dynamic fields in a for loop and now I need to retrieve the values that are being typed in the dynamic fields, any idea how can I do that? 2)also when I click the submit button, upon postback, the dynamic fields have gone missing, have been trying to slove that, but i did not, anyone knows how to deal with this? kinda urgent :x

3) and How do you compare the 2 dynamic fields? For eg: Im comparing the tbSch[i] to tbSch[i], so that the dates cannot be the same, am using a compare validator, but it throws me error that im comparing the same fields :) even though i change to ("tbSch" + i) for both, sorry Will provide my code snippet as follow :D tbNum is a textbox where user enter numbers and click generate

protected void btnGen_Click(object sender, EventArgs e)
{
for (int i = 0; i < Convert.ToInt32(tbNum.Text); i++)
{
// label and textbox needed
Label lblSch = new Label();
TextBox tbSch = new TextBox();
Label lblWsGrp = new Label();
DropDownList ddlWsGrp = new DropDownList();
CompareValidator cvSame = new CompareValidator();
cvSame.ID = "cvSame" + i;
cvSame.ErrorMessage = "Date cannot be the same";
cvSame.Operator = ValidationCompareOperator.NotEqual;
cvSame.Type = ValidationDataType.Date;
cvSame.Display = ValidatorDisplay.Dynamic;
cvSame.EnableViewState = true;
cvSame.ControlToValidate = (tbSch.ID);<<<<< what should be the value in here?
cvSame.ControlToCompare = (tbSch.ID);<<<<<<<<<< and here?
//schdule date
lblSch.ID = "lblSch" + i;
lblSch.Text = "Session Date : ";
lblSch.EnableViewState = true;
tbSch.ID = "tbSch" + i;
tbSch.Width = 210;
tbSch.Height = 27;
tbSch.EnableViewState = true;
//workshop grp
lblWsGrp.ID = "lblwsgrp" + i;
lblWsGrp.Text = "Workshop Group : ";
lblWsGrp.EnableViewState = true;
ddlWsGrp.ID = "ddlWsGrp" + i;
ddlWsGrp.Height = 27;
ddlWsGrp.Width = 210;
ddlWsGrp.EnableViewState = true;
ddlWsGrp.Items.Add("1");
ddlWsGrp.Items.Add("2");
//table to store data
TableRow trow = new TableRow();
TableRow trow2 = new TableRow();
//row1
TableCell tc1 = new TableCell();
TableCell tc2 = new TableCell();
TableCell tc3 = new TableCell();
TableCell tc4 = new TableCell();
//row2
TableCell tc5 = new TableCell();
TableCell tc6 = new TableCell();
TableCell tc7 = new TableCell();
TableCell tc8 = new TableCell();
TableCelltc9 = new TableCell();
tc1.Controls.Add(lblSch);
tc2.Controls.Add(tbSch);
tc3.Controls.Add(lblWsGrp);
tc4.Controls.Add(ddlWsGrp);
tc5.Controls.Add(space);
tc6.Controls.Add(CeSess);
tc7.Controls.Add(space);
tc8.Controls.Add(space);
tc9.Controls.Add(cvSame)
trow.Cells.Add(tc1);
trow.Cells.Add(tc2);
trow.Cells.Add(tc3);
trow.Cells.Add(tc4);
trow2.Cells.Add(tc5);
trow2.Cells.Add(tc6);
trow2.Cells.Add(tc7);
trow2.Cells.Add(tc8);
trow2.Cells.Add(t9);
this.table3.Rows.Add(trow);
this.table3.Rows.Add(trow2);
}
}

View 11 Replies

DataSource Controls :: Loop Through Reader Using VB?

Jan 7, 2010

how I can loop through the results in VB, I only ever seem to get the last row, I would like to list all rows.

My code is below

[Code]....

View 3 Replies

Web Forms :: Add Data Value By Loop In Dropdown In C#?

Oct 29, 2010

how can add data value by loop in dropdown reply me soon

View 2 Replies

DataSource Controls :: Loop Through The Records Of A Table?

Mar 19, 2010

im learning t-sql, infact i needed its while-loop to loop through records of a table, i found this code in some book:

[Code]....

i understand here that setting the rowcount variable to 1 will force the select statements to return only one record, do all above select statements return one record only?

if the underlined select statement returns one record everytime it is executed, isn't it supposed to return the same first record of the table everytime? is there a better way to loop through a table's records?

View 9 Replies

DataSource Controls :: How To Add New Rows To Datatable Using Loop

Feb 26, 2010

iam working with gridview in asp.net3.5,Sqlserver2008 I am retrieving data from a SP into a datatable.i need to store this table into gridview. but am getting the last row from my datatable into my gridview.

here i need to add each row to the datatable.

my grid is like this:

[Code]....

View 5 Replies

DataSource Controls :: Datareader - Loop Through Results In VB?

Feb 1, 2010

I would like to loop through my result set and generate a menu structure like this:

pagetitle
pagetitle
subtitle
subtitle
pagetitle
pagetitle

So far I have the following code but it doesn't generate the menu?

While reader.Read()
' set title
sitetitle = reader.Item("siteName")
mydata &= reader.Item("pagetitle")
' check subtitle exists, if so, build menu, loop though subtitles somehow?
if not IsDBNull(reader.Item("subtitle"))
mydata = "<ul>"
mydata &= "<li>" & reader.Item("subtitle") & "</li>"
mydata &= "</ul>"
end if
End while

Qeury and result set below:

sql:

SELECT subpages.subpageid, pages.pageid, sites.sitename, sites.siteid, pages.siteid,pages.pagetitle, subPages.subtitle FROM pages LEFT JOIN sites ON pages.siteid = sites.siteid LEFT JOIN subpages ON subpages.subpageid= pages.pageid WHERE sites.siteID = 1 ORDER BY sites.siteid, pages.pageid, subpages.subpageid ASC

results:

subpageid | pageid | siteid | siteid | pagetitle | subtitle
NULL 1 SCHS 1 1 Sandwell Community Healthcare Services NULL
NULL 2 SCHS 1 1 About Us NULL
NULL 3 SCHS 1 1 Your Services NULL
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 1111
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 2222
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 333
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 44444
NULL 5 SCHS 1 1 Single Equality Scheme NULL
NULL 6 SCHS 1 1 Diversity Strands NULL
NULL 7 SCHS 1 1 Equality Impact Assessments NULL
NULL 8 SCHS 1 1 Quality and Safety Committee NULL
NULL 9 SCHS 1 1 Contact Us NULL

View 5 Replies

Web Forms :: How To Loop Through Dropdown List Items

May 12, 2010

I want to loop thru dropdown list and check the individual list item text using C#, let me know what is the best way to do this?

View 4 Replies

Web Forms :: Use Loop To Controll The Value In Dropdown List?

Sep 7, 2010

I have dropdown list I want to use the arror to click and control and select the value in the dropdown box , the first click select item1 .... How can I do that?

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved