Extended SQL Stroed Procedures

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Using ODBC to make connections I've come from a background of using ODBC DSN's on Web Servers to make connections to SQL Server I see in ADO.NET this has been dropped (cant find samples where it is used) - may it's still there but I dont see examples. Does this mean by NOT using ODBC DSN's a connection can be made faster ? Background to statment: Making the connection is the slowest part of my SQL Server based interaction Any comments would be appreciated. - peteZ Tag: Extended SQL Stroed Procedures Tag: 64453
  - 2
    - ODBC DBHandle Hi All, Is there any possability to retrieve the DBHandle (m_hdbc in MFC) from a .NET OdbcConnection class? We would need to do this because we need to call an MFC DLL for some updates in the same transaction that we started in our .NET server. TIA Thomas Bodell Tag: Extended SQL Stroed Procedures Tag: 64452
  - 3
    - OracleParameterCollection Since I've upgraded to VS.Net 2003 I receive the following message every time I want to add a parameter to an OracleParameterCollection: The OracleParameter with ParameterName <ParamName> is already contained by another OracleParameterCollection. Does anyone know why this is happenning since it was working fine on the previous version? Tag: Extended SQL Stroed Procedures Tag: 64449
  - 4
    - Getting A List Of Installed Data Providers I want to get a list of the installed ADO.NET Data Providers on a machine. The only way I can see to do this is to look at each and every assembly in the GAC and use Reflection to see whether the classes contained within have the necessary signatures which identify them as data provider classes (i.e. they support the IDbConnection, IDbCommand etc. interfaces). This seems a bit unnecessary and a bit low tech. Does anyone know of a better way ? Is there some sort of RegisterDataProvider technique which data providers have to use to register themselves which I might make use of ? Nick Carter Tag: Extended SQL Stroed Procedures Tag: 64446
  - 5
    - System.Data.RowNotInTableException - Why? Hi everybody, I am having the following problem. While running my program I create a DataRow (State - Detached). Then I add it to the DataTable (State - Added), and delete it (State - Detached). Later I try to update the db by doing this DataAdapter.Update(DataTable.Select("", "", DataViewRowState.Added)) DataAdapter.Update(DataTable.Select("", "", DataViewRowState.Modified)) DataAdapter.Update(DataTable.Select("", "", DataViewRowState.Deleted)) When I try to update the deleted records I get the following message: "This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row. System.Data.RowNotInTableException" Does anyone know why this happens? Tag: Extended SQL Stroed Procedures Tag: 64441
  - 6
    - Null and Stored Procedure How do I pass a null to a stored procedure from VB.Net. I have tried to pass nothing but that throws an exception. Here is my parameter command.Parameters.Add(New SqlParameter("@DLExpiration", SqlDbType.SmallDateTime, 4, ParameterDirection.Input, False, 16, 0, _ "DLExpiration", DataRowVersion.Proposed, DB.getDate(Me.DLExpirationDate.Text))) Tag: Extended SQL Stroed Procedures Tag: 64420
  - 7
    - using DataLink files Hi I read in the Microsoft ADO.NET book that i could use a DataLink file to store/set the connection string. It said there that I should use the name-value pair File Name=myDataLink.udl. Now i tried this when creating a connection but it creates an error when trying to run. I looked in the help files and the name-value pair is not listed their for a connection constructor. Public Class frmMeny Dim con1 As New sds.SqlConnection("File Name=DbConnection.udl") Does anyone know how to get this to work? It would be really helpful! Thanks KMS Tag: Extended SQL Stroed Procedures Tag: 64417
  - 8
    - could not find installable ISAM When I try to open a connection to Excel with this string: string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "DataSource=C:\\Worksheet1.xls;" + "Extended Properties=Excel 8.0;HDR=YES;"; con.open(); I receive this error when I try to open the connection: Unhandled Exception: System.Data.OleDb.OleDbException: Could not find installable ISAM. at System.Data.OleDb.OleDbConnection.ProcessResults (Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider () at System.Data.OleDb.OleDbConnection.Open() at RetrieveExcel.RetrieveExcel.Main(String[] args) Tag: Extended SQL Stroed Procedures Tag: 64412
  - 9
    - DataSet Merge & Expression Fields Hi everyone, I've noticed something strange using expression fields with ds merge method in ado.net. First of all, I create the schema via code. I've added also an expression column in the Contracts Datatable: col = ds.Tables["Contracts"].Columns.Add("CompanyName"); col.Expression = "Parent(CustomersContracts).CompanyName"; I don't use a data adapter to fill the dataset in fact I need to call a web service method that returns a dataset. Once I get the dataset from the webservice, I merge the data retrieved in the Contracts Table. ds.Merge(RetrievedDataSet); If I try to read the expression field for the contracts retrieved they're all DBNull. This doesn't happen if I try to fill the dataset with a data adapter. Any idea? Do I need to call something before reading the expression column? Thanks Laura Tag: Extended SQL Stroed Procedures Tag: 64408
  - 10
    - distinct selection in a dataview How can i get a dataview of a table, saiyng that i want to select the rows by a column y a distinct way for example i want to create a dataview of el the countries in a table, so a wna t to get yous the distinc value for the field country? txs Tag: Extended SQL Stroed Procedures Tag: 64406
  - 11
    - Add row, ODBC and ADO.NET Hi! I have a beginner problem and hope that someone easily can solve my problem. I want to connect to my Access database with ODBC. I have downloaded MS ODBC library for connection with ODBC from .NET. It looks like I get the data and able to add the row, but when I should update the source with the new data it doesn't work. Can you please give me a good link or tell me what's wrong below. Please help! Code: // Create a SQL statement string mySelectQuery = "SELECT * FROM Bokning"; // ... a connection string string sConnString = "Dsn=Bokning_new"; OdbcConnection oODBCConnection = new OdbcConnection(); oODBCConnection.ConnectionString = sConnString; oODBCConnection.Open(); // Create a command object OdbcCommand myOdbcCommand = new OdbcCommand (mySelectQuery , oODBCConnection); // Create an adapter, initialized with the command object OdbcDataAdapter da = new OdbcDataAdapter(myOdbcCommand); // Create a dataset DataSet ds = new DataSet("bokning_new"); // Name could be whatever // Fill the DataSet with data from the database da.Fill(ds); DataTable myTable = ds.Tables[0]; //DataTable myTable = ds.Tables(0); DataRow newRow = myTable.NewRow(); newRow["Date"] = DateTime.Today.ToShortDateString(); myTable.Rows.Add(newRow); da.Update(ds); // Close connection oODBCConnection.Close(); Regards, /Marcus Tag: Extended SQL Stroed Procedures Tag: 64405
  - 12
    - SP resulting in Timeout expired Hello, From a VB .net application I'm calling an SQL stored procedure and filling the results in an SQLDataReader, whose results are returned to an ASP .Net page. The procedure was running fine and all of a sudden it started giving this error: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. When I run the stored procedure in Query Analyzer it takes 1 sec. I tried to monitor it in Profiler by adding the Stored Procedure Events, and I found that it is getting stuck at a statement that goes similar to the following: INSERT INTO #Tempf SELECT t.SerNo, t.Name FROM #Temp t WHERE t.Value=x #Tempf and #Temp are created explicitly at the beginning of the procedure. #Temp contains around 16,000 records. This statement is not being completed. I have no idea about what the error might be from and I would appreciate any help or idea about what might be causing this error. Thanks, Grace Tag: Extended SQL Stroed Procedures Tag: 64397
  - 13
    - BUG: Object reference not set to an instance of an object. This is a multi-part message in MIME format. ------=_NextPart_000_0018_01C370AC.30E3D7F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I found this error message, when trying to login to my database, i have tow text boxes 'userid' and 'password' and a button 'login' it is working perfectly but some time it generates the error messsage=20 Object reference not set to an instance of an object.=20 What is it mean? I am using to authenticate user via stored procedure having two param.=20 Please REply ASAP. Regards, --=20 Ather Ali Shaikh Software Engineer eIntelligence (Pvt.) Limited. Ph. (+92-21) 2434070, 2415929-30 email. ather.ali@eintelligencesoft.com web. www.eintelligencesoft.com ------=_NextPart_000_0018_01C370AC.30E3D7F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2> I found this error message, when = trying to=20 login  to my database,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>i have tow text boxes 'userid' and = 'password' and a=20 button 'login'</FONT></DIV> <DIV><FONT face=3DArial size=3D2>it is working perfectly but some time = it generates=20 the error messsage </FONT></DIV> <DIV> <P><FONT face=3DArial color=3D#ff0000><STRONG>Object reference not set = to an=20 instance of an object. </STRONG></FONT></P></DIV> <DIV><FONT face=3DArial size=3D2>What is it mean?</FONT></DIV> <DIV><FONT face=3DArial size=3D2> I am using to authenticate user = via stored=20 procedure having two param. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Please REply ASAP.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Regards,</FONT><BR><FONT face=3DArial = size=3D2>--=20 <BR>Ather Ali Shaikh<BR>Software Engineer<BR>eIntelligence (Pvt.)=20 Limited.<BR>Ph. (+92-21) 2434070, 2415929-30<BR>email. </FONT><A=20 href=3D"mailto:ather.ali@eintelligencesoft.com"><FONT face=3DArial=20 size=3D2>ather.ali@eintelligencesoft.com</FONT></A><BR><FONT = face=3DArial=20 size=3D2>web. </FONT><A href=3D"http://www.eintelligencesoft.com"><FONT = face=3DArial=20 size=3D2>www.eintelligencesoft.com</FONT></A></DIV></BODY></HTML> ------=_NextPart_000_0018_01C370AC.30E3D7F0-- Tag: Extended SQL Stroed Procedures Tag: 64395
  - 14
    - binding to a field on a child form Hello, I wish to bind a textbox on a child form (frmprojectinfo) to a dataset value, I originally bound it to a textbox on the current form and it worked perfectly. ' Here is the code I use to call the child form (frmProjectInfo) dim objchild as new frmProjectInfo objchild1.MdiParent = Me.MdiParent objchild1.Show() ' Here is the code that I use to bind the child form text box to projlist(a collection), the initial value is set ok Me.objchild1.ProjectSiteName.DataBindings.Add("Text", ProjList, "ProjectSiteName") This is the code that updates the bound field on the child form, datasetprojects is a dataset Dim DrCurrentProj As DataRow DrCurrentProj = datasetProjects.Tables ("Project").Rows.Find(IntProjectId) DrCurrentProj.BeginEdit() DrCurrentProj("projectSiteName") = Me.objchild1.ProjectSiteName.Text DrCurrentProj.EndEdit() Dim objCommandBuilder As New SqlCommandBuilder (MysqlDataAdapter) MysqlDataAdapter.Update(dsProjects, "Project") 'this does not update the bound field on the child form, it does not give an error, it just remains at the initial value, any ideas. Any ideas of what I need to do to update the ProjectSiteName text box on the child name, it worked fine when it was just me.projectsitename.text, do I need to refresh the child form or something. thanx in advance Robert Tag: Extended SQL Stroed Procedures Tag: 64394
  - 15
    - Excel Transfert When i try to import excel data with Oledb. The column who have number value and blank value is not im my dataset. For the importation i do OleDbDataAdapter oCmd=new OleDbDataAdapter("SELECT * FROM [sheet1$]",strCn); DataSet oDS=new DataSet(); try { oCmd.Fil(oDS,"ExcelInfo"); dataGrid2.DataSource=oDS.Tables[0]; } Could give me an answer. What can i do in my code for having this column. Lukas . Tag: Extended SQL Stroed Procedures Tag: 64393
  - 16
    - Help? Relational data... Hi all, I wonder if anyone can help? I have a need to display some data on my web page (the results of a search) for links. Here's the thing: Each link can belong to one or more category (yes, I have a many-to-many table). When the links are retrieved, I also want to retrieve the categories the link is found in. Let's say link A appears in categories X, Y, and Z, and a keyword search brings back link A - due to the way the query is structured (inner join), link A is retrieved three times due to it's presence in categories X, Y, and Z. The question is: How do I retrieve the categories (of which there may be 1 or more for each link) along with the link? Or can't I? I was thinking of multiple selects in a stored procedure (so they could be put into separate dataset tables), but that would need some correlation between the links found in the first query (i.e. the one that finds the links) and the second (the one that retrieves the categories for the links that have been found). Alternatively, I could just cache the category table, along with the LinkToCategory table and as I'm writing each entry to the page, look up the corresponding category then - if I'm using a DataRepeater, I think I can use the Item_Created event... However, I don't really want to do that, I'd rather do it at the database level. Any thoughts? Kind regards, Mike K. Tag: Extended SQL Stroed Procedures Tag: 64386
  - 17
    - Joinview After switching from DBF to MySql, my Joinview of Microsoft doesn't work properly. I tried to figure it out, but still haven't found any solution. I looked at the relationships, the primary, the type of columns(it's a charvar).. Does anyone have the experience with Joinview and Mysql ? Richard Loupatty MIO Develoment bv Tag: Extended SQL Stroed Procedures Tag: 64384
  - 18
    - Trouble with DataRelation on self ref table I am trying to setup the following DataRelation (C#) on a self referencing table. DataRelation dr = ds.Relations.Add("MenuItemHierarchy", ds.Tables["MenuItems"].Columns["UID"], ds.Tables["MenuItems"].Columns["ParentID"]); The trouble is the ParentID was setup in the database to use int 0 where there should be Nulls to use this relationship. Is it possible to change the 0's to Null before I try and setup the relationship? That is without adjusting the database itself. Regards, Kim Tag: Extended SQL Stroed Procedures Tag: 64375
  - 19
    - Accessing RETURN values from a Stored Procedure (meant to post this SQL ADO message here instead of the C# Group) Using C#, I can access results returned from a stored procedure call OK, my question is how do you access the value from a RETURN statement in a stored procedure ? eg. In the Example below - how can I check on the Value -1000 (Customer not found) ? @CID = customer id . . . . -- Does Customer Exist ? IF NOT EXISTS (SELECT 1 FROM Customers (NOLOCK) WHERE CID = @CID) RETURN -1000 - Customer Exists, pass back values SELECT FirstName, LastName FROM Customers WHERE CID = @CID RETURN 0 thanks, - peteZ Tag: Extended SQL Stroed Procedures Tag: 64373
  - 20
    - BUG: Dataset Returned From A XML WebService Containing Error Data Caused Exeption To Be Thrown In A Window Form Application Hi, I'm working on a project which includes XML WebServices and Windows Form application. The Windows Form application will call the XML WebServices to retrieve data from database. The data will be returned as DataSet. Now, here's the problem. On .NET Framework 1.1, if any rows in the dataset returned contain errors (marked by calling the SetColumnError() method or setting the RowError property of the DataRow), I get the following error message in the Windows Form application, "There is an error in XML doument (x,xxxxxxx)" If I forced the Windows Form application to run on .NET Framework 1.0, everything works fine. Here's the partial code for the WebService project Code: <WebMethod()> _ Public Function RetrieveDataSet() As DataSet Dim ds As New DataSet Dim dt As New DataTable Dim row As DataRow Dim i As Integer dt.TableName = "TestTable" dt.Columns.Add("TestColumn1", GetType(String)) dt.Columns.Add("TestColumn2", GetType(Integer)) ds.DataSetName = "TestDataSet" ds.Tables.Add(dt) For i = 0 To 10 row = dt.NewRow row("TestColumn1") = "This is row " & i row("TestColumn2") = i dt.Rows.Add(row) ' The following code trigger the error after the DataSet ' is returned to the calling Window Form application row.SetColumnError("TestColumn1", "Error message here") Next Return ds End Function For the Windows Form application, you need to insert a datagrid control (assumed as datagrid1). It will look something like this, Code: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim ws As localhost.Service1 Dim ds As DataSet Try ws = New localhost.Service1 ds = ws.RetrieveDataSet Me.DataGrid1.SetDataBinding(ds.Tables(0), "") Catch ex As Exception MsgBox(ex.Message) Finally If (Not (ws Is Nothing)) Then ws.Dispose() End If End Try End Sub I really hope someone could help me out with this one. Thanks in advance. ps: Please, before anyone reply to state that I did not choose the appropriate groups when making this post a crossposts post, please know that I'm currently in blind on what is causing this error. Is it the WebService? or is it the ADO .Net? or is it Windows Form application? or is it VB .Net? Well, it has something to do with WebService as it only happens to the DataSet returned by WebService. It also has something to do with ADO .Net as I'm using DataSet. And it definitely has something to do with Windows Form application as if I force the Windows Form application project to run on .Net Framework 1.0, everything works fine. Tag: Extended SQL Stroed Procedures Tag: 64370
  - 21
    - Connect to Sybase Hi! I have to Connect to a Sybase Adaptive Server Anywhere 7.03 database with ADO.NET. I have connected in my app to a access-db with oledb. Now, I have to connect to a second db (Sybase). Now, I have installed the sybase asa-server. But the problem is: what does I have to write as connectionString? Now, can anyone give me a tipp, how does I can do that? Thanks very much thomas Tag: Extended SQL Stroed Procedures Tag: 64365
  - 22
    - Reading Excel files with Jet OLE DB Provider I have some ADO.NET code that uses the Jet OLE DB Provider to read Excel files. The reading of the files works okay. However, I get strange behavious when I have Excel running and run the program that reads the file that Excel currently has loaded. Excel will pop-up messages such as "File is now available for read-write." In other cases, if I use Excel to modify the file and save it, then run my program, I get the old data, not the most recent data. I think maybe I have to tell the OLE DB provider to open the file in read-only mode, but I don't know how to do that. Thanks. - Kevin Tag: Extended SQL Stroed Procedures Tag: 64363
  - 23
    - Jet 4.0 OLE DB Connection String Reference Where can I find a reference for all the parameters that you can put in a connection string for the OLE DB Jet 4.0 provider? I've been looking all over and can't seem to find it. Thanks. - Kevin Tag: Extended SQL Stroed Procedures Tag: 64361
  - 24
    - I have problems with DataSet I am using the DataSet and I have problems, when --> used a SqlDataReader dr ----> while(dr.Read()). With dataset ds ---> while(ds.?????). Thanks Tag: Extended SQL Stroed Procedures Tag: 64359
  - 25
    - Cant search Date from mySQL. Hi, I search some record(s) according to specific date which is took from datetimepicker, but a dataset.table(tbname).count is zero. here is my code. I use ODBC.net and Option strict On dim seaSql as string seaSql = "Select * from Orders where JobDate = @tmpJdate " DBCom.CommandText = seaSql DBCom.CommandType = CommandType.Text DBCom.Parameters.Add("@tmpJDate", OdbcType.Date) DBCom.Parameters("@tmpJDate").Value = seaJobDate.Value.Year.ToString & "-" & _ seaJobDate.Value.Month.ToString & "-" & seaJobDate.Value.Day.ToString) 'because mySQL date Vale = YYYY-MM-DD DBAdapter.SelectCommand = DBCom DBAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey DBAdapter.Fill(seaJobSet, "Orders") IS the code got any mistake?? I try the date value is "'" & "2003-9-15" & "'" or "2003-9-15", but it also cant work. Thanks KWOK Tag: Extended SQL Stroed Procedures Tag: 64358
- Next
  - 1
    - Access memo field problem Hi, I am trying to retrieve access memo field's data using ADO.NET, but every method described in the SDK fails to work (I tried retrieve the field using OleDbDataReader methods GetValue, GetValues and GetChars). The problem is in the size of the field. I can successfully retrieve strings which are less than 255 characters, but not more. The content of the field is always truncated. I am using .NET Framework version 1.1.4322.573, MDAC 2.8, Access 2000 Format Database (created in Access XP) and Visual Studio .NET 2003 EA. What am I doing wrong? Any answer would be really appreciated, Honza Ambroz. Tag: Extended SQL Stroed Procedures Tag: 64355
  - 2
    - Combobox and databinding Hi, I've bound a dataset to the textbox. SerieTextBox.DataBindings.Clear(); SerieTextBox.DataBindings.Add("Text", CertainSerieDataSet.Tables[0], "Serie"); When I change the text in the textbox, the text in the dataset also changes, but the rowstate remains unchanged. How is this possible? Thanks for the answers, Filip Tag: Extended SQL Stroed Procedures Tag: 64353
  - 3
    - beginner#vb.net using ado.net dear respected sir, i'm beginner in vb.net and ado.net enviornment... i would like to work and learn business(database applicatiosn area), please can any one help me solve this... i wanted to make very simple windows forms,then by programming want to create query, connection, datasets, dataadapter,databinding for using oledb but i am facing a lots problem in syntax i am stuck/dead imports system.data imports system.data.oledb private sub form1_load(......some val,ref..etc) dim cn as new oledb.oledbconnection("provider=microsoft.jet.oledb.4.0;date source=c:\northwind.mdb") cn.open dim da as new dataadapter("select * from customers",cn) dim ds as new datasets() da.fill(ds,"cutomers") textbox1.text = textbox1.databinding.add(ds,"companyname") end sub and i have some buttons add, edit, delete, update... so i can not success above...can any one help me to tell in very simple form and how to update actual datbase...in fact by using dataset it is update modify data...using datagrids...but failure in case of indvidual records on the forms...and plus only update at datasets time...not actual when i close form and open again..then it give me same no of old records... please can any one give some guidence appreciated sir urs obediently shahzad Tag: Extended SQL Stroed Procedures Tag: 64346
  - 4
    - SqlDataReader C# Index (Item Property) I have a question about what the SqlDataReader index value returns exactly (in VB SqlDataReader.Item("Value")). According to the .Net SDK this property returns: Overloaded. Gets the value of a column in its native format. I translated this as this property returns the value as it's type, so an int type in my sql database would return as an int? If this is true then I'm guess that the following code *should* run with out error. Assume current is an sql feild of type int: if ((int) this.Reader["Current"] == 0) { table += "..."; } else { table += "..."; } Are my assumptions correct? Or am I about to run into some trouble. Thanks for clarification! Carlo Tag: Extended SQL Stroed Procedures Tag: 64342
  - 5
    - Number of concurrent users Hi Is there a reliable way to place a 'number of concurrent users' limit in vb.net applications? Thanks Regards Tag: Extended SQL Stroed Procedures Tag: 64340
  - 6
    - Feedback on an article I've been working with two of my co-workers on developing a .NET content site. Anyway, writing an article is a little more difficult than I thought. How do you make sure you have the important info without boring non-beginners. How do you write important stuff without turning off beginners? Well, I'm posting a sample link of one of my first articles... and would appreciate any feedback, be it techincal, grammatical or anything else. I'm really interested in writing, but it's not been my strength (I've had enough trouble remembering to comment my code and use non-cryptic variable names ;-) ) Anyway, we have a few other articles (about 20 more on the way) but we really want to make something useful (like www.eggheadcafe.com or c-sharpcorner.com ) Any and all feedback is appreciated. http://www.knowdotnet.com/testsite/ Thanks again, Bill Tag: Extended SQL Stroed Procedures Tag: 64339
  - 7
    - Determine whether a query returns results or not (before running it) I'm writing a web-based "Query analyser" tool for our company intranet. It allows a user to type any SQL statement in a form, and execute it over the Web. The SQL can be a query that returns results (e.g: SELECT * FROM members) or it can be a T-SQL (e.g: UPDATE/DELETE/INSERT). What I want to know is, is there any way using either SQLCommand or DataSet or any of the other ADO.NET classes to determine what kind of query it is, BEFORE running it? Then, if it is a T-SQL, I can just use the ExecuteNonQuery method, and I can hide my datagrid that would contain the results. Or if it is a "SELECT" query, I can populate a DataSet and show the results in a grid. Do I have to manually parse out the SQL string to determine if it is SELECT query? Or is there a more elegant way ? Thanks! Tag: Extended SQL Stroed Procedures Tag: 64330
  - 8
    - Sorting a DataSet with related tables I have a DataList control bound to a DataSet containing two tables. How do I sort the parent table without losing my relation? If I bind the DataList to a DataView, it's no longer relational data. I'm guessing this has something to do with the DataViewManager but there is little info in help on this. -- Paul Turley, MCSD.Net, MCAD, MCT MSF Practitioner, A+ paul@createsolutions.ne_ (fix address to send mail) Tag: Extended SQL Stroed Procedures Tag: 64327
  - 9
    - Retrieving available OLEDB Providers and settings programmatically Hi there, (slightly off topic) is it possible to retrieve the installed OLEDB providers and the settings they require in a connection string programmatically, by means of the OLEDB API? I want to provide something similar to the DataLinks-dialog to end-users, but in a web browser, configuring data links for a web server. Your feedback is much appreciated, thank you. Philipp Tag: Extended SQL Stroed Procedures Tag: 64324
  - 10
    - OleDb DataAdapter Fill puzzle Hi, Working with ADO.Net/OleDb and Access2000. Using dataAdapter1 to update Access table field and dataAdapter2 to display the value from the same Access data source. Problem is, although dataAdapter1 is updating the Access table (verified in Access), subsequent calls to the dataAdapter2 Fill method do not refresh from the Access source - the value coming out of the dataAdapter2 dataset is always the same value - the one initially read on application startup. According to the documentation the Fill method should refresh the dataset from the data source - but does it? Tag: Extended SQL Stroed Procedures Tag: 64323
  - 11
    - Passing datetime as parameter throws Exception I have data field MyTime of type Date/Time in MS Access table Test. I want to add record into this table with value passed as parameter. I do the following in C#: OleDbCommand cmd = new OleDbCommand(); cmd.Connection = MyConnection; cmd.CommandText = "INSERT INTO Test (MyTime) VALUES(?);"; cmd.Parameters.Add("MyTime", DateTime.Now); cmd.ExecuteNonQuery(); Last statement throws an exception with message "Data type mismatch in criteria expression." If I pass only date part to parameter, for example: cmd.Parameters.Add("MyTime", DateTime.Today); it works fine. How can I create and use parameter that wold pass both date and time parts to date/time field? Tag: Extended SQL Stroed Procedures Tag: 64321
  - 12
    - ADO.NET Performance Tuning Hello, I have used ADO.NET to retrieve records (about 700 rows) from SQL2000 server and found that the performance (speed) is not good as ADO object. (Same Select statement applied) I would like to askwhat setting, in the DB side or client sides,I should aware so that I can improve the performance? Thanks Douglas Tag: Extended SQL Stroed Procedures Tag: 64309
  - 13
    - MSDE in install Hi How to include MSDE into install and during install create some tables so program and database server are ready to work? Thanks Konrad Tag: Extended SQL Stroed Procedures Tag: 64308
  - 14
    - GetXML doesn't show Computed Columns Anyone know if this is the way this is supposed to be working or any potential workarounds? I have a DateTime column 'DateExpires' which I am returning as a computed column via my SELECT statement. When I call GetXML() on the DataSet, it isn't returning the computed column. However, when I do a quickwatch on the DS, I see that the column is in the dataset. Also, I have a bound webform control which is getting populated with the value from this column in the dataset. strCmd = "SELECT ID, CAST((DATEPART(m, DateExpires)) as varchar(2))+ '/' + CAST((DATEPART(d, DateExpires)) as varchar(2))+ '/' + CAST((DATEPART(yy, DateExpires)) as varchar(4)) as DateExpires FROM Articles" sqlDA.SelectCommand = new SqlCommand(strCmd, sqlCN); sqlDA.Fill(objDS); objDS.GetXML() returns: <DSArticles xmlns="http://tempuri.org/Schema_Articles.xsd" /> <NewDataSet> <Articles> <ID>e75baa38-f084-472e-a14f-2517f00f3d67</ID> </Articles> </NewDataSet> XSD as follows: <?xml version="1.0" encoding="utf-8"?> <xs:schema id="Schema_Articles" targetNamespace="http://tempuri.org/Schema_Articles.xsd" elementFormDefault="qualified" xmlns="http://tempuri.org/Schema_Articles.xsd" xmlns:mstns="http://tempuri.org/Schema_Articles.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="Document"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="Articles"> <xs:complexType> <xs:sequence> <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" /> <xs:element name="DateExpires" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="DocumentKey1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Articles" /> <xs:field xpath="mstns:ID" /> </xs:unique> </xs:element> </xs:schema> Tag: Extended SQL Stroed Procedures Tag: 64303
  - 15
    - ANN: September 2, "ADO.NET with Visual Basic .NET"" chat Every application uses data. Come and ask members of the Visual Studio and SQL teams about the best approaches for working with data in your applications. Date: September 2, 2003 Time: 1:00 - 2:00 P.M. Pacific time 4:00 - 5:00 P.M. Eastern time 20:00 - 21:00 GMT 21:00 - 22:00 BST (For a list of local time zones relative to GMT, please see http://msdn.microsoft.com/chats/timezones.asp.) Location: http://msdn.microsoft.com/chats (then click the name of the chat to enter the chat room) To see a list of upcoming chats or set a reminder for this chat, please see http://msdn.microsoft.com/chats. You can use the following link to add an event reminder to your calendar for this chat. http://msdn.microsoft.com/chats/outlook_reminders/VB_Sept2.vcs To see an archive of previous chat transcripts, please see http://msdn.microsoft.com/chats/recent.asp. Thanks! Jason Cooke VB.NET Team ======== This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. (c) 2003 Microsoft Corporation. All rights reserved. Tag: Extended SQL Stroed Procedures Tag: 64301
  - 16
    - network packet size I recently switched my production db from one server to another. My app connects with this connection string ("data source=servername;initial catalog=dbname;integrated security=SSPI;packet size=8192") to the old server fine, but will not connect to the new server unless I decrease the packet size from 8192 to 4096. I ran sp_config on both machines and the network packet size is the same for each server. Any ideas or areas I could check? I guess it's not that big of a problem, but I would like to know why. Thanks Tag: Extended SQL Stroed Procedures Tag: 64291
  - 17
    - DataRowChangeEventHandler Issue I have written a DataRowChangeEventHandler to act as a "security" filter based on the current users "role". The event handler needs to be able to reject/cancel Inserts to the ADO.NET DataTable (these inserts are the results of a Select against the dataSource using the Fill method on a SqlDataAdapter). I've tried throwing an exception inside the handler, which doesn't appear to do anything. I've also tried calling RejectChanges on the row. This seems to work, but also seems to leave an invalid row in the table in a "Detached" state, which causes things like AcceptChanges to blow up later on. I suspect I'm just going about this the wrong way, but haven't seen an example anywhere of how to prevent a Row from being added to a DataTable. My code is shown below -- does anyone know what the "right" way is to do this? Thanks in advance, Jeff private void FrameworkRowAddedSecurityMonitor(object sender, IFrameworkTableSecurityEvent e) { if (e.Action == DataRowAction.Add) { if (e.SecurityObject.DataType != null) { if ((e.SecurityObject.AccessMask & ContentManager.FW_ACL_PERMISSION_READ) == 0) { // Option 1 DataRow row = (DataRow) e.SecurityObject; row.RejectChanges(); // Option 2 throw (new ContentManagerSecurityException("Access Denied",e.SecurityObject,ContentManager.FW_ACL_PERMISSION_R EAD,e.SecurityObject.AccessMask)); } } } } Tag: Extended SQL Stroed Procedures Tag: 64288
  - 18
    - Oracle CLOB parameter limit? Hey all, I'm getting the following error when calling an Oracle9i proc from a .net 1.1 app, passing a clob parameter that is larger than ~32,000 characters: ORA-01460: unimplemented or unreasonable conversion requested. Is there a parameter size restriction for oracle procs? How do I pass in a large clob to the database? I'm using the MS managed provider for oracle, and the oracle9i drivers.... TIA, Andrew Tag: Extended SQL Stroed Procedures Tag: 64287
  - 19
    - Cannot execute DTS package from ASP.Net Hello: I've got another problem executing DTS package from ASP.Net. I use this code: Dim oPkg As DTS.Package oPkg = CreateObject("DTS.Package") oPkg.LoadFromSQLServer("WIN2000", "UID", "password", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, , , , "Import_Sales_History") oPkg.Execute() oPkg.UnInitialize() oPkg = Nothing I used this code before, and it always worked. Now it doesn't. The problem is that I'm not receiving any error messages, so I cannot find out what's wrong. When I step through the code I don't see anything unusual. But in fact it doesn't do anything, no data has been imported. When I execute the package manually - everything is OK. What could be a problem? I would appreciate your help. Thank you, -- Peter Afonin Tag: Extended SQL Stroed Procedures Tag: 64285
  - 20
    - Problem updating existing typed dataset from Generate Dataset designer Hi, I'm trying to update an existing Typed dataset in a VB Web project using the "Generate Dataset" designer from a SqlDataAdapter. When I try to add new tables or updated fields, the wizard closes like it does for a new typed dataset, but the selected dataset schema does not change. What I've been doing as a workaround is to just delete the existing ds and creating a new one with the same name. Is there a fix out there or do I just have something setup wrong? I'm using: Visual Studio 2002 VB - Web forms SqlDataAdapters - SQL Server 2000 .NET Framework 1.0 Thanks in advance, Eric Tag: Extended SQL Stroed Procedures Tag: 64278
  - 21
    - Change Winform Query Question I had an experience this morning that I don't quite understand with VS 2003. I have a Winform with the underlying data coming from three different tables. This data for the Winform is obtained by use of a dataset. The form has tabs. Data in the Contracts table goes to the Contracts tab, data in the Students tables goes to the Students tab etc. For each of these tables I have a SQLDataAdapter in the component tray of the Winform. DaContracts, DaStudents, & DaArd. When I generate a Dataset for each of these 3 data adapters I point to a DataSet I call DSMain (DsMain1). That is, DSMain has schema involving all there of these tables and they are (in the schema) related together in the proper way and in the same way they are related in the underlying SQL 2000 tables. Sorry to be too wordy. Don't know how to explain the problem, however, without saying at least that much. It was necessary for me to add some fields to the main table (contracts). These fields were not selected in the original query that produced the contracts table in the DataSet Schema. I added the fields in the query of the DaContracts DataAdapter and re-generated the dataset for that adapter. I then tried to run the form and got back an error message of "Could not create a child list for fields DrContractsArd". This is the data relations name for the Contracts and Ard tables. I horsed around with it and finnaly got the form back up and running as before but for future reference, I would like to understand what happend. I think the moral of the story is that if you add fields or change things in the future with regard to one table in a dataset involving more than one table, it is not enough to re-generate the dataset for just that table, you must regenerate the dataset for all the tables. Is this right or are there other comments or items that others would like to bring to my attention? I am new to VS and may have made an incorrect assumption in tying these three tables together in one dataset. Maybe each table should have a dataset of it's own. I don't know. I did it this way in the first place for reasons I don't remember other than, it worked. Tag: Extended SQL Stroed Procedures Tag: 64263
  - 22
    - Cannot delete last row in a datagrid Hi all. I have a datagrid bound to a dataset/datatable. Obviously I created a BindingManager and a CommandBuilder and all runs well when I ADD new rows or DELETE existent rows, saving all back to the database. Here is the code associated to a button, I use for "deleting" a row: ---------------------------------------------------- Dim dr As DataRow dr = ds.Tables("checkout").Rows(bm.Position) dr.Delete() MsgBox(ds.Tables("checkout").Rows(bm.Position).RowState) If ds.Tables("checkout").Rows(bm.Position).RowState = DataRowState.Deleted Then MsgBox("row deleted") da.Update(ds, "checkout") End If ------------------------------------------------------ As you can see I found the row first and the "delete" it (the RowState is only for debugging purpose :-) Well I CAN delete all rows in the datagrid (clicking on the row and then clicking on the Delete Button), obtaining a DataRowState.Deleted value (as expected). But the problem is when I try to delete the last row in the grid: the row is deleted from the grid, but no changes are made to the RowState (obtaining a Unchanged value). So no Update is possibile on that row. I can't understand why! Have you any idea? Many thanks. -- Francesco De Carlo Tag: Extended SQL Stroed Procedures Tag: 64259
  - 23
    - Lhotka's VB.Net Business Objects Has anyone tried implementing Rockford Lhotka's CSLA framework from his book Expert One on One Visual Basic .Net Business Objects? The reason I pose this question here is 2-fold. 1. He basically does away with most of ADO.net, other than the DataReader to read a row in order to stuff the values into Properties of objects, which are then bound to UI controls. To update the database, the values from the Properties are used to generate a SQL update statement. It certainly seems an odd way of doing things - albeit in an OOP way. 2. Having spent 3 weeks trying to work through the book and make it work, I can't seem to be getting anywhere. His downloaded source code refuses to work - even after some of the more obvious problems are fixed (like references to a Strongname Key file stored on his own h:\ drive in some of the Assembly Info files). The sample Project Tracker keeps quiting with a System error. I am very intrigued with his framework, and I think Mr Lhotka is one of the best technical writers around. I find myself stuck in the mud and would like to know if anyone out there has been able to make this thing work. Thanks Tag: Extended SQL Stroed Procedures Tag: 64256
  - 24
    - Class Reference Sorry for crossposting! Is there a complete reference of .NET Framework class libraries? And i mean COMPLETE reference with full explanation of what each class does and perhaps what it's good for. Reason for this is that recently i spent 2.5 days coding a class only to find out that Framework already supplied me with a similar class (the same functionality), only i never knew about it :-( So i would like to know when i must code my own functionality solutions and when there's something in .NET that i can use. Btw don't point me to MSDN cause i have latest library and i'm aware of the library online, but they only give a very little information about classes in Framework, and almost no examples. Thanx in advance Tag: Extended SQL Stroed Procedures Tag: 64243
  - 25
    - Urgent Help Needed !! FTP Files from Webserver to Client PC Hello, I need to download files from the web server to the PCs without the "Save As" Dialog Box using ASP.NET . Pls advise if there are any components available for any help is appreciated. Thank You EJ Tag: Extended SQL Stroed Procedures Tag: 64237

Hello there,

I'm looking for some doc or samples for creating Extended stored procedures
within .NET (C#).

Many thanks.

Laurent.Lequenne@kickthatword.digipoint.be

Top

Re: Extended SQL Stroed Procedures by google

google
Tue Sep 02 07:47:01 CDT 2003

I'm not sure if this is possible. See...

http://support.microsoft.com/default.aspx?scid=kb;en-us;322884

A.

Top