Fastest way to move XML document into and back out of CLR function In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml data type variable into a C# CLR function and retrieve it back out of the C# CLR function when the C# CLR function is done modifying it? I tr...more >>

October 31, 2007 Hi all Can someone point me out to a site with some good examples of data file manipulation. Thank you Mike TI ...more >>

Oct 31, 2007 Hi all Sorry for repeating my previous posting. I am new to VB Net. Q1. Which provider should be preferred when defining a connection, Data provider for SQL server or Data provider for OLEDB. I intend to use SQL Express 2005. Q2. I have a database on my local PC (SQL Ser...more >>

Oct 30, 2007 Hi all Using VB.Net 2005 & SQL 2005. I tried to use a database on my local PC and a remote database. Now is there a way I can make the connection string flexible. I tried to change the connection string in the APP.CONFIG file however I was not successful. It would be nice ...more >>

We have a several vb.net apps, that were recently upgraded from Framework 1.1 to Framework 2.0. Randomly these apps have started throwing the error below, the line of code is a connection.open, the connection string has a timeout of 500, which should be plenty of time. All of the apps use the...more >>

Hi Using SQLServer2005, connecting via sql server authentication. In the Instance I created a database (MyDatabase) and a Login. In MyDatabase I created a schema (MySchema), Tables (attached to MySchema) and a User (based on the Login). I set the Login's default database to MyDatabase. I ...more >>

I'm making changes to a small, portable, single-user database application I wrote a couple of years back built around a muli-table Access database and written in C# and .NET 1.1. Most of the changes are are minor, but one involves "subsetting" the database, that is, creating a new database fi...more >>

Ok, bear with me. This is a bit lengthy. This roughly explains a real-life legacy data structure problem I’m having. Assume a SQL Server 2000 database with 2 tables, Table1 and Table2. Table1 has fields id1 (Integer, primary key, but NOT an identity field) and content (varchar 10). ...more >>

Using asp.net and .net framework 2 and SQL server 2000 I am using simple SELECT statement in SP to retrieve data and then bind to a datagrid but fail to pick up the first record in the dataset: invConn = New SqlConnection(ConfigurationManager.ConnectionStrings("Connectstring").Connec...more >>

Hello When i fetch data from database i do the following: DataSet ds = new DataSet(); OledbConnection con = new OledbConnection(ConnectionString); using ( OledbCommand cmd = con.CreateCommand()) { cmd.CommandText = "SELECT * FROM [tblCustomers] WHERE [CustomerName] LIKE 'A%';"; ...more >>

Hi EveryBody: What is the data type that I have to use when I want to save mix data in database for example photos,music,text fiel,doc file and movies ? any help will be appreciated regard's Husam...more >>

Dear all, What is the best way to compare 2 dataset ? What I mean by that is not comparing that its teh same object but allso that rows data values in both . In other words I need an effeective way which tells me if records between 2 dataset are the same or different thnaks for help ...more >>

I have a checkbox (along with textboxes) that I am trying to use as a databound control to an integer field on a database. I am using Format and Parse with the checkbox to write -1 to the database if the checkbox is unchecked and 0 if checked. I am finding that the Dataset and Database are not...more >>

there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is this? I have a simple wraper around System.Diagnostics.Stopwatch.GetTimestamp() : public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction] public static lon...more >>

(Reposted from Winforms forum. Not sure where this belongs.) I'm writing a Winforms project in VB/Dot Net 2.0 and I'm having some trouble handling the DataError event. The grid is bound to a filtered binding source. Add is enabled. Part of the primary key is set by one of the cells ...more >>

I am using the same code to query different databases, one SQL 2005 and the other SQL 2000. The query contains a date paremeter @Date... Me.SqlSelectCommand1.Parameters.AddRange(New System.Data.SqlClient.SqlParameter() {New System.Data.SqlClient.SqlParameter("@Date", System.Data.SqlDbType.D...more >>

hi, is web service good solution for accesing (havily) database (remote or not)? that looks slow, any other methods for secure connection? SOme of coworkers wants to use web service because they don't want expose connection string. thanks fro advise ...more >>

Using C# 2.0 & SQL Server 2000, have a stored procedure that return 0, 1, or more rows. At least one of the columns is a date and it may null. I have created an XSD of the output from the stored proc. The entry for the nullable date column is "<xs:element name="Sent_Dttm" minOccurs="0" ty...more >>

what are the memory caps for threads running as a CLR stored procedure executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored procedure is executed by sql server 2005 then it creates 10 threads and each thread builds a giant arra...more >>

Hi What are the advantages of writing an app in vb.net/ado.net as opposed to MS Access? I need this to sell the idea to the management. Many Thanks Regards ...more >>

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I simply create a new SQL Ser...more >>

Let's say I want a read-only copy of a simple query that joins 2 tables. When I compare a DataTable (adapter.fill) and a custom List + DataReader, I see that the custom sol'n is about 6x faster and takes 5x less memory. For my test I read about 100K rows and then bind to a grid so the timing ...more >>

hi, pls can someone help me out. its very urgent i get the solution today. i have a webservice that i use to retrieve new record from a database, also there is a client application (window form) that calls this service which returns the record in a dataset. now i need to insert the record in t...more >>

I have a simple subroutine (see below) which reads a table and populates = the items of a combobox. As the subroutine is executed, I'm watching = the taskmanager and the memory in use increases; however, once I get to = the Error_Exit: logic and start to close and dispose my memory = variables,...more >>

Hi all, I'm trying to write an application that takes an Access database as template to customize a new or existing SQL Server database. When something in the template database is changed, I want to apply these changes to the SQL database. For example if new columns are added to a table or co...more >>

I have a SQL Express db with a table field defined as data type decimal(18,0). When I type in .785 in the table field it rounds it to 1. Any ideas why???? ...more >>

I have a table called Customer. I have a locator screen which is composed of a grid and a couple of search boxes. The user is going to choose which customer records to display in the grid. The choices are LastName or firstName or any part of them, Social Security Number, Status (Active,In...more >>

I have a "transaction" table with 2 columns, TransTypeId and TransAmt. Example: TransTypeId TransAmt A 100 A 200 B 100 C 50 B 100 A 100 I am ...more >>

Hello, I am writing ASP.NET application using SQL Server 2005 Express Edition. my connection string is : "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; I used connection strings syntax from www.connec...more >>

Hello, I am currently working on a project which will run in an environment, where the size of the database is very limited. That's why I thought about relying in some parts entirely on xml files (and datasets) as an DB replacement. I.E.: DataSet myDataSetToRead = new DataSet...more >>

Is it possible to install SQL Server 2005 Express on a machine that restricts installs by using ClickOnce? For example, I can't install new applications on my machine at work unless I use ClickOnce to do so. I want to be able to use SQL Server 2005 Express in my applications and move away ...more >>

Oct 20, 2007 01:00pm Hi all When you create an Ajax enabled web site, the application creates the default page with a "Script Manager". I created a Master Page. I then created a "Home" page with reference to this master page. As I wanted this Home Page to come first I added the foll...more >>

Hi all, I want to obtain column properties using C# and the System.Data namespace. Using DbDataReader.GetSchemaTable() or DataAdapter.Columns I only retrieve properties like DataColumn.MaxLength or DataColumn.AllowDbNull in a correct fashion. But if I want properties like DefaultValue or cert...more >>

I'm using DataSet.ReadXML method to populate the dataset with data from XML file. If one of the values contains apostrophe (for instance: It's something) then an error occures: System.Xml.XmlException: Invalid character in the given encoding. Is this a bug or what? I wouldn't want to parse an...more >>

Hi, I'm fairly new to ado.net and I'm not sure I'm doing this in the best way... I retrieve two tables from two different databases and place them in a dataset. Both tables have a column which relates them. The relation type is one to many. I use a custom procedure to "merge" the two tabl...more >>

Please disregard my previous post for the same problem. the posting was incomplete. I'm trying to update the data in a DataGridView control. The underlying data are from SQL Server CE database. There is an image field in the DataGridView control when U give the save command, I get the follo...more >>

I have a DataSet with 3 tables. I need to be able to filter the parent table and get all records from the 3rd level table that correspond with it. I have relations set up between the parent and first child and also the first child and it's child tables. However, when I filter the top level tab...more >>

I created a stored procedure called AddOrder which does an 'insert' statement. It appeared in the Server Explorer of Visual Studio. Then I dragged it to the Dataset Designer. This makes a QueriesTableAdapter, which I do find in the diagram when I "Edit Dataset in Designer". The problem is tha...more >>

Hello. I'm changing my code which copies data from memory to a SQL Server from using a data adapter's update method to using the writeToServer method of the SQLBulkCopy object. The update method of the data adapter worked fine, but I expect the SQLBulkCopy to perform better. The probl...more >>

How come there is no dbType='Image' available in the data adaptor parameter types? Please find the atta -- test...more >>

Hi I wonder if you can help me. I've got an asp.net (version 1.1) intranet application that connects across a network to an access backend db. The backend db is on a directory where everyone (including the ASP.Net account) has full access (not sure if that's the right way to go about things...more >>

Hi all, I'm building a Web Service to INSERT records into an Oracle DB. For this I'm using a DataSet (.xsd) with a QueriesTableAdapter, to call a stored procedure for inserts in the Oracle DB. The connection string is stored in a configuration file (Web.Config) like so: <connectionStrings> ...more >>

Hi, We have a huge table having around 29579242 Rows.The table is huge and there is no clustered index on the table. There are a couple of non-clustered indexes. We have started experiencing these errors. We increased the command timeout to 120 (2 minutes) but the error isstill occuring on...more >>

I need to add a UTF32 xml file to an XML datatype (basically I want = unicode characters in there) is it possible? When I do=20 SqlParameter x =3D new SqlParameter("@xmlX", SqlDbType.Xml); (i = tried Text or Ntext in vain !!) testclass t =3D new testclass(); t.Age =3D 32; t.Fir...more >>

Hello. Can anyone help with this one? I've written an app that queries data on two linked servers (sql server 2000). The stored procedure runs fine when I 'exec' it in management studio, but it times out when launched from VB2005. The funny thing is it worked last week - I'm just not sure wh...more >>

I'm trying to update the data in a DataGridView control. The underlying data are from SQL Server CE database. There is an image field in the DataGridView control when U give the save command, I get the following message. "@p5 : Byte array truncation to a length of 8000." Parameter correspon...more >>

I've done some googling on this one, but I'm not sure how to phrase the search. Any help is greatly appreciated. The problem is I have an xml file coming from a non-.Net source that I'm trying to load into a strongly typed DataSet. I've created the schema and then the DataSet from there. He...more >>

Hi, We do ADO.NEt programming only on the time-to time basis, so we don't have the real deep experience in this matter. Every where in MSDN or other documentation I can read that DataTable/DataSet is designated to keeping disconnected data from a database. So far, so good. But I have nev...more >>

Maybe it's FAQ, please point me to the Internet link if it's so. Do we have any way to disable this warning (below) in VS2005 when we do the code analysis? Microsoft.Naming : 'Id' is an abbreviation and therefore is not subject to acronym casing guidelines. Correct the capitalization of 'ID'...more >>

Hi, I have a DataTable object and need a subset of the rows at runtime so I perform a DataTable.Select on it to retrieve an array of DataRows. I am using this over the DataView/Filter approach as it performs slighltly better in my application. The problem is that the returned DataRow array ...more >>