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

More Search Options

RSS Available

• SqlClient page script using c#

  The script below initially used OleDbConnection to a access database.. I want to use a SQL Server 2008 as datasource but am not succesful..is the code below out of sorts? <%@ Import Namespace="System.Data;" %> <%@ Import Namespace="System.Data.SqlClient;" %> <script language="C#" runat="server"> void Page_Load(object sender, EventArgs e) { SqlConnection myConn = new SqlConnection(); myConn.ConnectionString = @"Data Source=xxxxx;"

  Posted to Data Access and ObjectDataSource Control (Forum) by oldbcells on 12/7/2009

• Re: SqlClient page script using c#

  Sorry suthish, I wasn't clear on that I suppose.. was just wondering if there were any syntax errors that were obvious. Using this to populate another control (obout Show control) and the page returns 404 error .. have tried using a TRY/CATCH on the open and still getting 404s If I go back and use the OleDB data with an mdb file everything triggers ok ... I think the coding is theorectically ok .. but not certain.

  Posted to Data Access and ObjectDataSource Control (Forum) by oldbcells on 12/7/2009

• Nested repeater .. passing value to SELECT statement

  Nested repeater .. works fine, creates list such as: CATEGORY TWO Sublist Item 1 (list of items relative to the CATEGORY Sublist Item 2 CATEGORY ONE Sublist Item 1 Sublist Item 2... Code snip: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=XXXXXXXX" SelectCommand="SELECT * FROM Categories" > </asp:SqlDataSource> <div class="catbox clear" > <asp:Repeater id="aa" DataSourceID="SqlDataSource1"

  Posted to Data Presentation Controls (Forum) by oldbcells on 11/27/2009

• Re: Changed service accounts - SQL Server 2008 Standard

  Ha! ... sometimes the answer is right in front of you ... Added the 'NETWORK SERVICE' account to the database as dbo RESOLVED

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by oldbcells on 8/8/2009

• Changed service accounts - SQL Server 2008 Standard

  Following best practices I have changed the default account (NETWORK SERVICE) for the various Sql Server services to a lower rights account .. services start and run fine however I am having difficulty with web application (DNN) establishing a connection. I have also, during install, opted for Windows Authentication only with the default 'sa' account disabled (actually this is by default with SQL Server 2008 standard) I have also settled on using a named instance as well but am using (I believe

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by oldbcells on 8/7/2009

• Re: Changed service accounts - SQL Server 2008 Standard

  With my unique values of course ... Server = myServerName\theInstanceName; Database =DotNetNuke ; Trusted_Connection = True; Connection Error(s): Index #: 0 Source: .Net SqlClient Data Provider Class: 11 Number: 4060 Message: Cannot open database "DotNetNuke" requested by the login. The login failed. Index #: 1 Source: .Net SqlClient Data Provider Class: 14 Number: 18456 Message: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. I'm thinking that if I change the service

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by oldbcells on 8/7/2009

• Re: Retrieving GridView nested EditItemTemplate TextBox control value

  Throws a fit at: int index = Convert.ToInt32( e.CommandArgument ); In Detail: System.FormatException was unhandled by user code Message=" Input string was not in a correct format ." Source="mscorlib" StackTrace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.String.System.IConvertible.ToInt32(IFormatProvider

  Posted to Data Presentation Controls (Forum) by oldbcells on 10/5/2008

• Re: Retrieving GridView nested EditItemTemplate TextBox control value

  I am using OnRowCommand as my event handler..here is code: Page code: <asp:GridView ID="GridViewMUNICIPALITY" OnRowCommand="GridViewMUNICIPALITY_OnRowCommand" runat="server" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="IDnum" DataSourceID="SqlDataSourceMUNICIPALITY" ShowFooter="True" CellPadding="5" CellSpacing="5" Font-Bold="True" Font-Size="Large" HorizontalAlign

  Posted to Data Presentation Controls (Forum) by oldbcells on 10/5/2008

• Retrieving GridView nested EditItemTemplate TextBox control value

  I have a lookup table parsed to a gridview. all good The gridview has update and insert capabilities. all good On update(edit) of an item in the lookup table I would like to also update any records of a main inventory table that contains the old lookup value. Specifically, how can I retrieve the initial column value from the gridview prior to edit to pass on to an updatecommand? <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Name"

  Posted to Data Presentation Controls (Forum) by oldbcells on 10/4/2008

• Re: assigning button control text ... but with a curve

  UPDATE: Just want to update, sometimes the obvious eludes us. With regard to my original problem of joining string to databound variable this is the preferred method. So simple.. it's stupid Rather than conjuring the select statement (which indeed will work), do the string build within the inline code block ...duh! <asp:LinkButton commandname="DView" runat="server" Text='<%# "View Details of " + DataBinder.Eval(Container.DataItem, "ID") %>'

  Posted to Data Presentation Controls (Forum) by oldbcells on 9/24/2008