.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

TSQL help please - dynamic sql inside WHILE loop

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server

I would like to store data into different temp tables based on different WHERE clause. I used the below script but it throws error. Please help

My Script:



@counter int



@counter = 0



@counter <

View Complete Post

More Related Resource Links

CLR Inside Out: Dynamic Languages and Silverlight


DLRConsole gives you an interactive environment for playing with dynamic languages in Silverlight.

Jimmy Schementi

MSDN Magazine February 2008

CLR Inside Out: IronPython and the Dynamic Language Runtime


This column uses the .NET version of the Python programming languages IronPython to demonstrate the value of dynamic languages and the new Dynamic Language Runtime.

Bill Chiles

MSDN Magazine October 2007

Using Dynamic Property inside Html Helper with Razor fires an error



I have the following with Razor:

@Html.GoogleAjax(View.GoogleAjaxKey, new String[,] { { "jquery", "1.4.2" } })

And the I get a strange error:

  'System.Web.Mvc.HtmlHelper<object>' has no applicable method named 'GoogleAjax' but appears to have an extension method by that name. Extension methods cannot be dynamically dispatched. Consider casting the dynamic arguments or calling the extension method without the extension method syntax.

What is strange is that it works fine using:

@Html.GoogleAjax("123", new String[,] { { "jquery", "1.4.2" } })

I tried the following code line:


And the key is displayed just fine so the problem is how I use the value of @View.GoogleAjaxKey into Html.GoogleAjax.

