News in the Category:
Total posts: 7775 | Sort by Views | Sort by Hits
Sahil Malik [MVP], April 24, 2006
Views: 23,199 | Hits 152
Lately Ive been flying a lot. Last to last week, I flew from DC to Denver to Colorado Springs to Fort Collins to Denver to Chicago to Grand Rapids to Chicago to Cedar Rapids to Chicago to back to DC. ...
Mihir Solankis .NET Journal, December 8, 2005
Views: 12,351 | Hits 805
To be able to join tables between two SQL Servers, first you have to link them. After the linked servers are setup, you just have to prefix your tables names with server name, database name, table own...
Sushila Patels Weblog, January 27, 2006
Views: 11,577 | Hits 86
We have seen many examples on how to change the background color of row based on the data using DataGrid Control. This can be done using a helper function or using the appropriate event of the da...
Sahil Malik [MVP], June 12, 2005
Views: 11,476 | Hits 69
Boy this question will come up a lot atleast in the initial phases of .NET 2.0, so I thought it is worth writing a blog post on.
The first difference is, SqlTransaction will not work on multiple datab...
Journey to SQL Authority with Pinal Dave, November 14, 2009
Views: 10,839 | Hits 7
Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet oft...
JohnPapa.net, August 5, 2005
Views: 9,567 | Hits 928
I was asked a good question the other day regarding why I chose to use "IF NOT EXISTS" in my Nov 2003 MSDN article on User Defined Functions to check to see if a declared table variable ha...
mikes web log, October 13, 2006
Views: 8,314 | Hits 2,189
This came up at work today, so I thought I'd toss in a quick note. You can do cascading drop-down lists declaratively in ASP.NET 2.0, or at least if your scenario is straightforward. Imagine two drop-...
Sushila Patels Weblog, October 9, 2004
Views: 8,049 | Hits 134
.aspx <asp:Repeater ID="Repeater1" Runat="server" EnableViewState="False"> <ItemTemplate> <table width="100%" cellspacing="0" cellpadding="0"> <tr>&n...
the telerik blogs, September 9, 2008
Views: 8,036 | Hits 64
I've made two Master/Detail demos using RadGrid for ASP.NET AJAX, LINQ to SQL and WebService client-side data-binding.
The first example is a single grid with two hierarchical levels (Customers -> ...
Keyvan Nayyeri, July 21, 2006
Views: 7,081 | Hits 665
In addition to previous post, another issue that someone had asked on ASPnix forums was about Login control in ASP.NET and SQL Membership provider. He couldn’t make his Login control ...
Williams .Net Zone, September 29, 2007
Views: 6,901 | Hits 746
/* * A deceptively ~simple self-join query to find all date ranges in a table that overlap. * A date range is defined by the range between InTime and OutTime. * The "Seq != Seq" filter is re...
Journey to SQL Authority with Pinal Dave, February 6, 2008
Views: 6,601 | Hits 1,007
This is very common request recently - How to import CSV file into SQL Server? How to load CSV file into SQL Server Database Table? How to load comma delimited file into SQL Server? Let us see the sol...
David Silverlights Web Log, August 23, 2005
Views: 6,599 | Hits 1,104
One of the great new features of ASP.NET 2.0 is that persisting user profile data is about as easy as you can get. You simply define the profile values in your web.config file and the framework ...
JonGalloway.ToString(), July 8, 2005
Views: 6,419 | Hits 503
Summary:SQLite is a great, free, embedable database. It's fast, tiny, and reliable, and has some cool features like support for NTFS compression of the database file. It's multithreaded, but its coars...
TheChaseMans Frenetic SoapBox, January 21, 2006
Views: 6,386 | Hits 993
About a month ago
I posted some code for implementing custom paging with the
ObjectDataSource with the goal being a single database call to get the
records and the rowcount. The code ...
Bigyan Rajbhandari, July 15, 2006
Views: 6,350 | Hits 347
Anyone who is using Reporting Services 2000 and rendering the report in HTML has porbably seen the error rsStreamNotFound with embedded or external image. While reading through various blogs one thing...
Wortzels blog, May 5, 2008
Views: 6,235 | Hits 996
As I already mentioned in one of my previous post, the SqlBulkCopy is a powerful tool which gives us an option to perform insertion for a large amount of data. The evolution of the ADO.NET creates us ...
Sahil Malik [MVP], April 28, 2006
Views: 6,200 | Hits 136
(The below per Beta1TR)
A big huge GARGANTUAN limitation of Sharepoint 2003 was it's crazy psycho obsession for nothing but Windows Authentication. You could customize that to some extent by plac...
Rick Strahls WebLog, August 6, 2006
Views: 6,172 | Hits 1,010
Bob Lucas posted a nice Visual FoxPro 9.0 tip on the Message Board earlier today in respect to how you can get Image values in and out of a SQL Server database and I thought I’d repost this here...
Scott on Writing, November 16, 2005
Views: 6,143 | Hits 122
Scenario: Creating a page with an editable GridView or insertable DetailsView (or FormView) that uses a SqlDataSource whose contens are generated through the Configure Data Source wizard. Specifically...
Sahil Malik [MVP], July 26, 2005
Views: 6,134 | Hits 116
Okay so My Dear Guinea Pig, I am doing a usability test on you.
In my Upcoming ADO.NET 2.0 book, I am trying to explain a restriction you have on "How many SQLCLR context connections can you have op...
MSDN: SQL Server, February 24, 2006
Views: 6,133 | Hits 1,112
Discover how to create a rule engine in SQL Server. Use this simple rule-engine design to implement state machines, predicate dispatchers, or any other rule-based system in a wide variety of applicati...
Dino Espositos WebLog, September 24, 2007
Views: 6,024 | Hits 615
With ASP.NET 3.5, a new data source control joins the company: the LinqDataSource control. How does it position itself in the grid of data source controls? The difference between SqlDataSource and Obj...
E-Surfers Weblog, August 4, 2005
Views: 5,950 | Hits 388
In my recent post I wrote something about import excel data into mysql database. In this entry, I want to talk about the steps I take to export the data of a mysql database into an excel file.
Pencil Bros. Geology, Inc., June 17, 2008
Views: 5,923 | Hits 11
The following error is a new thorn in my side. Its showing up in SSIS 2005
packages which are scheduled, but does not happen when I run the packages manually.
I changed the message slightly to remove...
Gregg Stark on SQL Server, October 16, 2007
Views: 5,849 | Hits 574
If you have ever dropped a database and found yourself not able to login because your default database no longer exists you know it can be quite annoying. You can still connect through query ana...
DotNetJunkies Just Published, April 8, 2005
Views: 5,812 | Hits 110
Apex SQL Tools has a new version of Apex SQL Log, SQL Tool for database auditing. Apex SQL Log is a SQL Tool that analyzes SQL Transaction Log to display data & structure changes. Apex SQL Log rea...
Steven Smith, September 30, 2007
Views: 5,803 | Hits 26
Suppose you need to perform a SQL query and you need for it to be case sensitive or case insensitive, and either your database is set up the opposite way or you're smart and you're trying to write you...
OdeToCode Latest Articles, May 7, 2005
Views: 5,791 | Hits 694
Table variables allow you to store a resultset in SQL Server without the overhead of declaring and cleaning up a temporary table. In this article, we will highlight the features and advantages of the ...
hongmeigs WebLog, August 31, 2007
Views: 5,750 | Hits 503
If you are getting the following error:
Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances What should I do?
Answer: To fi...
Dino Espositos WebLog, August 8, 2005
Views: 5,740 | Hits 374
Imagine you have a master/detail page with a GridView and a DetailsView. You select a record in the DetailsView, make some changes and save. How can you have the master element--the GridView--refresh ...
Jotekes Blog, October 26, 2005
Views: 5,586 | Hits 525
In case you've installed SQL Server Express and found out that there are two executables for installation (for example when installing SSE bundled with VS2005) SQLEXPR.EXE and .SQLEXPR3...
4GuysFromRolla.com Headlines, October 21, 2009
Views: 5,367 | Hits 50
Over the years I've worked on a number of projects that have shared a common requirement - the ability for users to quickly import large amounts of data into a back end SQL
Server database. One such...
Journey to SQL Authority with Pinal Dave, October 27, 2007
Views: 5,318 | Hits 664
Interesting enough Jr. DBA asked me how he can get current user for any particular query is ran. He said he wants it for debugging purpose as well for security purpose. I totally understand the need o...
Scott on Writing, April 25, 2006
Views: 5,308 | Hits 156
In an earlier article of mine, Custom Paging in ASP.NET 2.0 with SQL Server 2005, I wrote about SQL Server 2005's new ROW_NUMBER() function,which makes efficiently returning a paged result in SQL Serv...
Clarity Blogs: ASP.NET, January 18, 2010
Views: 5,295 | Hits 10
I recently had a unique challenge with SSRS which was the utilization of a Custom Font on an SSRS Report. Normally, I do not think about fonts other than what get installed as system fonts in Windows ...
Scott on Writing, December 5, 2006
Views: 5,294 | Hits 178
First off, it's been a long time since my last post, close to a month! Things have been very busy between the new batches of Working with Data in ASP.NET 2.0 tutorials, the monthly Toolbox column, oth...
Write Ahead Blog, April 28, 2005
Views: 5,235 | Hits 766
Today, we did a short presentation on Service Broker for a customer who is interested in using the Service Broker technology. Their current application uses a large backend SQL Server d...
Scott on Writing, July 10, 2009
Views: 5,220 | Hits 71
Error Logging Modules And Handlers (ELMAH) is a free, open source error logging library for ASP.NET applications that provides automated error logging and notification and, unlike health monitoring, o...
Steven Swafford - ASPAlliance Columnist/Editor, July 10, 2006
Views: 5,209 | Hits 257
I thought I would begin creating a custom provider for Oracle and I am starting with the database schema. Now this is a work in progress and I am attempting to complete this between my job, family, an...
Wortzels blog, January 4, 2008
Views: 5,207 | Hits 1,416
These two data access strategies should be shipped in the new Visual Studio 2008 (aka "Orcas") but from some reasons Microsoft decided to cut the entity framework from this release and to sh...
E-Surfers Weblog, October 27, 2005
Views: 5,180 | Hits 238
When I recently upgraded to MySQL 4.1.10 and Connector/J 3.1.8, I got the following Exception:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'productid' at row 1
4GuysFromRolla.com Headlines, April 12, 2006
Views: 5,139 | Hits 402
When displaying large amounts of data to a user, it's important that the information be presented in digestible chunks rather
than slamming it all down their throats at once. For example, searching fo...
The Code Project Latest Articles, October 31, 2008
Views: 5,052 | Hits 414
How to create an ASP.NET MVC sample using LINQ to SQL, Flexigrid for JQuery and Json...
EggHeadCafe.com New Articles, April 14, 2010
Views: 4,949 | Hits 13
Build a simple database application with WPF that can display data in GridView and can perform ADD, UPDATE and DELETE operations on SQL server database. read moreBy Kirtan Patel...
GotDotNet: New resources, July 21, 2006
Views: 4,898 | Hits 407
SQL Server 2005 Database optimization Interview questions must for every DBA...
Journey to SQL Authority with Pinal Dave, August 9, 2008
Views: 4,878 | Hits 193
If you are receiving following error:TITLE: Connect to Server——————————Cannot connect to Database Server.——————————ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the s...
Sahil Malik [MVP], March 30, 2006
Views: 4,817 | Hits 63
This question was asked by one of the codebetter members, I just figured it may be a universally asked question, so instead of replying by email, I'm puttin' it on my blog instead.
Sorry if I'm talkin...
4GuysFromRolla.com Headlines, July 6, 2005
Views: 4,816 | Hits 523
There are often times when retrieving results from a database that you only are interested in displaying the first
N records from the resulting query. For example, a news website might have a databa...