CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting
ASP.NET MVC Ready – 3 Months Free and Free Setup
Can Reply:  No Members Can Edit: No Online: Yes
Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.microsoft_application_blocks Tags:
Item Type: NewsGroup Date Entered: 4/26/2004 4:42:27 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
NR
XPoints: N/A Replies: 1 Views: 16 Favorited: 0 Favorite
2 Items, 1 Pages 1 |< << Go >> >|
snimos
Asp.Net User
MS Access/SQL Server 2000 not updating ..Need Help!!4/26/2004 4:42:27 AM

0

I have tried frontPage forms for data update and also used Web Matrix webforms but none of them is able to update MS Access/SQL Server 2000 . I don't know what I am doing wrong but it appears like the MS Access/SQL Server 2000 is not accepting data. In one instance, it said the database is in use by another program or its exclusive. I have tried some book examples but none is working...SQL Server 2000 said I am not a trusted user or something.

Can someone help me with asp code that can allow me to insert, delete and retrieve data from a database without using these web editors?? This will really help me a lot. Please, I would like easy to understand examples....Thank you.
eliko
Asp.Net User
Re: MS Access/SQL Server 2000 not updating ..Need Help!!5/10/2004 12:33:48 PM

0

Here is the code sample

if you want , I can mail you all project.
____________________________

private void Page_Load(object sender, System.EventArgs e)
{
InsertIntoTable();
}

private void InsertIntoTable()
{
string sql="INSERT INTO someTable (someField) VALUES('Elshan')";
ExecSql(sql);
}

private void ExecSql(string sql)
{
SqlConnection cn=new SqlConnection(GetCN());
SqlCommand cmd=new SqlCommand(sql, cn);
cn.Open();

cmd.ExecuteNonQuery();

cn.Close();
}

private string GetCN()
{
return "Persist Security Info=False;Trusted_Connection=yes;Initial Catalog=Elshan;Data Source=WINSERV\\VSdotNET";
}
2 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
MCTS: Microsoft SQL Server 2005 Implementation and Maintenance: Microsoft SQL Server 2005 Implementation and Maintenance Study Guide (Exam 70-431) Authors: Joseph L. Jorden, Dandy Weyn, Pages: 634, Published: 2006
Microsoft SQL Server 2000 DBA Survival Guide Authors: Mark Spenik, Orryn Sledge, Pages: 1032, Published: 2002
MCSA/MCSE/MCDBA: SQL Server 2000 Administration. Exam 70-228 Authors: Joseph L. Jorden, Rick Sawtell, Lance Mortensen, Pages: 608, Published: 2003
Designing SQL Server 2000 Databases for .net Enterprise Servers: For Windows 2000 DNA Authors: Syngress, Inc Syngress Media, Syngress Media, Inc. Staff, Robert Patton, Jennifer Ogle, Travis Laird, Pages: 608, Published: 2001
A Guide to SQL Server 2000 Transactional and Snapshot Replication: Transactional and Snapshot Replication Authors: Hilary Cotter, Pages: 1016, Published: 2004
SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills Authors: Joseph L. Jorden, Pages: 333, Published: 2006
From Access to SQL Server: Moving from Microsoft Acess to Microsoft SQL Server Authors: Russell Sinclair, Pages: 340, Published: 2000
Accelerated SQL Server 2008 Authors: Rob Walters, Robert E. Walters, Michael Coles, Robin Dewson, Robert Rae, Fabio Claudio Ferracchiati, Donald Farmer, Jan D. Narkiewicz, Pages: 816, Published: 2008
SQL Server 7: Backup & Recovery Authors: Anil Desai, Pages: 480, Published: 2000

Web:
MS Access/SQL Server 2000 not updating ..Need Help!! - ASP.NET Forums MS Access/SQL Server 2000 not updating ..Need Help!! Last post 05-10-2004 8:40 AM by eliko. 1 replies. Sort Posts: ...
Update Transaction - not updating database - SQL Server - So I need help. Tag: Update Transaction - not updating database ... I am using Microsoft SQL Server Integration Services Designer Version 9.00.2047.00. ...
Microsoft SQL Server: Programming - need help with updating based ... need help with updating based on conditions. thread183-1497101 ... SQL Server has no such function till 2005 (for 2008 I am not sure smile ). ...
MS SQL [Sitemap] - DaniWeb IT Discussion Community I need an exampls program in java to store image datatype in ms-sql · Ms Sql 2000 ... Net VB Page to update a users profile not updating. Ms Sql Server 2000 ...
sql vb odbc connection Resources | TechRepublic how to establish connection between Vb 6.0 and Sql Server 2000 in LinuxOS .... I have the catalog but i want I direct connection through MSaccess: Tags: ...
Rubik's Cube- I'm new and need MS Access/SQL Database help please Need to upgrade an e-commerce site and am a little lost rubiks cube- im new and need ms access/sql database help please.
SQL Server 2000 Solution Center PRB: SQL Server 2000 Views Not Replicated to Microsoft Access Through Merge ... Need More Help? Contact a Support Professional by Email, Online, or Phone. ...
Database [Archive] - Page 33 - DevX.com Forums [Archive] Page 33 SQL Server, Oracle, DB2, Informix, FoxPro, MySQL, or just plain SQL ... QueryResults object and MS SQL 2000 float fields - please help! ...
Updating recordsets in MS SQL 2005 not working - Microsoft SQL Server Updating recordsets in MS SQL 2005 not working. Get answers to your questions in our Microsoft SQL Server forum.
EUCS SQL Server Hosting Service Buy a Client Access Licence for SQL Server 2000. ... database in this way, it must have a primary key defined, otherwise updating via Access may not work. ...












security problem

microsoft application block for data access in vs 2005

ms log parser with logging block output?

slidingtime is not reconized by asp.net

exception when use daab 2.0 to config web.config

invalid attribute

microsoft application block for data access in vs 2005

timeout error using database blocks

is data caching secure?

enterprise library for .net framework 2.0:

getting errors out of data access block

asynchronous support in .net 2.0

how to write a web application to handle both mysql and mssql databases

configuration management application block in the use?

run time exception

data caching versus application state conundrum

how to handle decimal precision & scale with daab addoutparameter?

up and running?

exception quickstart & v1.1 framework?

errors creating custom log in eventlog

comparison

what is logging application block and exception handling application block?

insert example

genericdatabase not passing parameter to stored proc

where is the community???

user interface process application block with .net 2.0

extending formatteddatabasetracelistener issues

enterprise library exeception handling and extended properties....

enterprise library configuration block error

loggingconfiguration/listener source parameter for formattedeventlogtracelistener required to createeventsource
   
  Privacy | Contact Us
All Times Are GMT