|
More site info...
SQL Server, SQL Server Express, and SqlDataSource Control | Forum profile
|
|
Forum profile page for SQL Server, SQL Server Express, and SqlDataSource Control on http://www.asp.net.
This report page is the aggregated overview from a single forum: SQL Server, SQL Server Express, and SqlDataSource Control, located on the Message Board at http://www.asp.net.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "SQL Server, SQL Server Express, and SqlDataSource Control" on the Message Board at http://www.asp.net is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on SQL Server, SQL Server Express, and SqlDataSource Control:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
90
|
384
|
1,152
|
|
Post:
|
286
|
1,149
|
3,527
|
|
|
SQL Server, SQL Server Express, and SqlDataSource Control Posting activity graph:
|
Top authors during last week:
user's latest post:
Sql Server set default unique...
Published (2009-12-03 11:30:41)
It should work. Here is a testing script: CREATE TABLE [dbo].[Users2]( [id] [int] NOT NULL, [myUser_id] [uniqueidentifier] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[Users2] ADD CONSTRAINT [DF_Users_myUser_id] DEFAULT ('a1c52544-0eb8-4912-8d38-241fbfcf9753') FOR [myUser_id] GO
user's latest post:
Get "to" e-mail...
Published (2009-12-03 03:30:08)
Hi there. Thanks man for all your help but I have sorted the problem out. http://forums.asp.net/t/1499481.aspx thanks dude :)
user's latest post:
to redirect sample db setup to...
Published (2009-12-03 08:45:18)
Sorry for the misunderstanding. There are SQL Server 2005 Express and SQL Server 2008 (not Express) on your machine and you want to install “SQL2008.AdventureWorks_All_Databases.x86” on the SQL Server 2005 Express instance, right? It seems that we cannot install "SQL2008.AdventureWorks_All_Databases.x86" on SQL Server 2005 instance, please see the following description: SQL Server 2008 is the only release supported for...
user's latest post:
what can be in views except of...
Published (2009-12-03 12:33:08)
You don't need to post such simple questions on both forums - the answers are really simple to get by simple google or reading BOL.
user's latest post:
Get "to" e-mail...
Published (2009-12-03 01:21:08)
Hi, What is the name of column in database? Also check the spelling of String remove one extra "i" in it
user's latest post:
Import excel sheet to sql server...
Published (2009-12-02 12:42:00)
No, in my excel file the first row is already information. ColumnA Column B john 27 Andrew 15...
user's latest post:
what can be in views except of...
Published (2009-12-03 12:33:08)
The general idea of a view is that it is "just" a view of the data in one or more tables. However, some databases, including SQL Server, allow you to update the database through the view as well as select, sort and filter the data. Typically, this is only possible if the view is based on a single table.
user's latest post:
MS SQL Sorting function
Published (2009-11-30 05:50:22)
The Min and Max posibility returns the minimum or maximum value so this isn't getting to work...
user's latest post:
what can be in views except of...
Published (2009-12-03 12:20:08)
what can be in views except of selecting? insert, update od delete can be? or wheather it affect the table data or not?
user's latest post:
windows 7 or? conex vwd sql server
Published (2009-12-03 10:47:46)
just check the services and I think the problem is there, which is the SQL Server service? I try to start SQL Server Agent (SQLExpress) and I will not let me get this error: the sql server agent service on local computer started and then stopped. some services stop automatically if they are not in use by other services or programs. which it is not the SQL server 2008
|
|
|
|
Latest active threads on SQL Server, SQL Server Express, and SqlDataSource Control::
Started 4 days, 8 hours ago (2009-12-03 12:37:06)
by abinashbishoyi
A database index is a data structure that improves the speed of data retrieval operations on a database table . Indexes can be created using one or more columns of a database table , providing the basis for both rapid random look ups and efficient access of ordered records. The disk space required to store the index is typically less than that required by the table (since indexes usually ...
Started 4 days, 8 hours ago (2009-12-03 12:34:37)
by jerrylefou
In my opinion, I wouldn't use SqlDataAdapters for gridviews in your case. I think this object is great for POC or little demos because you can bind your grid really fast, but not in a real ntier application.
Started 4 days, 8 hours ago (2009-12-03 12:33:08)
by integrasol
The general idea of a view is that it is "just" a view of the data in one or more tables. However, some databases, including SQL Server, allow you to update the database through the view as well as select, sort and filter the data. Typically, this is only possible if the view is based on a single table.
Started 4 days, 8 hours ago (2009-12-03 12:31:39)
by jerrylefou
A trigger is something that can occur when a record in a table is deleted,updated or inserted. For example, if you have a table with a field that contains the date this record has been modified, you could set a trigger on updates and inserts that will set this field to the current date so you won't have to handle this field in your application code. Starting with that, you can do whatever you ...
Started 4 days, 8 hours ago (2009-12-03 12:29:10)
by integrasol
http://en.wikipedia.org/wiki/Materialized_view
Started 4 days, 8 hours ago (2009-12-03 12:21:40)
by Naom
You already got your answer in MSDN forum on the same question. See http://social. msdn.microsoft.com/Forums/en-US/tran sactsql/thread/abc131b8-9912-490f-b177-45ffc52f427 9
Started 4 days, 8 hours ago (2009-12-03 12:13:11)
by MetalAsp.Net
http://en.wikipedia.org/wiki/Join_(SQL )
http://www.sqlmag.com/Articles/ArticleID/95651/956 51.html?Ad=1
Otherwise Google/Bing are your friends.
Started 4 days, 9 hours ago (2009-12-03 11:30:41)
by limno
It should work. Here is a testing script: CREATE TABLE [dbo].[Users2](
[id] [int] NOT NULL,
[myUser_id] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Users2] ADD CONSTRAINT [DF_Users_myUser_id] DEFAULT ('a1c52544-0eb8-4912-8d38-241fbfcf9753') FOR [myUser_id]
GO
Started 4 days, 8 hours ago (2009-12-03 11:58:12)
by fwd79
EXCELLENT post buddy!! Saved a BIG problem for me. Thanks, a lot of thanks.
Started 4 days, 16 hours ago (2009-12-03 04:18:43)
by Mikesdotnetting
Yes there is. Use parameters: http://www.mikesdotnetting.com/Article/113/Prevent ing- SQL-Injection-in-ASP.NET Some people might suggest using string.Replace(), but that is not a good idea.
|
|
Hot threads for last week on SQL Server, SQL Server Express, and SqlDataSource Control::
Started 1 week, 1 day ago (2009-11-29 10:55:00)
by mudassarkhan
check this
http://www.java2s.com/Tutorial/CSharp/0560__ADO.Ne t/ReaddatafromAccessdatabase.htm
Started 6 days, 23 hours ago (2009-11-30 21:45:34)
by limno
You can try the SqlBulkCopy method within your ASP.NET page to load Excel data into your SQL table. Here is an example from this thread: http://forums.asp.net/t/1492016.aspx protected void Button1_Click(object sender, EventArgs e)
{
// Connection String to Excel Workbook
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\datatest\Book1.xls...
Started 4 days, 11 hours ago (2009-12-03 09:46:46)
by bullpit
Where is the SQL Server Installed?
Started 1 week ago (2009-11-29 23:24:00)
by IgorB
Is your db in the App_Data folder?
Started 1 week, 1 day ago (2009-11-29 11:54:00)
by mudassarkhan
Can you paste the code?
Also what error you are getting?
Started 4 days, 17 hours ago (2009-12-03 03:30:59)
by fayaz_3e
Let it be saved as date only. While displaying, use format. I mean use .ToString with needed format. This might be helpful http://www. codeproject.com/KB/cs/DateTime_Patterns .aspx
Started 1 week ago (2009-11-30 14:28:05)
by atifsarfraz
You can just add a runat="server" to the title tag, give it an id and then access it from code behind <title runat="server" id="MyTitle">Access Compare</title> protected void Page_Load(object sender, EventArgs e)
{
MyTitle.Text = "Hello";
}
Started 4 days, 17 hours ago (2009-12-03 03:04:18)
by guenavan
Jian Kang - MSFT: So you work with SQL Server 2008 Express, right?
No, I work with MSSQL2005 Express (installed by VS2008 setup) It is (localhost)\Express Having default (unnamed instance) on MSSQL2008 It is (localhost) instance The samples are also installed on (localhost) (i.e. in MSSQL2008). I want to install on MSSQL2008 another instance
Started 1 week ago (2009-11-30 01:44:41)
by anooj
Hi,
Plz refer this:-
http://technet.microsoft.com/en-us/library/ms17741 0.aspx
http://blog.sqlauthority.com/2008/06/07/sql-server -pivot-and-unpivot-table-examples/
I hope this helps..
Enjoy..
Started 1 week, 1 day ago (2009-11-29 13:11:00)
by Mikesdotnetting
Don't use FilterExpressions. USe a WHERE clause in your SQL instead.
|
|
Size: 1,893 bytes
