Browse by Tags

Home ›

Creating a C# Web Service

I have an interesting problem at work. I need the ability to get an amount of data, maybe 15MB or less, on a recurring basis for external datasources. Such as from a system in another state. These data files, CSV, XML, or whatever are too large to be transfered via email, plus I would have to manually...

Posted to XML Web Services (Forum) by BrianFan on 04-09-2009, 12:00 AM
Filed under: object, Object Oriented, Objects, remotely, Remove users, SQL, SQL Server 2005, SQLDataReader, System.IO, System.IO OutputStream, system.io.file, system.net, text, textstream, Web Application, <C#>, .net C# jobs, appSettings, Asp.Net bulk Uploading, big file size, C# 2.0, c# 2008 LINQ, c# 3.0, c# 3.5, c# memory .net, Class implementation, collections, create c# application, csv, Datasource, file, file system, file.io, filestream, Link SQL, memory usage, web services, Web Services ASP.net 2.0, WebParts, xml serialization deserialization, xml Word parse CSV SQL Server, xls table multiple, XML and asp.net, XML file, applicationSettings
Conversion from oledb to sql

I have this code. Can someone help me convert this to work with a table called tblShipTo from the POSQL.mdf database Protected Sub ShipTO_SelectedIndexChanged( ByVal sender As Object , ByVal e As System.EventArgs) Handles ShipTO.SelectedIndexChanged ' Dim ConnString As String = "Provider=Microsoft...

Posted to Web Forms (Forum) by mhinkle2 on 02-21-2009, 12:00 AM
Filed under: SqlDataReader
SQLDataReader

I have the following code, but it is not working. I have tried for several days to get this to work, reading article after article but almost all articles only give partial answers not the whole answer and I cannnot get this work. Can someone tell me what is wrong. Imports System.Data Imports System...

Posted to Web Forms (Forum) by mhinkle2 on 02-21-2009, 12:00 AM
Filed under: SqlDataReader
getting SqlDataReader to work in VB

How do I get this to display the way I typed it (and see it in the "edit an existing message" box)? Greetings all. I am setting up a page that refers back to a table in SQL that stores the permissions for the various pages. I know ASP.NET has its own setup system, but I want something that...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by chase5465 on 02-18-2009, 12:00 AM
Filed under: SqlDataReader, vb, select query
SqlDataReader Weird Locking (ASP.NET Issue?)

Hello. I have a problem using SqlDataReader . It does lock every and each other page when running . I have one web-page with a long-running SqlDataReader. When I try to load another page at the same time which queries data from the database - that other page waits until SqlDataReader on the first page...

Posted to Data Access and ObjectDataSource Control (Forum) by net_prog on 12-29-2008, 12:00 AM
Filed under: sqldatareader
Extruct e string from one field end load it ot another in the same table

I am trying to use the CharIndex command to delimite the first and last posittions of a string in a text field in order to insert a copy of it in to another field ("image") in the same row of the table. "SELECT ID,cod, texto, (CHARINDEX('ftnews', texto)+7) AS P1, (CHARINDEX('jpg'...

Posted to Data Access and ObjectDataSource Control (Forum) by Dov on 12-23-2008, 12:00 AM
Filed under: SqlDataReader, ASP 2.0 datareader, "asp.net 2.0" "visual studio", SQL Server 2005
Strange DataReader problem - not retrieving data

Morning all, I am having an issue with a SQLDataReader in a legacy app I am having to maintain, written in VB.NET 1.1. For the past couple of days we have been having some datareaders in the application randomly stop returning data. I have stepped through the code and called the stored procedures manually...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by DWesthead on 11-21-2008, 12:00 AM
Filed under: sqldatareader, VB.Net
WHERE clause & AND Operator

I have two conditions in which both need to be met in order to be displayed on my datagrid, however, my SQL query is not returning my desired results. I have a bit column named Sailed in my tblTransit table and a StatusID in my tblWaybill table. They are joined together by a transitid. What I am trying...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bcoffey on 10-06-2008, 12:00 AM
Filed under: SQL TSQL duplicate, sql Update, sql wildcard parameter, SQL XML Stored Procedure, sql:executescalar, SQL+Hosting, sql2000, SqlBulkCopy, SqlBulkCopy SqlTransaction, SqlCacheDepenency, SqlCeDatabase, sqlclr, SqlCommand, SqlCommand Error Exception Method not found, sqlcommand parameters, sqlconnection, SqlDataReader, sqldatasourc, sqldataSource, SQLDatasource GUID, SqlDataSource Inheritance, SqlDataSource Parameter, sqldatasource parameter multiple, sqldataSource parameter Type session, sqldatasource query insert, SqlDataSource query select, SqlDataSource Repeater, SQLDataSource TimeStamp sql_variant is incompatible with timestamp, SQLDataSource Update .NET 2.0 negative return, SqlDataSource WHERE-IN, sqldatasource wizard views, sqldatasource.filterexpression, SqlDataSource.SelectCommand, sqLdatasourcecommandeventargs, SqlDataSourcource, sqldatsource selecting, sqlexception database offline, SqlExceptions, sqlhelper, sqLl, SQLL Excel ADO JET SSIS, SQLL SERVER RAM, SQLL setup, SqlNetFramework, sqlParameter class, SQLServer, sqlserver 2000, sqlserver 2005, SQLServer 2005SP2, sqLserver2005, sqlserverver, Sqlserverver 2000, sqlserverver 2000 transaction DTC ws-at atomic transaction Port 135 port135 connectivity sqltransaction system.transaction LWT 134 135 RPC API .NET2, statement, store procedure, Store procedure variable FROM clause, stored procedure case sorting direction, stored procedure for archiving the records in another table, SQL Views, SqlCommand CommandBuilder, sqldataadapter, sqldatasource datalist in datalist, SqlDataSource GridView Count, SQLDataSource parameter Type Table, sqlddatasource, SQLServere2005, SqlStoreDataSource, stored procedure, Sql Where Clause, sqLdataparametercollection, sqldatasource filter, SQLEXPRESS, SqlExpress 2005 Advanced Modifiy Database, sqlscript, standalone application, stored procedure 3
Re: Retreive single value from database in page load

[quote user="MrSutton"] hi, I have a database with one table. --- CustomerID, CustomerName, CustomerEmail I want to retreive the email string by CustomerID in my page load. I"m getting the CustomerID from the query string. I Have created a stored procedure with a query that pulls the CustomerEmail...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by pogo2346 on 10-05-2008, 12:00 AM
Filed under: Page_Load, SqlDataReader
Re: Retreive single value from database in page load

[quote user="MrSutton"] hi, I have a database with one table. --- CustomerID, CustomerName, CustomerEmail I want to retreive the email string by CustomerID in my page load. I"m getting the CustomerID from the query string. I Have created a stored procedure with a query that pulls the CustomerEmail...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by pogo2346 on 10-05-2008, 12:00 AM
Filed under: Page_Load, SqlDataReader

Page 1 of 3 (28 items) 1 2 3 Next >

Browse by Tags

Related Posts