asp.net.data_access-sql_server_sql_server_express_and_sqldatasource

CodeVerge.Net ^Beta
Item Entry Register Login

Novell Forums

> Asp.Net Forum > data_access.sql_server_sql_server_express_and_sqldatasource_control

Type

Replies

Views

Date

Command Line To Generate Stored Procedure,Functions and Business Object

Hello,

I am looking for a Command line tool which will generate Sql Stored Proecure,Functions and Business Object. There are many tools which generate throug

11/28/2009 7:32:27 PM

MS SQL Sorting function

I've build a web page with a lot of items in it.
The user likes to sort it, so i made a new column with the sorting.
So the result can be:

11/28/2009 1:58:08 PM

to redirect sample db setup to non-default instance

Sample database setups
(like SQL2008.AdventureWorks_All_Databases.x86.msi)
are very handy.

But they install databases into unnamed instance.

How to redi

11/28/2009 12:27:55 PM

Unable to find '3 seconds' between "_SqlDataSource_Selecting" and "_SqlDataSource_Selected"

I am trying to track down a 3 second webpage load time for my a webpage (using trace.write()). I have narrowed it down to being between the ending ("end sub")

11/28/2009 10:55:26 AM

Fetch More than 60000 records

hi all,

I need to fetch more than 60000 records from a table and bind in a gridview,

It take too long to bind the data in a gridview with pageindex 100,

sometime it shows as tim

11/28/2009 9:13:11 AM

Application Problems

Hi, I am a begining programmer and need help completing a online application. My question is this; what is the best way to get the primary key id from one data table and insert that data in

11/28/2009 5:51:31 AM

how to make a sql dynamic select query?

HI there, im using vb.net with vwd 05? to build a web application and i need some help cause im starting to make some reports and i dont know whats the best way to do them.

I have a table l

11/28/2009 5:51:30 AM

where can I find SQL management studio

Hello, everybody. I am new to this forum and to web development. I installed VS 2008 express (offline install) from this link " http://www.microsoft.com/express/download/offline.aspx &quo

11/27/2009 11:00:26 PM

Passing dropdownlist parameter to populate additional textfields

Hello folk, Newbe here.

I have been really frustrated today trying to take a dropdownfield and pass it to a SQL select statement to return several field including an NAME, ADDR

11/27/2009 11:00:22 PM

How do I transfer data from a table in my local database to a table in Serv er database?

Any ideas?

Thanks in advance

11/27/2009 11:00:13 PM

What is the difference between a Table and a View in terms of performance?

I am wondering if I query a table and if I query a View with the exact same data as the table.

What are the salient points of difference?

In terms of perfomance, of sto

11/27/2009 11:00:12 PM

help with complex SQL query

Hi people been developing with vb.net and asp.net for bout 6months now but my SQL skills still need some work.

