I want to display a column in a datagrid such that each item/row in that column acts as a hyperlink. Further, when I click on the hyperlink, it doesn't redirect to another page or even to itself. Rather it "POSTS" pack to itself, and fetches the values in the entire row into the textboxes displa...more >>

Hello I made a windows service that monitors the nic's on one of the servers. Problem is that the service is using way too much memory. It starts with 11MB without any ADO objects loaded. After it updates the DB a few times, its on 18MB and later even 32MB Is there any function/method th...more >>

Hi I have an INSERT SP and would like to pass the table name as parameter. How can I do that? Here is the SP that is working fine but for a predefined table name ALTER PROCEDURE ThrottleLog ( @EventID int, @Category nvarchar(64), @Priority int, @Title nvarchar(256), @Timestamp...more >>

Hi all, I posted this in the EnterpriseDevelopment.SQLServer.Programming group and got a reccomendation that I post it here too. This is probably a no-brainer, but I'm having a heck of a time trying to form my question the right way for the search engines to return anything meaningful. ...more >>

Hi, I recently completed a tutorial that allowed me to use Indexing services to search for a word document then display an abstract of the document and its title. link to indexing tutorial http://weblogs.asp.net/cazzu/archive/2003/08/27/25568.aspx As part of an application I am writin...more >>

Hi everybody, I have a problem marking a row in a DataTable as to be deleted. The code I use (C#) is... // Get the row to be deleted, returns a DataRow-object DataRow myRow = CurrentDataRow(); DataTable myTable = (DataTable)DataSource; myRow.CancelEdit(); myRow.RejectChanges(); m...more >>

What is the difference between View and StoredProcedrue when both all fetch data form database. ...more >>

i made a class that requires transaction (enterprise services) when instantiating the class i get the following error: Additional information: The assembly 'C:\\northwind_test\bin\northwind_test.exe' does not have a strong name. must i make a strong name in order to inherit servicedComponen...more >>

or this is the newsgroup to ask dot-net com+ questions? ...more >>

Hello, i have lets say a simple sqlCommand with text: Select * from test where sColor = @sColor Now i instantiate the sqlCommand and add the parameter with value "blue" for example. Now I want to get the commandtext as "cleartext" without having the @ parameters but instead the valu...more >>

Hi, I'm new to the ASP.NET /.NET programming so excuse my very basic question. I was trying to write the Hello World Application using ASP.Net using C# in Visual Studio.Net When I debug the application I get the error..... "Error while trying to run project. Unable to start debugging on t...more >>

Hi, Hope somebody can help me with this. I have a Dataset and BindingManagerBase declared :- ******************************************** Private dsData As DataSet Private bmData As BindingManagerBase ******************************************** The dsData is fill by an oledbadapter upon ...more >>

hi, I have a question regarding the following senario: I have a query (not a stored procedure): "SELECT memberID, email from tbl_User Where login = @login" And then I use the addWithValue method new to 2.0 to add it like the following: cmd.parameters.addWithValue("@login", login) ...more >>

Folks, This is probably a question of best practice. In many places in my code, i've started a transaction (using the BeginTransaction() function on my connection object). I then create a DataReader and start going through my while (myDataReader.Read()) loop. Inside of this loop, i need to...more >>

The .NET framework includes CodeProviders for C# and other languages to simplify generating source code. Does anyone know of a product or open source project that provides the same concept, but for the SQL language. Given the vast number of databases out there, it makes sense to me to crea...more >>

I have an application and Access DB that i deployed. the machine that the app and db are installed on is about 5 hours away and i don't have Access to it. I have to update one of the stored queries that i created in the DB itself and i am trying to come up with a simple way to make the change ...more >>

I'm using a dataset to store user settings in Isolated Storage. I have a method, GetSettng(settingName) which returns a setting for a given settingname. I want to return default values for a setting if they have not been initialized (set) yet, so I need to know the datatype of the datarow it...more >>

Hello, I want to pull information from a table in sql server, bind it to a grid and update those values. I would like to know the best way to do it. I used the configure data adapter wizard and it came up with a crazy stored proc. As in this example I would only update [start date] and [descrip...more >>

I have done many projects in VB 6.0 mostly database related. But when i transfer in .NET platform, i wonder about disconnected dataset. I know there is many many advantages of Disconnected dataset. But what can i do when i make a project which shows stock exchange share prices or other sort of...more >>

Hi all Right here is the deal. I want to compare 2 data tables and return the differences. These are the details 1) I populate a datatable from a sql stored proc 2) I run the stored proc again & now I want to compare the new data to the original datatable & return only the differences, ...more >>

Hi, Can someone please tell me if ado.net datatables are efficient for searching? I am thinking of a model whereby at intial startup, I populate 'all' of the data for the application into a multi table dataset (say 5-10 tables each holding between 1000 and 100000 rows). During execution, ob...more >>

the OnItemDataBound event is called on initialisation of each row in the grid how can i stop this event when loading the grid for the first time?...more >>

Hi folks I've already posted this problem, but the description was not good enough. So I try again. In the datasources of the my computer I have created a odbc-datasource named Test1. The first test was in Access: So I made File-Import Data, then choosed odbc-computer sources and selecte...more >>

Hi folks I've already posted this problem, but the description was not good enough. So I try again. In the datasources of the my computer I have created a odbc-datasource named Test1. The first test was in Access: So I made File-Import Data, then choosed odbc-computer sources and sele...more >>

RegEx heros, I want to validate a certain field such that it shouldn't contain the percentage character (%) or the asterisk character symbol (*). The specification is that: (1) The field must not contain the percentage symbol; AND (2) The field must not contain the asterisk symbol. It sh...more >>

What should one pass as a field value into a table in the insert statement if the value contained a percentage symbol (%) or the asterisk symbol (*), since both of these have special wildcard meanings. What if I want to pass the special meanings and pass them as literals? Is there any escape cha...more >>

Good morning, I've the following error Syntax error in INSERT INTO statement But I do not found any error in this code OleDbconn = new OleDbConnection(sConnessioneDb); string insertCmd = "insert into Organizzatori (NomeUtente, Password, Nome, Cognome, IndirizzoPostaElettronica, ...more >>

I have a problem with a typed dataset. First I wrote a simple program that fetched one table from SQL Server 2000 to an UNTYPED dataset. Let's say, the table was called Table. 1. I added an untyped dataset in designer 2. I added a table to the dataset, called it Table 3. I added columns to Ta...more >>

I am currently having a problem with a application that makes use of web services. The program has a datagrid that gets it's dataset from a method in a web service. The datagrid has 3 columns, two datetime and one double. When it displays the datetime columns it is only displaying the date ...more >>

We are in the inception phase of architecting a .NET based multi tier application. Due to the .NET technology advancements, we have decided to go with .NET 2.0 beta 2 for development. One of the objectives is to support multiple databases (SQL, SYBASE, ORACLE and DB 2). We are consideri...more >>

When I try to run this through my form, SQL Server I says "Incorrect syntax near 's'. Unclosed quotation mark near ')'." I see that whenever I have a ' in any text field, it screws up my sql syntax. (look at Harrel's Ferry Rd in the insert statement). How can I fix this? Sometimes I need to ha...more >>