Do I need to change something on my Html Helper? Here it is:

    public static MvcHtmlString GoogleAjax(this HtmlHelper helper, String key, String[,] libraries) {


MVC3: Define Dynamic ViewModel property inside Action Filter



How can I define a Dynamic ViewModel property in MVC 3 inside an action filter?

I am looking to have something like but inside the ActionFilter and not in the controller:

ViewModel.Title = "Home";

Thank You,


Calling Javascript from loop inside a Sub

Hi Guys, I had a copyfile sub that worked fine on my local testing environment in VWD 2008, but now that it is on the server does not work. I assume it is because it is looking on the server for the files, not the local client machine. I am now trying to use client side Javascript to mimic the process. I have created a JS function to do it, but I can't get it to call the JS function inside my VB Sub. Here's the code, thanks to all replyers in advance! Public Function Copy_Photo(ByVal path_in As String, ByVal newname As String) As String Try Dim ret_path As String = Me.Master.get_mug_shot_folder ret_path += newname Response.write("<script type = 'text/javascript'>CopyPhoto('" & path_in & "','" & ret_path & "');</script>") Return ret_path Catch ex As Exception msg_div.InnerText = "ERROR: Could not properly copy file " & path_in & " to location " End Try End Function    Notice how I tried using the Response.write method. It gives me an Object Required error everytime. Here's the JS function: function CopyPhoto(oldFile, newfile) { alert(oldfile + " " + newfile); var fso; fso = new ActiveXObject("Scr

Problem with Dynamic Controls inside an UpdatePanel

Hello Everybody ,I have this problem,if anyone could help me i'll be so gratefull. I had been created some dynamic radio buttons in a loop inside a dinamy table which is inside an UpdatePanel , but i can not handle the events my code is below:public void MetodoCreacion(){RadioButton RBtn = null;Table table = new Table();TableRow row = null;TableCell cell = null;for (int i = 0; i < 5; i++){row = new TableRow();cell = new TableCell();RBtn = new RadioButton();RBtn.ID = "RBGN_" + i.ToString();RBtn.GroupName = "RBGN1";RBtn.Text = "Opcion " + i.ToString();RBtn.CheckedChanged += new EventHandler(RBtn_CheckedChanged);RBtn.AutoPostBack = true;cell.Controls.Add(RBtn);row.Controls.Add(cell);table.Controls.Add(row);}UpdatePanel1_UpdatePanelAnimationExtender.Controls .Add(table);}public void RBtn_CheckedChanged (object sender, EventArgs e){Label1.Text = ((RadioButton)sender).ID;}and the controls doesent call the event ...thanks a lot

Create task activity break out inside a While loop

Hi I have developed a sharepoint state machine workflow. I want to assign a same task to more than one users, but unfortunatly, I cannot give the attribute "AssignTo" to more users in the code, even like this:"this.workflowTask1Properties.AssignedTo = "mydomain\\user01;mydoman\\user02", that will result in an empty value to the attribure.So, I involved the createtask activity in a While loop so I can asign deferent user in each loop, but It's very stange,  the loop always stopped in the second time, does anybody have met this issue?I have referensed Amit's question:http://social.msdn.microsoft.com/forums/en-US/windowsworkflowfoundation/thread/b238978d-f330-420c-823e-b77b0e19414d?prof=requiredbut I have no define the "correlation refernce " in my workflow.my code is here:public SPWorkflowTaskProperties workflowTask1Properties;public int abc;...private void OnWorkflowActivated(object sender, ExternalDataEventArgs e)        {            ...           this.abc = 0;           ...        }...private void CreateTask1(object sender, EventArgs e)        { 

SSIS For Each loop with data flow hangs on DTC (SID -2) when inside transaction

The short story: I have a data flow inside a For Each container that is inside a sequence container.  A transaction is established at the sequence container, with Isolation Level Serializable.  The For Each container is limited to execute only 4 iterations.  The data flow iterates once fine, but the second iteration hangs.  The Activity Monitor shows the process is waiting on a another process with a SID of -2.  From other research in the past, I have found that this is an internal process dedicated to DTC (Distributed Transaction Coordinator). Environment: Microsoft SQL Server 2005 (SP3) on Windows 2008 R2 Standard.  I'm using SQL Server BIDS 2005 for building these packages.  I also have SQL Server 2008 installed and the databases are installed there. The details: The data flow merges data from the same table in two databases, source and target, using a Merge Join component.  It then performs a few transformations and lookups from other tables in the target DB to get IDs.  Then it inserts new records into the target DB or updates existing records in the target DB.  The two source tables are using OLE DB Source components with customized queries.  The insert target component is an OLE DB Destination and the update target component is an OLE DB Command.  In this particular scenario,

MySql Transaction inside a loop.


Hi.  I'm trying to delete a bunch of records in mysql.  The record info to delete (userid, name) is stored in an arraylist.  It seems to only delete the first record and gives an error ("Transaction has already been rolled back or is not pending.") afterwards.  I have the transaction commit inside the loop which I think is the issue but not sure how to go further if I bring it outside of the loop.  Here's the relevant bits of the code.  Thanks in advance.

                ArrayList alist = new ArrayList();

                //alist gets populated with data like (12345,robot)(23456,car) here.

                    MySqlConnection conn2 = new MySqlConnection(query_connection);

ajax.beginform inside a for loop


so I am using a foreach loop to iterate through comments. The comment section is wrapped inside "Comments" div. My function **DeleteComment** fetches comments again once you delete a comment and rebinds it to the control. However, after you delete a comment, anytime you try to delete another comment, the commentId of the very first deleted comment would keep getting passed to **DeleteComment** function instead of the passing the commentId of the comment you are trying to delete. If you refresh the page, then you can delete ONE comment again, and the same problem if you try to delete another. 
     <% foreach (var item in Model) { %>

Error trying to set Correlation Token at runtime for ReAssigning Task inside while loop.


Hello Friends,

I have developed a custom sequential WF in VS 2010 using custom WorkFlow Content Type and ASPX forms.

Requirements are as below:

1.WF creates an approval task for User A. If User A rejects,then WF completes.
2.If User A approves,task is assigned to User B. If User B approves,then WF completes.
3.Is User A approves and User B rejects,then I need to ReAssign the task to User A.

I am facing problems in the 3rd point above.
I have a while loop having a Sequence Activity and the activities: CreateTaskWithContentType,onTaskChanged and CompleteTask are inside the Sequence Activity.

I am aware that the Correlation Token has to be set at design time in the VS 2010 WF Designer.

The issue is of dynamically assigning Correlation Tokens(Task Tokens) to the activities: CreateTaskWithContentType,onTaskChanged and CompleteTask which are inside Sequence Activity(Inside While Loop).

My Code:
CorrelationToken C_Token =
                 new System.Workflow.Runtime.CorrelationToken();
createTaskWithContentType1.CorrelationToken = C_Token;

I get the error:"This operation can not be performed at runtime" when trying to assign Correlation Token dynamically as above.

Can anyone please hel

Dynamic Gridview inside a Dynamic Gridview


If there's a better way to accomplish what I'm attempting I haven't found it yet. That being said, I have create a gridview like the one here, http://www.aspsnippets.com/Articles/Adding-Dynamic-Rows-in-ASP.Net-GridView-Control-with-TextBoxes.aspx . And with some minor tweaking it working great for all my fields, checkboxes, etc. The issue is my last column is another gridview, and I'd like it to function the same. that is, a dynamic gridview inside of a dynamic gridview. I get that I have to create it initially with null values or it won't show up. I guess what I'm having trouble figuring out is instead of go will null data in the parent gridviews column, do I place my blank child gridview. Do I create and bind the child gridview first, or second. Generally just not sure. Also, as far as storing the data from the child gridview goes, will each one need it's own datatable? Thanks for any input, and if you have any suggestions on the whole idea please feel free to let me know ;-)

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlC

dynamic javascript of an .ascx control inside an updatepanel not changing on client between async po


I have a confusing state issue. I found a way around it, but I would like to know why this is happening. First of all, I am using .NET 3.5 and that can't change right now (an easy fix may be the fixed ID capabilities of .NET 4.0).

Type csType = this.GetType();
ClientScriptManager cs = Page.ClientScript;
string jScriptBlockName = "SignUpSignInNameAvailabilityScript";
if (!cs.IsClientScriptBlockRegistered(csType, jScriptBlockName))
{   //NOTE: verified code always enters this
    StringBuilder cstext2 = new StringBuilder();
    cstext2.Append("function GetSignUpSignInNameAvailabilityMessage() { var id = '"
          + CreateUserWizardStep1.ContentTemplateContainer.FindControl("iSignUpSignInNameAvailabilityMessage").ClientID
          + "'; alert(id); return id; }");
    cs.RegisterClientScriptBlock(csType, jScriptBlockName, cstext2.ToString(), true);

This code is in Page_Load of an ascx. The same control is drawn on two separate postbacks of an UpdatePanel in different places of the page thus giving them different client IDs. The code works correctly on the first refresh of web browser; but after UpdatePanel

dynamic button click event in a loop.



    I have a html table, which I created dynamically. I can add rows at run time in it.

    In each row I have a file upload control and an upload button by side of it in a cell.

    I want to know how can I handle the click event of these buttons because they are generated in a for loop dynamically.

1st row ...  |    btn        |   if a new row is added, 2nd row will be visible.

2nd row ... |     btn       |



Passing Parameters to Execute SQL task which is inside a For Loop Container



I have a requirement.

In this I will get a value of 50 ids from one table.

I have an sp which will take ids as input parameter and insert values into another table.

My Problem is I am having a for loop container with me and inside that i have execute sql task in which I have stored procedure.

How can i map the id parameter to the execute sql task variable whichi is inside a forloop.




Thanks, A2H

Object Value lost in script component inside for loop container

Hi All,

I need your expert advice here,

I have 5000 records to transform into csv file and due to the application limitation, the upload module to upload those 5000 records only can be done by batch of 100-200 record at one time.

Because of this, i try to use for loop to split the records into a few files e.g EE_1.csv, EE_2.csv.

The records was retrieved and saved into an object variable (ResultSet) before entering the For Loop flow

The issue i encounter, when it was on the 1st loop everything was fine, it is manage to generate X Records i specified but when it go for 2nd loop, the ResultSet is returning 0 Records..when the actual total records is 5000

Anyone can help this newbie what are the mistakes i made ?

The logic is something like

Public Overrides Sub CreateNewOutputRows()
oledbAdapter = New OleDb.OleDbDataAdapter
dataTable = New DataTable

oledbAdapter.Fill(dataTable, Me.Variables.resultset)
StartPoint = Me.Variables.FilesNumber 'To know which row to start
StartPoint = (StartPoint - 1) * Me.Variables.MaxRecord
EndPoint = (StartPoint + Me.Variables.MaxRecord) - 1

If dataTable.Rows.Count - 1 < EndPoint Then
EndPoint = dataTable.R

Using a Create Task Activity inside a While loop



I have developed a sharepoint sequential workflow. It consists of a while loop, inside which there are 2 activities (in a sequence)-

1. Create task activity

2. Code activity

Code activity is used to set the test condition of the while loop.

The loop executes successfully on the first iteration. But on the subsequent iterations, an error occurs in the workflow.

My requirement is to create the task repeatedly as long as while loop doesnt exit. Is this possible? Any suggestions would be valuable.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend