Thanks for some support or suggestions. I am using the SQLDataReader to fulfil a Stored Procedure that accepts digit parameters (BuildingTID and Department) to convey the appropritae Value in my housing The Director of the Department. My difficulty is I intend the mass nonachievement when I separate the cipher that I additional beneath for review. Let me also add that the individual is selecting the values that I am using for the stored machine from 2 DropDownLists. I am effort it when I essay to distribute the continuance that is in the Department DropDown itemize to the prototypal parameter.
Dim myParm As SqlParameter = getDirectorsCMD.Parameters.Add(”@BuildingTID”, SqlDbType.Int, 15).Value = (ddlDepartment.SelectedValue)
Also apparently there are more issues with my cipher than meet the nonachievement because the datareader records concept is simulated message I am not backward a row
Related posts:
- DATAVIEW CONTROL NOT APPEARING Hello, I have the following code in place: Dim Code As String = "" If Request.QueryString("Code") IsNot Nothing Then...
- STOREDPROCEDURE RETURNING ZERO INSTEAD OF VALUE Hello, My stored procedure is returning zero....can anybody correct me.... Stored Procedure - ALTER PROCEDURE dbo.GetRowCount (@count int output)...
- HOW TO USE POSTBACK? I have written an exercise which is a UserDatabase with register/login and update/delete buttons. I display my data in...
- ERROR WITH STORED PROCEDURE Hi, I have used sp's plenty of times and never had this problem before. I am trying to execute...
- UPDATE STORED PROCS I have over 40 stored procs (all for update method) and they all take different sets of parameters to...
- IMPROVE PERFORMANCE WHILE DOING EXECUTE NONQUERY Hi, I have web application in ASP.NET 2.0 and C#. I have a gridview and i have a checkbox...
- PROBLEM WITH GUID.NEWGUID() GETTING EMPTY GUID IN VB.NET I am working on a website in VS2008 using VB.Net, i am generating a UserID using Guid like below...
- HOW TO LOOP IN A LIST OF PARAMETERS I want to wrrite a stored procedure that will loop in a list of parameters(I get them using dbo.ParmsToList(@ssn_list,...
- DROPDOWNLIST INSIDE FORMVIEW ON INSERTITEMTEMPLATE PROBLEM. Hi.First let me say what is the problem and then how i'm solving it so far. I have a...
- WHY DOES THE IMAGE NOT UPLOAD TO THE SERVER Hey, I have the following code:- try { string conString = "Data Source=SQLB23.webcontrolcenter.com;User ID=wbsd;Password=*****"; SqlConnection empConnection = new SqlConnection(conString);...
Tags: director, sqldatareader