Here are the forms I wan from the table (accessed through a web a

11/27/2009 11:00:09 PM

database schema

can any body tell me how to create the database table to store the employee attendance report... i mean i want to store the employee attendance report(365 days report) how to do that.... can any

11/27/2009 11:00:06 PM

Paging In Sql Server

I have a table output which has the result from 3 tables.I used joins to fetch the recods from 3 tables.

Here what my scenario is i have to do pa

11/27/2009 11:00:03 PM

How to avoid duplicate rows in a simple 3 table query?

I have 3 tables:

Users

UserID

MessageSubscriptions

MessageSubscriptionID

SubscriberU

11/27/2009 3:40:44 PM

What is the easiest way to read from an .mdf file on the web? My host is Sq lServer 2005

Is it possible that you provide the connectionstring for that? I can then update it and set the actual values for server name and stuff..

I need to read the mdf file using .NET

11/27/2009 3:40:43 PM

Import CSV with RegEx into MS SQL Server

1. i need to import a csv file with regex to ms sql server table.
Somehting like this.

Read record by record - if one column does not mach a regex do not import this rec

11/27/2009 3:40:42 PM

How to link Excel table to SQL 2005/8 Server Express ?

I have a SQL Server express for my ASP.Net page but part of the data is sitting on an Excel file with data always changing. So I cannot just import data from Excel to SQL server md

11/27/2009 3:14:49 PM

SQL Server : Image DataType

Hi Experts,

I have image data type in my one of table.

I have image, which is physically stored on D:\logo.png.

So how to stored that physical image t

11/27/2009 1:56:53 PM

Convert string Date to Date

I am using SQL server 2005 database.

I have a varchar feild which stores date in the formt "DD-MM-YYYY"

now what i want to do is, convert this date from databas

11/27/2009 1:56:52 PM

Using for xml path in sql Function

Hello,

Currently my sql function is as follows:

CREATE FUNCTION [dbo].[FnCIDbyEID]
(
	@eid int
)
RETURNS varchar(max)
AS
BEGIN
DECLARE @CID

11/27/2009 1:56:51 PM

Why is it NULL in stored procedure?

ALTER PROCEDURE [dbo].[spSearch]
(
	-- Add the parameters for the stored procedure here
    @NAME			nvarchar(255) = NULL,
    @Country			nvarchar(10

11/27/2009 1:56:51 PM

Get Excel data into SQL server express

I have a SQL Server express for my ASP.Net page but part of the data is sitting on an Excel file with data always changing. So I cannot just import data from Excel to SQL server md

11/27/2009 11:49:04 AM

Accessing an SSIS Package from aspx page

Hi all,

I have an SSIS package that attaches a file and sends an email to a user..

This package is scheduled to run once a month.

This is not interactive ie:doesn't us

11/27/2009 10:54:58 AM

how to refresh sql datasource automatically

hello..

i m binding outlook with sql data source....i want it will be automatically rebind with sql data source after some time offline.....

how can i do this

11/27/2009 9:22:36 AM

Getting Info from Sql database

Please I am currently designing an Exam portal for a school where students will view their result when they key in some generated numbers and their names which will then pull the result fro

11/27/2009 9:22:35 AM

backup SQL Server 2005 database without data

I have one stored procedure to backup the database. It will backup metadata as well as data. Is there any option to back up the database with out data. ie, back up only the schema (Empty tables).

11/27/2009 9:22:34 AM

Data access from three tables

Dear

i want

how i can do this

11/27/2009 9:22:33 AM

Getting the sever time in #.net

hi,

Is there is any way to find the current date of the sql server in my C# .Net application.

I not use my local mechine as a server in my&

11/27/2009 6:27:10 AM

Reading from database

I am getting IndexOutOfRangeException.

My table has one record with formID=0. When I run this query on SQL Server I get correct result as 0.

but when I run this code I get error a

11/27/2009 4:56:56 AM

sql server 2005 express edition

I am unable to download the sql server 2005 express edition.,

i need to understand the steps to start working on database engine.

Thanks

Srinivas

11/27/2009 4:56:55 AM

can we use more than one connection on same code file.

hi all,

I am having a little confusion about connection.

supopse on my code file I am having three different

11/27/2009 4:56:54 AM

How to Import data from XLS to SQL mdf file in VS2008 ?

Is there anywhere in VS2008 to import data from XLS to mdf in my App_data folder ?

Pls advise step by step. Thanks.

Thanks in

11/27/2009 3:03:46 AM

Easy one: SQL View everything fine except final run - help..

I have been using mdb Access as datasource for my ASP.Net page but I now want to jump to SQL Server express. I have created .mdf file and I have added 2 tables and then one View. I can view table

11/27/2009 2:36:22 AM

SqlDataAdapter update with transactioin fail for second call

Hi,

I need to update table regularly. So i create a dataset with sqldataadapter and update it with transaction. It works for the frist time call and rais

11/27/2009 12:14:08 AM

Need help to convert an SQL query into a Linq to SQL query

My ASP.NET 3.5 website makes use of an SQL Server database and I want to find all records in my Entrants table that have duplicated values for the FirstName, LastName and Email columns.

11/26/2009 8:58:31 PM

Do Not Need Multiple Returns

Sql Server 2005 , Vb.net 2003, Asp.net 1.1

Hi,

Having a little problem with too many returns that

I don't need.

I am making an app that is ju

11/26/2009 6:03:45 PM

Drop down list - stored procedure for searching Table

Have posted few posts to get this done using Stored procedure. Unfortunately help up, could not get it done.

Could be simple. what i have been trying is 'Dep

11/26/2009 5:31:22 PM

how many records could be stored in one table?

hello

one table of a database holds more than 100,000 records , is it Ok , or there is a better practice ?

the table grows at the rate of 20,000 records/month

what is the

11/26/2009 4:28:37 PM

how to delete the duplicate records from a table?

how to delete the duplicate records from a table?
like Item is a table and its columns are Item(IID,Iname,

11/26/2009 4:28:36 PM

count days

hi all

i want to calculate no. of days from the table

for e.g. auditby qcDone &

11/26/2009 4:28:36 PM

sql maximum numeric value of a varchar field without leading spaces

How do I get the max value of the issue field (varchar) in my table

Issue is an alphanumeric field (varchar) which contains numbers in the range 0-999. There are no leading spac

11/26/2009 12:49:24 PM

Database Backup Causing Timeout

Hi. I have a problem with "Timeout Expired" error occuring on my web application. The timestamp of the error is in line with an sql server job that runs every night and

11/26/2009 12:49:23 PM

Auto generated primary key

hey hi all

m using sql server n asp.net

in my web forms i have used validation controls.

i used required field validation control when i skips any required field and clicks the

11/26/2009 8:53:52 AM

Can't connect to DB from my machine, others are fine.

Hi guys,

interesting problem, not sure what could be causing this. When I try to run a project from VS08 or from my localhost using IIS 7.0 I get the usual

11/26/2009 5:05:36 AM

SQL server primary key with varchar and bigint combined columns

I am not able to make a primary key with username( varchar) and sessionid(bigint) together as a combined primary key. I tried clicking on the grey left area pressing shift and rightclick, set pri

11/26/2009 5:05:34 AM

How do I retrieve list of users withing a distance from a zipcode?

I already have a list of U.S. zipcodes (around 43000 zipcodes) which give me Zip, City, State, Lat., Long. and TimeZone information.

My problem is that I end up doing distance

11/26/2009 4:28:00 AM

sending mail using trigger help??

i have learnt how to write triggers but i want to know how to send mail whenever a new user inserts data into db using triggers??how to do it??

11/26/2009 4:27:59 AM

Drop Down List - Searching with stored procedure

I have a search form with various Text boxes, drop down list controls and using a stored procedure to carry out search. All working fine.

Now it is required to add another Drop

11/26/2009 12:43:58 AM

Unique identifiers in sql

I need to have a unique id as a column of my db table. I want to be able to use it for insert/delete/update from my asp.net code behind in vb.net. I am thinking of using bigint as an identifier w

11/25/2009 8:49:28 PM

22175 Items, 444 Pages 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 41 81 121 161 201 241 281 321 361 401 441 |< << Go >> >|

Invite

Members

SiteMap

Privacy | Contact Us
All Times Are GMT