Browse by Tags

Home ›

All Tags » database » MSSQL (RSS)

connect, insert, select and update mssql databse with C#

hi i'm very very beginner to asp.net... i usually used to program in PHP/Perl but now i want to learn this tool also... can anybody please write me the most simplest way of connecting to DB, inserting few form data-fields into DB, then later fetching that data from DB and perhaps update the same...

Posted to Data Access and ObjectDataSource Control (Forum) by waqaslam on 04-08-2009, 12:00 AM
Filed under: mssql, connecting database, Database, Insert Data Values into SQL Database
Re: How to shrink the database log file

Hello, You can manually shrink a database log file using the SQL Statement below. Replace "TransactionLogName" with the database's log name. Replace "DatabaseName" with the actual database's name. DBCC SHRINKFILE(TransactionLogName, 1) BACKUP LOG DatabaseName WITH TRUNCATE_ONLY...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ServerIntellect_BH on 01-12-2009, 12:00 AM
Filed under: MSSQL, resize, shrink, small, transaction log, Database, decrease
Re: error in processing report

Hello Roba, Whenever you use Integrated Security as false the user ID and password which are mentione in the connection will be passed for database authentication, where as the current Windows account credentials will be used for authentication when you use value of Integrated Security as true. Web.config...

Posted to SQL Server Reporting Services (Forum) by GabrielS_EUK on 11-23-2008, 12:00 AM
Filed under: MSSQL, SQL, string, asp, ASP.net, connection, database, web.config
using mysql ExecutenonQuery() throw error

Hi Dude, I am facing this error when i try to insert a record using insert command in mysql I am using MySQL as db and ASP.NET 2.0 Source private const string ConnStr = "Driver={MySQL ODBC 3.51 Driver};" + "Server=localhost;Database=gallerysri;uid=root;pwd=123;option=3"; protected...

Posted to MySQL (Forum) by Ramkumar.Venkatachalam on 10-12-2008, 12:00 AM
Filed under: mssql, .NET, database
Re: sql connection in server

Web.config is a main configuration file for a ASP.Net application. It is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application. You can globally define your database connection string in this file. Following is a sample connection string...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by GabrielS_EUK on 10-05-2008, 12:00 AM
Filed under: SQL, Connection String, Database, ASP.NET, web.config, MSSQL, SQLEXPRESS
Re: mysql 'latin5_turkish_ci' error

In asp code, i solutate Turkish character error same this code. But i can't do this in asp .net. How can i do it. { Set bag = Server.CreateObject("ADODB.Connection") bag.Open "Driver={MySql ODBC 3.51 Driver}; Server=localhost; uid=root; pwd=123456; database=deneme; option=3; port=3306;"...

Posted to MySQL (Forum) by senol on 03-12-2008, 12:00 AM
Filed under: mssql, MySQL 4.1, mysql 5.0, asp.net, ASP.NET 2.0, ASP.NET Membership, C#, connect to, connect to MySQL on remote PC, Connection, Connection with MySQL Database from ASP.NET 2.0, database, db, error, file, mysql.dll, MySQL.NET connector on Medium Trust Level, MySqlClient, aspnet
User Instances on qsh.eu

Hi. I am trying to connect to a database but keep encountering the same error. I have a free hosting account with quantasoft (qsh.eu) who fully support SQL express user instances. I have also used the connection string generator on their site. This is the result of the error. Cannot create file 'H...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by briggins5 on 11-10-2007, 12:00 AM
Filed under: sql 2005, Sql 2005 .NET, sqldataSource, SqlDataSource Repeater, SQLServer, "MSSQL error", Database, dataset, Microsoft SQL Server 2005, ASP .NET 2, sql 2000 "sql server express 2005", MSSQL, user
coneverting oledb code to connect to remote sqlserver

i have some oledb code made in c#(vs 2005) it is for local msaccess file. i want to conevert the code for sql server where connection string placed in web.config file seperately. please help me. here is code private void buildGrid() { string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by sansat6699 on 09-28-2007, 12:00 AM
Filed under: MSSQL, sql 2000, .NET 2.0, asp.net c# profiles sql server, Database, Datagrid, ASP .NET 2, SQL Server 2000
Login failed for user '(null)'.

I have an issue dealing with connectivity between the client and Sql Server Services or Sql Authentication. I keep receiving this type of error message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I am sure my connection string is correct within...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by xyz789 on 08-01-2007, 12:00 AM
Filed under: MSSQL, SQL 2000 Server, SQL 2000 Server Connection, ADO.NET, ASP, complex, connection pool, Connection String, Connnection String, Database, .NET SQL Server 2000, ASP .NET 2
dynamically choosing connection --please help

i have to store some data on a remote sever(MS SQL SERVER2000). The scenario is like 1. The web application runs on a local machine. User (who inputs) uses through LAN. 2. The Input should be stored in the remote server. if the remote connection is ok. otherwise it should be saved in local server's...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by russell786 on 07-26-2007, 12:00 AM
Filed under: MSSQL, SQL 2000 Server Connection, SqlCommand, connection leaks, connection pool, Connection String, Database, database options, .NET SQL Server 2005, sql server 2005 tcp/ip remote connections

Page 1 of 2 (13 items) 1 2 Next >

Browse by Tags

Related Posts