Inserting new values in database Asp .Net
I have a code for inserting values in ASP.net using vb. I’m having problem with my code says login failed, cannot open database.
sql
Insert into database date with another format
I have a gridview and sqldatasource.
How hard is it to incorporate full text search with SQL Server?
I am building a C#/ASP.NET app with an SQL backend. I am on deadline and finishing up my pages, out of left field one of my designers incorporated a full text search on one of my pages. My “searches” up until this point have been filters, being able to narrow a result set by certain factors and column values.
Nullable DateTime conversion
Possible Duplicate:
c# why cant a nullable int be assigned null as a value
How do I stream .flv files from SQL database
I want to store .flv files in the database and not in the file system.
Using the Web.Config to set up my SQL database connection string?
Can anyone help me out please? I’m confused.
C# Invalid attempt to call Read when reader is closed
I am having Invalid attempt to call Read when reader is closed error when I am doing 3 tier project in C# language.
What I am trying to do is retrieve address data column by joining two tables together and display in a drop down list.
Here is my data access layer:
Catching SQL unique key exceptions in .NET
I was wondering if anyone had a more elegant way to check for unique key exceptions from SQL in .NET other than parsing the error message? Right now I am calling the sproc in SQL, then using a try catch block in .NET. In the try catch block I parse the error message and it is a Unique key error I throw an instance of a custom error to the calling class, if not I just throw the original exception the the calling class. This seems awfully inefficient to me.
SQL Data Hierarchy
I have looked through a few SQL hierarchy tutorials, but none of them made much sense for my application. Perhaps I am just not understanding them correctly. I’m writing a C# ASP.NET application and I would like to create a tree view hierarchy from SQL data.
Passing an object collection as a parameter into SQL Server stored procedure
I have a general question on whether something can be done – and whether it will be the most efficient way of doing it !