C# Allowing user to select variables to use in a foreach loop

Hi.

Everytime I want set a datasource (also if I create a new one with an click on the drop down) I got the following error message from the container.

TITLE: For each schema rowset
------------------------------

The new connection, LocalHost.ReportServer, is not an OLE DB connection so it can not be used by the schema rowset enumerator and, therefore, will not be added to the connections list.

But if I generate a OLE DB connection manually it does not appear in the dropdown list of the container. Does anybody know what I have to do in that case?

Thanks, Nils

I'm trying to figure out how to update multiple rows in my Directory table, when a user changes their Street Number or Street Name in their profile.  They can add multiple users to a directory and each user they add to the directory has this primary users UserId in it. So if the primary user changes their address, I want it to update the address for all the users they listed in the directory as well. I'm adding this to the On_Click in the Code Behind, so when they click to update their profile, it fires this function as well.

This code may be way off, but here's what I have right now:

                //Update directory user addresses for this account, if profile address has changed
                if ((currentStreetNumber != creatingStreetNumber) || (currentStreetName != creatingStreetName))
                {
                    
                    string myDirectoryConnection = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                    SqlDataAdapter cmd2 = new SqlDataAdapter("Update Directory SET [StreetNumber] = @StreetNumber, [StreetName = @StreetName] WHERE [UserId] = @UserId", myDirectoryConnection);
                    cmd2.UpdateCommand.Parameters.Add("@UserId", currentUserId.ToString());
                    cmd2.UpdateCommand.Paramete

Hi...all experts.

I would like to do a program where

1) Need to get a "number" by select count() from a gridview. Then,

2) Mayb using "For loop" to loop until "number".

As example:

1) i get the select count() from as gridview as 5. Then,

2) I got to loop 5 times.

Can someone give me an example of code for my logic?

Thank you for your kind attention and patient.

Hi all,

         I want to achive on functionallity like below.

         I want to Dispaly image after image selection.so Users  can see image at that moment.

         So Please anybody help me???

Thanks.

Pari13.

i am making a web application in which at one time i have to insert the vales into three table..

first table will generate scope_identity,

then in foreach loop values are inserted in 2nd table with ref of scope identity

and then same with the 3rd table

problem is i dont know how to put transaction in foreach loop......

please help me.......

here is my dummy code please help me....

SqlConnection con = new SqlConnection("server=xxxx;uid=xxxx;password=xxx;database=xxxx;connect timeout=3600");
        con.Open();
        SqlCommand cmd = new SqlCommand("insert into test(a,b,c,d,e,f,g,h) values ('a','b','c','d','e','f','g','h');select scope_identity()", con);
      
        decimal idd = (decimal)cmd.ExecuteScalar();

        for (int i = 0; i < 15; i++)
        {
            SqlCommand cmd1 = new SqlCommand("insert into test1(a,b,c,d,e,f,g,h) values ('"+idd.ToString()+"','b','c','d','e','f','g','h')", con);
            cmd1.ExecuteNonQuery();
        }
        for (int i = 0; i < 15; i++)
        {
            SqlCommand cmd2 = new SqlCommand("insert into test2(a,b,c,d,e,f,g,h) values ('&

Hello,

I have been googling and reading for days but cannot find a way to  allow user to select from the contents of a number of subdirectories and download a file.  I've seen how to download a file from within one directory, as well as displaying the files in  a grid but I am unable to find a way to diplay the directory tree and allow the user to navigate to a subsirectory, select a file, and then download it.

I have version 2.0 of ASP.NET and I use VB.  Can someone point me in the right direction?

Thanks!

 Hi

Still struggling with this code

I'm trying to follow an example in a book i'm reading, but the example is using linq to sql, i'm trying to use linq to xml. Problem is i get the following error:

Error 1 foreach statement cannot operate on variables of type 'object' because 'object' does not contain a public definition for 'GetEnumerator' d:\MVC3_Website\Website.WebUI\Views\Home\Index.aspx 11 8 Website.WebUI

My code is:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Website.Domain.Models.Weather.Entities
{
    public class WeatherForcast
    {
        public string loc { get; set; }
        public string loc_id { get; set; }
    }
}


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Xml.Linq;
using Website.Domain.Models.Weather.Abstract;
using Website.Domain.Models.Weather.Entities;

namespace Website.Domain.Models.Weather.Concrete
{
    public class WeatherRepository : IWeatherRepository
    {
        public IEnumerable<WeatherForcast> GetWeatherCity(string strWeatherCity)
 

hello,

i createa a data flow task and read the records from a table to recordset.

now i inserted a foreach loop container which needs to go thru each record loaded in recordset from dataflow task. i made enumerator to foreach as ado enumerator and set the ado object source variable to recordset variable name from data flow task. also radiobox , rows in the first table is marked.

i also mapped the variable in foreach loop.

my question is how i can use these variable to insert variable values in antoher table?

Hi

I´ve seen a few posts on this topic but I still can´t get my simple example to work. What I want to do is to loop thru all Excel files in a folder and put some of the data in my db. It works fine without the Foreach loop container. This is what I´ve done. First, I´m working on a Windows Server 2008r2 and against a SQL Server 2008r2. The Excel files are Excel 2007.

1) I created a new Integration Services Project.

2) I added a Data flow task to the Control flow tab.

3) I added two connection managers. One for the Excel file source and one for the destination db.

4) I added an Excel Source and a SQL Server destination and connected them. It works fine, I can preview the columns and the mapping is done correct.

When I run it, the db is populated.

5) This is where it fails. I added a Foreach Loop Container and drag the Data flow task into it. In the collection tab I choose Foreach file enumerator and browse to the folder.

5) Under the variable mapping tab I add a variable called FileName under the scope User and inddex 0.

6) Then I flipped to properties for the Excel Connection manager and enter the expression setting. I added a connection property with this expression "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::FileName] + ";Extended Properties=\"E