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

More Search Options

RSS Available

• Re: Select in SqlDataSource

  Hi, How then can I use a parameter to return the value of individuasl colums. You mention Dataset and Datareader well and fine, if I use a datareader, how will the code be? ---This is the smaple code for SqlDataSource1 DataView dvSql = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); foreach (DataRowView drvSql in dvSql) { Label3.Text = drvSql["FirstName"].ToString(); } OleDbDataReader rdrSql = (OleDbDataReader)SqlDataSource2.Select(DataSourceSelectArguments.Empty); while

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

• Select in SqlDataSource

  Hi, I have created a datasource sqldatasource1. I have issued a select statement in a view to updating a record. --------------------Partial code SqlDataSource1.SelectCommand = "SELECT * FROM ACCTMASTER WHERE ACCOUNTID =" + Me.AccountID.Text SqlDataSource1.SelectParameters.Clear() SqlDataSource1.SelectParameters.Add("PAYERID", Me.PayerID.Text) Dim dv As DataView = DirectCast(SqlDataSource1.[Select](DataSourceSelectArguments.Empty), DataView) Dim tab As DataTable = dv.Table (tab

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

• Application Hosting

  Hi, I have created two forms for my projects which I believe is a starting point. I want to deploy the application in a stand-alone computer where a user will key in the basic account info into an access database. How do I go about this?

  Posted to Configuration and Deployment (Forum) by FrankEnem on 7/3/2009

• Re: Updating and Inserting

  I have added the code but there were errors on the following lines. pls would you explain to me what the two lines were suppose to achieve. DataView dv = (DataView)AccessDataSource1.Select(DataSourceSelectArguments.Empty) DataTable tab = dv.Table (TAB.Rows.Count > 0) Then My Code was like this: AccessDataSource1.SelectCommand = "SELECT * FROM AcctMaster WHERE USERID =" + Me.AccountId.Text AccessDataSource1.SelectParameters.Clear() AccessDataSource1.SelectParameters.Add("AccountId"

  Posted to Getting Started (Forum) by FrankEnem on 7/2/2009

• Re: Updating and Inserting

  It gave me a runtime error message : Server Error in '/' Application. Syntax error in INSERT INTO statement. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. Source Error: Line 35: AccessDataSource1.InsertParameters.Add("Userid", Me.UserId.Text

  Posted to Getting Started (Forum) by FrankEnem on 7/2/2009

• Multiple Parameters in query.string and Dataview Parameters

  I have three question 1. I have multiple parameters to pass using query.string. When I did it, I have all one parameter returned. 2. How can I pass parameters from Gridview to another wed form. I have a created a Gridview and a hyperlink (edit), I want that when a users clicks on the hyperlink it will call another form and read the table row and transfer the data in the row to another form. 3. I have a variable which I want to pass to Gridview in form of a search string that dispalys the occurance

  Posted to Data Presentation Controls (Forum) by FrankEnem on 7/2/2009

• Re: Updating and Inserting

  Hi, Still on inserting and updaing I have created the sqldatasource, 1. in the config file, the connection string has already been added automatically. 2.The second paragraph has already been added in the webform source automaitcally on creating the datasource. 3. My syntax to insert into the table is like this: SqlDataSource1.InsertCommand = "Insert INTO USERS (AccountID, AccountName)" & _ "Values(01011,Account Payable) " SqlDataSource1.InsertParameters.Clear() SqlDataSource1

  Posted to Getting Started (Forum) by FrankEnem on 7/1/2009

• Inserting records into access database

  Please I have a web form with two textbox Account Id and Account Name. I have another button submit. I want to insert the values in the textbox in the access table when the submit button is click. ------------ I have created an sqldatasource; sqldatasource1 on the webform and written this code on the button_click SqlDataSource1.InsertCommand = "Insert INTO USERS (ACCOUNTID, ACCOUNTNAME)" & _ "Values(01011,Accounts Payable)" SqlDataSource1.UpdateParameters.Clear() SqlDataSource1

  Posted to Access Databases and AccessDataSource Control (Forum) by FrankEnem on 7/1/2009

• Re: Updating and Inserting

  There is a problem ----- Before I start using the above, where do I define Sql. I try it and it gave me an error message. Please be very clear ans give me how the syntax will be. Thanks ----

  Posted to Getting Started (Forum) by FrankEnem on 7/1/2009

• Updating and Inserting

  Hi all, I have created a web form: accountfrm.aspx with two textbox controls, AccountId and AccountName. I have also two linkbuttons:submit and cancel. Action Sought 1. I want to insert the values in the form to a database table; acctmaster. When the user clicks the submit linkbutton the accountId and AcoountName will be copied from the form and inserted into the database table 2. I want also to update a record; the condition is that when a user enters accountId and AccountName and clicks the linkbutton

  Posted to Getting Started (Forum) by FrankEnem on 6/30/2009