SQL Server :: Sample Code For Forward Cursor With Table Variable?
Dec 16, 2010I want some sample code that will loop through records of table variable using a forward only cursor.
View 2 RepliesI want some sample code that will loop through records of table variable using a forward only cursor.
View 2 RepliesThere are sample codes on the net for OpenId Client but none for OpenId Server. Do you know some? I know about dotnetopenAuth but there seem to be no tut on how to use as OpenId Provider. I don't even know if it can do that. Maybe it can just be used to create openid consumer app.
View 1 RepliesI need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
anyone use/ know of any library or website with code snippets or samples with many of the mundane boilerplate code and/ or functions like data access, data scrubbing, recursive routines...
preferably c# since most of .net in the real world is c#. VB is ok too.
I am doing online quiz in a Page in my website. How i will restrict users from going backward or forward using Broowser backward or forward button in that page using ASP.Net,C#,JavaScript.
View 1 RepliesMy stored procedure expects a uniqueidentifier as a parameter. However, this unique identifier is stored in a table variable, which looks like this:
DECLARE @GiftGuid uniqueidentifie
In my asp.net website I am creating a session upon user login and I would like to perform some operations in the database just before this session will expire.I am having problem in determining where should I write code and how will I know the session is going to expire.
I am not sure if 'session_end' event of 'Global.asax' suits my requirements as the session I want to check is created manually(not a browser instance).
how to implement geneology in asp.net with sample code
View 1 RepliesThis is from a very good book by Steven SandersonI am trying to follow the chapter 4 and trying to setup IOC on my mvc code from the code sample of the book but its not working.I follow the code from page 97 to page 101 where I set up Inversion of Control and run the code but I get the following error. A dialog box opens trying to search the following file:
c:TeamCityuildAgentwork1ab5e0b25b145b19srcCastle.WindsorWindsorWindsorContainer.cs
protected override IController GetControllerInstance(
System.Web.Routing.RequestContext requestContext,
Type controllerType)
[code]...
I want sample code for upload swf I dont want do save in the DB
View 4 RepliesI am looking for some suggestions for an application I am writing. Here is a brief description of the application:The application is written in C# ASP.NET version 4.0 and is to be hosted on an IIS6 web server. The purpose of the application is to serve as a download page for sensitive documents. There will be several levels of access which will be granted according to user credentials stored in a SQL table. I don't want the application to check the user's NT ID and either allow or disallow access to the application depending on whether they are authorized or not, I want it to filter on data i.e. everyone can view the application, it will just limit the data they can view depending on their access.
point me in the direction of some source code that can check the NT ID of user's local machines and compare it to a table in SQL?
I have created a composite control with sample details as follows. Basically, the first time on page load the control sets a view state variable and the problem is that on post back (when the button is clicked), the ViewState variable is null. I have researched extensively and I am not able to find a solution. I checked all the Microsoft recommended articles and also from other developers. This approach seem to work for everyone
PS: This code may not work as it is only for illustrative purposes. but this is exactly what i'm doing in my code.
Public class Test : CompositeControl
{
private Button btnTest = new Button();
public string TestViewState[code]....
how can i find the total null values in a table without using sql cursor .
i want to find the percentage of the data which is avaibale in the table and how much percentage of data is unavailable ( or null). to make a comparision chart.
i have 6000 rows and 200 columns in a table , if i use sql cursor , it is taking too much time to execute ( 6000 * 200 ) loops. is there any inbuilt-function in sql to do it .?
Is there any c# sample code of integrating orkut from an ASP.NET web site (oauth authentication, retrieving friends, etc.)
View 2 Replieshow to add pages in the Form Authentication Sample Code. I am required to add a registration form in this Custom Security Solution. It lets me add the .cs files but when I add .aspx file, it gives errors in building. let me know what architecture have they followed? Why they have .resx files?
View 2 RepliesI am looking for sample code where a button click on the server side will spawn a modal child page, having couple of controls such as textboxes and a button, where one could enter values in the text boxes and click the button; once the button is clicked, the page should postback to the parent page, where the entered values could be read. There is a video on this site about AJAX control kits describing modal popup, but unfortunately it wouldn't serve my purpose.
View 3 RepliesI am working on a small project of a university.In which i have to show the code snippets of c language & their description on webpages as tutorials.How can i accomplish it in Asp.Net.
View 10 Repliesdo u also any good code projects for developing inbox functionality.
just that users could communicate with each other It does not need to as high level using System.net.mail
Just when the user clicks on Inbox shuld fetch data from db. and send and save to draft, navigation, querystrings, grid view did my own but just want to see other examples.
i have a web-site which uses forms based authentication. thus i have a login page with a login control on it. how would i go about coding the authenticate event of this control to talk to the Entity Framework to validate the user credentials?
View 2 RepliesWhen someone requests a web form, I want to use Javascript to see what browser they use, and then point to the correct css files with Javascript. What is the simplest way to do that.
For example, in my header of the html form, I have a link that says:
[Code]....
i am looking for some sample code in order to upload and/or retrieve images stored in a database.even the web is full of samples, i was not able to find one without using blobs as i would like to save only the directory of an image when it comes to the place of storing. the reason behind is that i do want to have my database small for some reason and therefore only want to save links to my images inside.
View 5 Replieslooking for some sites or links to samples of using the modalpopup to display when session is about to expire.similar to godaddy.com.If it cant be used anyother solutions available to accomplish the same thing have an application we are building that they want to have something similar to that on the pages.They want to warn / prompt that their session is about to expire.Similar to online banking.
I have a list of buttons in a menu, and when I hover of them, I want something to change, such as a box being drawn around them, or background color chaning. How do I do that?
View 3 Repliesi m looking for northwind 2008 sample database. But i m unable to get the link. All links are for 2000 samples.
View 1 RepliesI have a stored procedure that builds a table. I need to delete the table before running it or I get an object already exists error. How do you code Drop Table in C# code behind. I have am calling the SP with execute non-query statement.
View 4 Replies