I am trying to run a stored proc from this function. When I run it thorugh the debugger I can see that myReader.HasRows = true and myReader.FieldCount =14.
But the control does not go in the loop while (myReader.Read()) where I am trying to read Version field returned by the stored proc.
[Code]....
I am trying to create a search page, this allows the admin to search through the entries in the database by certain criteria, such as province (like state but diff country)
Here is the code I have so far. The problem is that I am not getting any errors. But I am also not getting any results. The page just posts back and returns to the blank search page. The GridView does not display any results.
here is my code as it stands:
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.Configuration
Partial Class administration_Search
Inherits System.Web.UI.Page
Protected Sub ProvinceButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ProvinceButton.Click
'get the search string from text box
Dim Search As String
Search = ("%" & ProvinceButton.Text & "%")
'if the string has value then continue with search
If Len(Trim(Search)) > 0 Then
Dim con As String = WebConfigurationManager.ConnectionStrings("fubar").ToString()
'build sql string
Dim s As String
s = ("SELECT id, surname, name FROM orders WHERE province like @strSearch")
'declar connection
Dim c As SqlConnection = New SqlConnection(con)
'add command
Dim x As New SqlCommand(s, c)
'add parameter
x.Parameters.AddWithValue("@strSearch", strSearch)
c.Open()
Dim r As SqlDataReader = x.ExecuteReader
GV.DataSource = r
GV.DataBind()
c.Close()
Else
Province.Text = ("Please enter search terms")
End If
End Sub
End Class
On the .aspx page I have a textbox (id: province) and a button (id:submit)
I'm trying to convert some code from VB to C# on a site i'm working on and can't seem to get the arraylist to function properly.
Here is what we currently have in the codebehind:
[Code]....
Which we then call from the page using:
[Code]....
I want to convert this to C# as the rest of the code on the new site is in C# and I'm having problems with the ArrayList. I've got the other parts of the code all converted fine it's just the GetContent Function that isn't working right. Here's what I have:
[Code]....
I got an error on the "objSDR.Item" part of the code saying "SqlDataReader doesn't have definition for Item" and so if I changed this to the code above. Only problem now is I can't call this from the page using the code below as there is no "Item" in the GetContent Function any more
[Code]....
[Code]....
In SQL Server 2008 bit is like boolean (true/false), but I tried to read the bit value (0 or 1) and got error. How can I read it?
[Code]....
how to read data from the sqlDataReader .
sqlDataReader sdr = sql_comm.executeDataReader();
if(sdr.hasRows)
{
while(sdr.read)
i=0
[code]...
Why SqlDataReader Class object is not created by "new" Operator.
Is it not possible to create the object like below
SqlDataReader dr=new SqlDataReader();
dr=cmd.ExecuteReader();
Why the constructor of the SqlDataReader class is internal?
[Code]....
My question is how do i use SqlDataReader to read the last row added to a table getting the contents of a column and storing it as a c# varaible
When I am using SqlDataReader class on that time without creating instance of the SqlDataReader Class I m using Command.ExecuteReader() Method. Why We not create the object of the SqlDataReader Class by using " new " Operator.We use like below:
SqlDataReader dr=cmd.ExecuteReader();
Why not we use this class like below:
SqlDataReader dr=new SqlDataReader();
dr=cmd.ExecuteReader();
When using the DataTable.Load(SQLDataReader) method, if the datatable is a property of a class, the set method is not called to populate the object. For example...
MySQLDataReader = command.ExecuteReader();
if (MySQLDataReader.HasRows)
myObjDataTable.Load(MySQLDataReader); -- The result of this will be 0 rows returned. The "Set" method of the object is never called.
I have several methods where I return a SqlDataReader to populate Gridviews, Listview, etc. I get random "Timeout expired" errors regarding connection pooling, so I decided to add using{} to my methods. The lack of using is a carry over from my more beginner days.Below I included the before and after code. The after code always gives me the "Invalid attempt to call FieldCount when reader is closed" error. I have tried various combination of using{}, but ALL result in the same error.What am I doing wrong? Also, from the code below what is the best way to structure this code to ensure no connection leakage?Before:
[Code]....
After:
[Code]....
I know it is recommended to use a using statement with a sqldatareader, but I was wondering if it is necessary when you are setting the datasource of a control to a datasource directly. in some places in my code I do this.
using (SqlDataReader reader = getReader())
{
while (reader.Read())
{
// do stuff with data
}
}
when binding to a control I do this.
ddlCustomer.DataSource = getReader(); // get Reader returns a sqldataReader
ddlCustomer.DataBind();
In the second case, do I need to use a using statement. Do i have to first declare an SqlDataReader in a using statement, then set the DataSource to that object. Seems like more clutter in the code, so i was hoping binding to the SqlDataReader disploses of the SqlDataReader.
I have the following query:
[Code]....
The results look like this:
DocumentNumber NIIN QtyReq AvailBalance
12345 015551212 2 5
12346 015551212 1 5
12347 015551212 3 5
12348 015554787 10 12
As you can see, the first 3 documents are for the same NIIN, and their total QtyReq is 6, however there are only 5 Available for this NIIN.
I need a way to remove the document 12346 because it cannot be filled, the other 2 document can though. I cannot figure this one out, but it seems like it should be pretty easy.I am using MS SQL Server 200
I would like to loop through my result set and generate a menu structure like this:
pagetitle
pagetitle
subtitle
subtitle
pagetitle
pagetitle
So far I have the following code but it doesn't generate the menu?
While reader.Read()
' set title
sitetitle = reader.Item("siteName")
mydata &= reader.Item("pagetitle")
' check subtitle exists, if so, build menu, loop though subtitles somehow?
if not IsDBNull(reader.Item("subtitle"))
mydata = "<ul>"
mydata &= "<li>" & reader.Item("subtitle") & "</li>"
mydata &= "</ul>"
end if
End while
Qeury and result set below:
sql:
SELECT subpages.subpageid, pages.pageid, sites.sitename, sites.siteid, pages.siteid,pages.pagetitle, subPages.subtitle FROM pages LEFT JOIN sites ON pages.siteid = sites.siteid LEFT JOIN subpages ON subpages.subpageid= pages.pageid WHERE sites.siteID = 1 ORDER BY sites.siteid, pages.pageid, subpages.subpageid ASC
results:
subpageid | pageid | siteid | siteid | pagetitle | subtitle
NULL 1 SCHS 1 1 Sandwell Community Healthcare Services NULL
NULL 2 SCHS 1 1 About Us NULL
NULL 3 SCHS 1 1 Your Services NULL
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 1111
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 2222
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 333
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 44444
NULL 5 SCHS 1 1 Single Equality Scheme NULL
NULL 6 SCHS 1 1 Diversity Strands NULL
NULL 7 SCHS 1 1 Equality Impact Assessments NULL
NULL 8 SCHS 1 1 Quality and Safety Committee NULL
NULL 9 SCHS 1 1 Contact Us NULL
I have objectDataSource connected to report viewer.
This datasource have a select method to filter the results by Dep_id parameter
Now if i want to include all results(All Departments) what should i do ???
I am trying to find out if there are records in a table
based on the results of the query.
I have this that is not working
The query works but the problem is validating the resutls
MembershipUser myUser = Membership.GetUser();
Guid userIdPosts = (Guid)myUser.ProviderUserKey;
int currentThreadid = Convert.ToInt32(Request.QueryString["Threadid"]);
var query = from t in context.TrackLists
where t.UserId == userIdPosts && t.ThreadID == currentThreadid
select new { t.UserId, t.ThreadID };
foreach (var results in query)
{
Guid queryUserID = results.UserId;
}
if (queryUserID == null)
{
}
I am trying to populate the textbox with store procedure results.I am getting the Error As Follows :
There is already an open DataReader associated with this Command which must be closed first.Here Storeprocedure i m using n my C# Code.
Store Procedure:
ALTER PROCEDURE GetAllHolidaysByUser(
@FirstName nvarchar(30),[code]....
I just want to display the results of store procedure by any means.I dont know who to populate Gridview using the store procedure by giving two input paramters.
I have a single column returning SQL data source and I want to use the data for a simple if statement, but for the live of me I can't figure out how to do it. *oh for the old days, I wrote the same thing in simple asp in about 45 seconds*
[code]....
For the life of me I can't figure out how to get that data into a variable or any way to access it. I know its probably simple. I have tried functions, etc off the net but everything I try results in another error.
I have this LINQ query:
var agnts = (from a in db.agents select new { a.userid, a.name }).Take(10);
How can I get randomly get 10 records from my agents table?
I have tried:
agnts = agnts.OrderBy(n => Guid.NewGuid());
but this doesn't seem to do anything.
I was trying to find out how to search a repository and ensuring the results returned are only for the items in the repository which match the search text. For example:
[Code]....
Where i have "where s.SupportIssueID.... I want only the results which have an ID that matches or is LIKE the given "searchText". I thought I could use s.SupportIssueID.Contains but this isnt available in the helpers.
pull data from 3 databases, same query with the same result set (data can vary) and i want to combine those results in to a single datareader so i can easily dump it to a gridview.
View 2 Repliesim new to linq and im having lots of trouble creating complex queries.. My problem mainly is that i am using Linq as a BLL.
i created a dbml (with namespace called DAL) file with 2 tables with a one to many relation. Pop and City. There is a forgien key in pop that points to a city. I also created a class called Pop that inhertis DAL.Pop. Now in my ASPX page, i want to call a function in the Pop class that would retrieve some Pop according to its ID, but i need the city name as well.. Ive been going around this in circles for days. I dont know how to write the Linq syntax and i dont understandd how my function's signature should be like.. I want to recieve a table that i can bind to a Gridview and preferable, specify which coloumns to bind.
Lets say I had a query like SELECT Name FROM Customers WHERE CustomerID = '1'
How could I show the result in a textbox?
Is it possible to assign the SQLDataSource.Select results to the LinqDataSource results ?
View 1 RepliesI'm trying to tie my login controls to my externally hosted database. I used the aspnet_regsql tool to create the appropriate tables in the database, but when I try to administer them through the "Administer Website" smart tag on the login control I cant connect to the new tables and such in the "Providers" tab.
View 5 RepliesI have a SQL server job that executes msdb.dbo.sp_send_dbmail procedure and sends an email. I have specified the query and the query results appear in the body of the email as expected. All i need to know is how to remove the dashes beneath the column names. For instance, when I receive the email with the query results, they look like the following
UserId UserName
1 Rob
2 Paul
How do I remove those dashes underneath the column names?