Search results for query: *

I am doing some time consuming calculation in one of my routines which is called during the node expand event of the treeview. I want this routine to be called during Page_Load event itself so I don't have to make the users wait for long when they click and expand the treeview. The problem is...

Is there a way to send out automatic email as soon as a task becomes due to someone?

I need to pass the name value obtained from a treeview_nodeexpand event to a tabstrip_tabclick event. I am able to get the value of the name but i am unable to pass it in the tabstrip_tabclick event. How can i do this? Both the controls for treeview and tabstrip are set for autopostback = true

da = New SqlDataAdapter("Select Busunit from Product where name = @prod", dbcon) da.SelectCommand.Parameters.Add("@prod",sqlDbType.VarChar, 24).Value = "prod" da.Fill(ds, "Product") In the above code, I am passing the value of prod to the sql in da and then filling the dataset in the last line...

I am using a thirdparty treeview control on my webpage. I am binding the root nodes in the page_load however I need to bind the child nodes in the nodeexpand event of the treeview, I need to create a datarelation between the parent and the child nodes in order to be able to associate child nodes...

I am trying to connect to a security database to get the logged on user's rights in my code. However, when I am debugging in the immediate window I get the following error which says could not connect to the database. Where is the problem. The web.config file contains the database connection...

The line did not work in the transformation. It throws an error while executing the import process. Invalid procedure call or argument: 'DTSDestination'. I tried adding columns to the Column mapping and transformations window but I am unable to create new columns in the destination. The preview...

I need to add two new columns in the database table during the import process. These two columns do not exist in the text file that I am importing into the sql server. How could i do this? One of these columns has to be the current year.

Thanks a lot for your help!!!! I was able to run this query. Just for curiosity sake, Is there any other way to do this without passing nulls for eg. temp tables?

t1: name varchar(50) title varchar(50) city varchar(50) state varchar(50) building varchar(50) t2: name varchar(50) title varchar(50) city varchar(50) state varchar(50) Business Unit varchar(50) I need to compare the two tables and insert into t1 all names that are in t2 and start...

When i finally got to run the query, I am getting this error below as there are two columns in t1 and i am inserting value for only one column. Insert Error: Column name or number of supplied values does not match table definition.

In the above, What should i do If i need to add not all the differences in the two tables but only those items that start with letters 'ab%'

Thanks a lot SqlDenis for your help. Could you give a brief explaination as to how you wrote it? Like i did not understand the three parts of the code. Please excuse me for being so trivial

I need to compare two tables say t1 and t2 on a column called P and add whatever is missing in t1 to P in t1 in one single script. Can someone help me?

Thanks a lot for the information. Till now, I have been using Microsoft Press for 316 and going through MSDN. I will go ahead and get Amit Kalani book. Does it contain practice question papers too?

I was able to resolve this. It was only an issue with setting the datatextfield and datavaluefield property of the TreeView control to the value of the datatable in the dataset which could be done in the design view.

I am creating a TreeView in my webform using RAD controls from Telerik, Right now I need to load only the root nodes of the tree from my sql server database table using a simple select query. When I databind my RadTreeview I can see the correct number of root nodes but instead of the data, I...

Can you give more details on the preparation aspect of your exam and what are the best resources from your point of view to prepare for 70-316?

I am creating a DTS package in which I need to create as many excel files using DTS as there are business units in my SQL table. This table has other columns for emplid, emplname and managername. I need to figure out how business units can be used to separate data into different tables and then...

I am creating a DTS package in which I need to create as many excel files using DTS as there are business units in my SQL table. This table has other columns for emplid, emplname and managername. I need to figure out how business units can be used to separate data into different tables and then...