Tag: .net

SQL Server LDAP authentication

Using SQL Server 2005, how can I authenticate a username/password pair against a non-AD LDAP server using NET ?

Umbraco cannot start after switching to local SQL database

I am trying to switch my SQL database from one on server to local replica of another one. In my SQL Server Manager studio I’ve created and restored DB from DB bak file and fixed user settings. In my local umbraco project I have connection String that looks like this: <connectionStrings> <remove name=”umbracoDbDSN” /> <add […]

How to fix SQL connection leaks in this code?

I am getting this error on my website: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Description: An unhandled exception occurred during the execution of the current web request. Please review the […]

Thread is being aborted

What exactly does all this mean below. I am running an asynchronous web request that calls a page that sends code to my database. Then my database fires off a stored procedure that runs into one of my SQL assemblies. Most times it works, but sometimes I get this: Thread was being aborted. Description: An […]

how to implement undo operation in datagridview

I have created one application in c#.net.Using this application we can update datagridview,now i need to implement undo in it plz give me some ideas. private void button29_Click(object sender, EventArgs e) { Datatable dt; dt.RejectChanges(); } using above code i can do undo before updating. but i need a undo feature as in word plz […]

how to find maximum frequent item sets from large transactional data file

I have the input file contains large amount of transactions like Transaction ID Items T1 Bread, milk, coffee, juice T2 Juice, milk, coffee T3 Bread, juice T4 Coffee, milk T5 Bread, Milk T6 Coffee, Bread T7 Coffee, Bread, Juice T8 Bread, Milk, Juice T9 Milk, Bread, Coffee, T10 Bread T11 Milk T12 Milk, Coffee, Bread, […]

Connecting to SQL Server in ASP.NET

I am trying to connect to the SQL Server from Visual Web Developer using asp.net but I am facing some problems If anybody helps in this regard i will be greatful. public partial class _Default : Page { protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(“Server=localhost;” + “Database=DB;User ID=aaaa;” + “Password=aaaa”); […]

Store user data in MVC 2

So when a user comes to my page, there is certain data that I want to store from how they are interacting with the page. None of this data is being persisted though, so I’m trying to figure out the best way to do it. For example, they log onto my page, and I’m getting […]

displaying updation of data to multiple users which is inserted by another user

i need to show the updated data immediately to a user as he inputs into the database , i.e. online view. i am using sql server and building a c# .net winform application. the application would be used on LAN by 3 users, U1,U2,U3. the users would input data into an ITEMS table using the […]

SQL Nested Queries in C# and Connection Open Problem

I have three tables and my requirement is to fetch their records by using the parent record of each table. So I have three queries. Here is a code sample: First Query SQLConnection con = new SQLConnection(“connectionstring”); SQLCommand cmd1 = new SQLCommand (1stQuery,con); SQLDataReader rs1 = cmd1.DataReader(); while (rs1.Read()) { // Making 2nd Query, 2nd […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.