You searched for the word(s): userid:796192

More Search Options

RSS Available

• Re: Insert new record from GridView row "Select" command

  Hi mjta, Please refer to the following sample WebForm1.aspx <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1"> <Columns> <asp:CommandField ShowSelectButton="True" /> <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" /> <asp:BoundField DataField

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/27/2009

• Re: Problem with Guid.NewGuid() Getting Empty Guid in VB.Net

  Hi Nick, [quote user="Nick Bansal"]When i converted it in a string i got a userid like : Dim QPUserId As String = UserId.ToString()[/quote] Please comment this line and pass UserId directly as follows: Dim UserId As Guid = Guid.NewGuid() 'Dim QPUserId As String = UserId.ToString() Using conn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("TestDB1ConnectionString").ToString()) Dim cmd As SqlCommand = New SqlCommand("insert into table_8 values

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/27/2009

• Re: Error with Publish SQL DB to share hosting

  Hi, Could you please provide more details? How did you publish the database? I think the error message has indicated that there is a collation conflict between servers. Please refer to another similar thread to fix it: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e54d9238-cc21-4e5c-b4b4-fa3cf9dfb19d

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/27/2009

• Re: Remove Accented Characters

  Hi Peuge, I think we can change the current database collation to an accent-insensitive one. Please refer to the following links: Setting and Changing the Database Collation http://msdn.microsoft.com/en-us/library/ms175835.aspx How to transfer a database from one collation to another collation in SQL Server http://support.microsoft.com/kb/325335 Selecting a SQL Server Collation http://msdn.microsoft.com/en-us/library/ms144250.aspx

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/26/2009

• Re: Please help on the calendar

  [quote user="loon86"] "Conversion failed when converting date and/or time from character string." i got my calendar value correct, just that the vb script having some issue on converting the value to the 1 database needed. [/quote] Hi, Could you please provide the table structure and HTML markup? What are the data types of [Date] and [Time]? I can reproduce the error using following sample: T-SQL CREATE TABLE [dbo].[Table_5]( [ID] [int] IDENTITY(1,1) NOT NULL, [Time] [time](7

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/26/2009

• Re: aspnetdb.mdf with sqlserver2005 and sqlserver2008 problem

  Hi Dieter, Could you please provide more details? What are the connection strings? [quote user="hdw"]But there is one problem with the app2008: when I try to use a login, then I get the error message, that the version of aspnetdb.mdf is not supportet (is to high). I found out that the process sqlserver.exe has opened this file, but the process ist the sqlexpress2005 (and not the 2008) server process.[/quote] So I think the problem is caused by connection strings. A SQL Server 2008 database

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/26/2009

• Re: setting up database project

  Hi, Please refer to the following links to work with Database Projects: Using Database Projects for Visual Studio http://blog.reamped.net/post/2008/05/Using-Database-Projects-for-Visual-Studio.aspx Handling Database easily with Visual Studio 2008 http://www.vitalygorn.com/blog/post/2008/01/Handling-Database-easily-with-Visual-Studio-2008.aspx

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/26/2009

• Re: Please help! Can't connect database

  [quote user="jornjae"] Thanks for your reply. But the user and password are already in connectionstring tag and in the database the user name is already in there as well. For the last one I don't know how to do. [/quote] Hi jornjae, I think we use impersonation when Web site and SQL Server are on separate machines and Web site connects to SQL Server using Windows Authentication. However, you use SQL Authentication so I don’t think impersonation would work. Your Web application and SQL

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/26/2009

• Re: Custom Membership Provider

  [quote user="sbraudrick"] A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) [/quote] Hi Sean, This kind of issue is usually caused by invalid SQL Server instance name or SQL Server instance doesn’t enable

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/26/2009

• Re: How can I make my SQL Selects/Inserts/Deletes dependent on a logged-in User?

  [quote user="Konrad_P"] So, I need to tell my SqlDataSource, that a certain user (with a PK UserID) is logged in, and wants to see _all and only his_ data. Is this possible? I don't really want to use the asp:login, because then I can't save the userdata in the .mdf-file. (Can I?) [/quote] Hi Konrad, Yes, we can. Since you would like to use SqlDataSource, please refer to the following sample: WebForm1.aspx <asp:Login ID="Login1" runat="server" onauthenticate

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jian Kang - MSFT on 11/26/2009