I'm populating a DataSet using a stored procedure.When I have at least one record returned I can add a new row to the DataSet, but if I don't get any records and I try to add a new row I get "No table defined", or something like that. How can I get the table created with the necessary column...more >>

On a VS.net 2003 aspx page I want to upload a graphic file into an Access database. The field name is FileData and the data type is OLE Object (should be good for 1 gig) When I upload a file (gif file about 78 kb) I get the message from the server: The field is too small to accept the amo...more >>

Hello, I'm using access database and there is a table and it has a field type is DateTime. Question-1 ) I want to save date and time in the database but While saving DateTime variable(in csharp) time isn't saved. Question-2) After saving date and time, I want to get this date and time...more >>

Hi, I am trying to cache sp parameters. The following is my code: Public Shared Function GetParameters(ByVal proName As String) As ArrayList Dim context As HttpContext = HttpContext.Current Dim parms As New ArrayList() If context.Cache("spCac...more >>

Problem: Can't get data retrieved from either a stored proc or enbedded sql to return updated data. For example if I change the data through sql navigator (a replacement tool for sql Plus) and retrieve the data, it doesn't reflect the changes?? Yes, I'm creating new instances of connectio...more >>

Hi- i have been struggling with porting a large VB6 project over 55 forms, 5 data environment objects, each with 50-100 commands (over 30 total), plus all the hand-coded connections, commands and recordsets where applicable. And with the Crystal Reports XI RDC, now a total bitch to deal with. ...more >>

this is a nice site, how can i put a graphic in the URL like this site? http://www.windowsformsdatagridhelp.com/default.aspx?ID=886bba68-8a2f-4b99-8f66-7139b8970071...more >>

do i have to use a DataTable inside of a DataSet? what exactly is the difference between them? i am trying to add a DataRow to a DataTable, then reference that row so that i can assign values to its columns. however the row addition seems to be failing, stating that the index is out of range. ...more >>

Getting many of these errors on our v1.1 SP1 web applications across multiple servers and different applications talking to a SQL 2000 SP3a cluster. This problem is also accompanied by many errors in the SQLClient TdsParser code such as: Byte array for GUID must be exactly 16 bytes long. ...more >>

I am built a massive set of if/else if statement to examine different OleDbType types. I would like to make this into a switch, but that only seems to work on Int and String. What is a better way to do this? Thanks. ...more >>

Hi all, I have the following terrible problem: 1. I have the following SQL statement: "SELECT stringX FROM tableY WHERE datetimeZ > @datetimeZ" 2. I create a data SQL Server data adapter with a parameter of DbType DateTime. 3. Then I run it with value "1.8.2005 3:30:37" and this is what ...more >>

Here's what should probably be a a simple DataSet question I have queried a dataset from databaseA and now I want to insert its contents into databaseB. If I do a DataAdapter.Update(), it only stores rows added since it was queried from databaseA - which is understandable as it thinks that...more >>

Hi, I've bound a Datagrid to a Dataset, which works OK, however the update isn't working correctly, I think the problem may be that I am using a DataAdapter generated with a wizard with stored procedures to select and update. The binding code works OK, combining a number of tables into a ...more >>

I have two tables of scores of student: The Fields of the two table like: Table1:StID, Math, Nature Table2: StID, GradeID, Math, Nature When I update the sore in Table1 form Table2 where Table2.GradeID=2 Update Table1 set Table1.Math=(Select Math from Table2 where Table2.StID=Ta...more >>

I have a stored procedure that returns a recordset as well as an output parameter. When I use ExecuteReader and then try to get the value of the output parameter I get an error saying "Object reference not set to an instance of an object.". Is it not possible to get a datareader and output par...more >>

MS SQL here is what the connection string looks like (i changed the username and password for security) <add key="datasrc" value="Initial Catalog=db1;Data Source=192.168.1.1;UID=abc;Pwd=1234abc" /> rafael "Rafael Chemtob" <rchemtobb@nospam.yahoo.com> wrote in message news:OA2UMgzrFHA.2348@t...more >>

hi i have a web.config file that specifies the connection string for my database. the database server on the ISP is using a different port than 1433. how do i specify in the connection string to use a specific port number? i tried the <ip address>:<port number> and that didn't work. any idea...more >>

I formated my webserver and i installed in it Oracle 10G server, and ..Net framework with IIS. My application was working perfectly in the old server, now the application is throwing ORA-12514 exception, but when I start the SQL Plus it works perfectly. It occurs only in the ..Net application. ...more >>

Hi, I created a dataset that contains several datatables. I'd like to know how to query data from these tables, like table join in sql? thanks in advance...more >>

Hi, I'm trying to use parameterised stored procedures to select, and eventually update, a sql server database. But i'm not sure i'm passing the parameters correctly into the sp as no rows are showing in the datagrid. Here's the code: int intUserNo = (int)(Session["usrNo"]); string strPatie...more >>

What I have is a table (Clients) that I have created 2 relationships (FKs in DB) pointing to another table (Setups). I have a BillFrom Client and a BillTo Client. I get a compile error: InvoicesTDS.cs(2839): The class 'BusinessEntities.InvoicesTDS.Setup' already contains a definition for 'Cl...more >>

Hi, For any of the microsoft guys : Is there a way to tell ADO.Net to use a default value from the stored procedure ? I know the only way to do it is to not create the default parameter at all in the command but i am looking for an elegant solution to tag it to use the default value from ...more >>

Hi, I am a csv file into a typed datset using the OLEDB provider. However when the file is read into the dataset via the dataadapter fill method my field lose there leading zeroes. I have set the columns in the typed dataset to strings to avoid a conversion to a numeric value but it seems t...more >>

Hi I am trying to get Data from ODBC into a Datagrid. This is the very simple code i am using: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim odbcConn As New Data.Odbc.OdbcConnection("DSN=Muschi;DBQ=X:\SBDATEN;SERVER=No...more >>