I'm stuck on what might be some simple ASP.NET syntax: I have a page that allows a user to enter a code into a textbox, and then checks that code against a database table to return the values of one specific table row (if the code was corre ...

I have the following: Dictionary<int, List<DataRow>> fundValues What I need is based off the very first record for a column called "ValueFooted", I need to find out the type this column is (already know it is a ...

Hi! My app sends search queries into the Opera. Sometimes if there are special symbols like "&" I have to do the following: [code] string searchQ = label1.Text.Replace("&", "%26"); Process.Start(@&qu ...

i'm trying to get the summerized date from join query using aggregate function count() and left join [code] select Catagories.FieldId,Catagories.BookField, BookTitles.FieldId as"btitle" from Catagories left join BookTitle ...

I am having trouble displaying data form my query. Here is the deal. I have two tables table users userID firstName lastName table website websiteID website username password clientID and here is my code. my issue is tha ...

Hi I'm doing a winform application and uses a gridview, a textbox and a button in VS2005. I'm trying to make a query that gives me all lastnames starting with the letter I enter in my textbox. It works for me to enter a complete lastname ...

hi i m trying to add a record in a table an auto serial no is generated for that record i need to add some more records in other table but i need that serial no as reference so after insert i try to read back that value but giving me error ...

I'm fairly new to c# and even newer to these forums. So, please bare with me while I try to explain what I'm needing to do. I have 800+ different databases all located under 1 parent folder. I need to run a query for each of the database ...

Hi all I'm doing a winform appl. in visual studio 2008, and I would like to know if someone can please help me? I have a sql server database and it's easy to bind for example all names from the database to a listbox, but what if I want t ...

Hello, I'm trying to read data from some AS400 tables. The connection itself works perectly fine, but whe I try to read the table I'm getting an error saying: "[b]SQL0666 SQL Query exceeds specified time limit or storage limit[/b]& ...

I have this code that returns a caseID from a table. This table also has a column "LastName". I want to search on caseID and return LastName but I don't know how to code it. I've been on the microsoft site looking for LINQ to S ...

Does anyone know how to get the adspath attribute value to a better looking string. Active Directory returns the following: "LDAP://contoso.com/CN=Sanch01R,OU=Managers,OU=Users,OU=InfoTech,DC=contoso,DC=com"; I would like it ...