.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

what is the better design for location of system database data / log files and user data/log file,

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.


View Complete Post


More Related Resource Links

Linq - add data to database then email user the details

  

Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 

 

Thanks in advance for your help,

Laura

 

 


Need Oracle Data Provider .CS File for Oracle 10g Database connection !

  

Hi.,

I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query

(eg)

Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");

Gridview1.DataBind();

Plz Post the link if there is any open source !    


System.Data.SqlClient.SqlException: Login failed for user . Reason: The account is disable

  

Hi All,

Thank you for advance.

I created a widows service for mail schedule with c#.net and sql server 2005 and it is working fine for past one year.

now sometimes i am getting the "System.Data.SqlClient.SqlException: Login failed for user '<UserName>'. Reason: The account is disabled." error.

then i restarted the windows service manually and working.

what is the problem in my sql server connection and how to fix that issue?


Insert Excel Data via File Upload into sql server database???

  
Hi all, I have requirement that User can Upload the Excel Sheet Data to sql server Database at once. How i do that Any Article or hint is apperciated.   Regards 

Could not load file or assembly "System.Data.DLL" or one of its dependencies

  
Could not load file or assembly "System.Data.DLL" or one of its dependencies

System.Data.SqlClient.SqlException was unhandled by user code

  
System.Data.SqlClient.SqlException was unhandled by user code  Message=Incorrect syntax near '01'.Unclosed quotation mark after the character string ' from month_day where month_name=datename(month,dateadd(month,01,0)-1)'.  Source=.Net SqlClient Data Provider  ErrorCode=-2146232060   LineNumber=1  Number=102  Procedure=""  Server=W2003-VM1-MK  State=1  StackTrace:       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()       at System.Data.SqlClient.SqlDataReader.get_MetaData()       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)   &nbs

File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF

  
I have Encountered with this problem when i am doing project for mobile application. I have installed sqlce.dev.ENU.ppc.wce5.armv4i.CAB,sqlce.repl.wce5.armv4i.CAB,sqlce.wce5.armv4i.CAB,NETCFv2.wm.armv4i.cab My Deployment Cab File NewBatchScanCab_Data.CAB with all this following cab's. This Cab is running in another Computer's also but it is prompting error message as below: File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF1C8D2AD3',or one of its dependencies,was not found. I Wanna now why it is prompting this error message.

buffer data from a sql server database file

  
I'm in need of a sample code that will let me buffer data from a database so that I can go next> and <prev in a database file. Does someone have an idea on now to do this. Joe      Toppers BBS http://toppersbbs.dtdns.net C# Windows and Console applications. PHP, Mysql. HTML

File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF

  
I have Encountered with this problem when i am doing project for mobile application. I have installed sqlce.dev.ENU.ppc.wce5.armv4i.CAB,sqlce.repl.wce5.armv4i.CAB,sqlce.wce5.armv4i.CAB,NETCFv2.wm.armv4i.cab My Deployment Cab File NewBatchScanCab_Data.CAB with all this following cab's. This Cab is running in another Computer's also but it is prompting error message as below: File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF1C8D2AD3',or one of its dependencies,was not found. I Wanna now why it is prompting this error message.

User Data from database...can't fill ddl on PageLoad because of DataBound

  
I have a database where a user inputs data to multiple databound drop down listboxes.  That's saved to my aspnet database.  Then when the page loads again, I want to select the ddls items that the user selected as stored in the database to these databound ddls.  But it doesn't work, because on pageload, they haven't been databound yet.What's the best way to do this?  Do I need to run a SELECT statement for each and every ddl on it's databound event???

VS2010 Deploying Database Project - Error: Cannot create file [...]MSSQL10.MSSQLSERVER\MSSQL\DATA\m

  
I had SQL Express from a previous installation of VS2010. I uninstalled All SQL and VS2010 and re-installed VS2010 (without Express) and then re-installed SQL Server 2008 Developer Edition. Now when I try to deploy a database project I am receiving the following error:     Creating EDDY.Cheetah.Database.Server... ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 5170, Level 16, State 1, Line 1 Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf' because it already exists. Change the file path or the file name, and retry the operation. ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 1802, Level 16, State 4, Line 1 CREATE

Multiple Data Files Per Database Not Allocating

  
We recently read that I/O performance can be increased by creating multiple data files for a database: "As a general guideline, create one data file for each CPU" So went ahead and did this, and restarted the SQL engine, but still it is writing all data to the first file "Production_data_1". We would assume after we restarted it would reallocate the data across all four data files. Currently, the other three data files have 1GB of space allocated, but the engine is not writing data to the other three files. How can we distribute the existing data across all four data files? See a screenshot we took at: http://www.ftoperations.net/screenshot.png

Unhandled exception in XAML editor from control that accesses database. - "System.Data.SqlServerCe.S

  

Hello,

Im having a bit of difficulty with some WPF/C#/SQL Server CE code.

I have a WPF User Control with the following line of code in the constructor:

MyDatabase database = new
 MyDatabase("Data Source=|DataDirectory|\\MyDatabase.sdf"
 );

where MyDatabase is a class generated using SQLMetal.exe from MyDatabase.sdf.

 

When I added this control to other controls, the application runs fine and I'm able to access my database. When I try to edit these parent controls,  the XAML editor throws the following error:

 

>System.Data.SqlServerCe.SqlCeException
>The database file cannot be found. Check the path to the database. [ Data Source = D:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\MyDatabase.sdf ]

 

Why does the XAML editor redirect my DataDirectory to "D:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\" and why does the XAML editor execute my database access code?

 

How can I fix this so I can use this control in a XAML editor?

Thanks,

Greg S.

 


Unhandled exception in XAML editor from control that accesses database. - "System.Data.SqlServerCe.S

  

Hello,

Im having a bit of difficulty with some WPF/C#/SQL Server CE code.

I have a WPF User Control with the following line of code in the constructor:

MyDatabase database = new
 MyDatabase("Data Source=|DataDirectory|\\MyDatabase.sdf"
 );

where MyDatabase is a class generated using SQLMetal.exe from MyDatabase.sdf.

 

When I added this control to other controls, the application runs fine and I'm able to access my database. When I try to edit these parent controls,  the XAML editor throws the following error:

 

>System.Data.SqlServerCe.SqlCeException
>The database file cannot be found. Check the path to the database. [ Data Source = D:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\MyDatabase.sdf ]

 

Why does the XAML editor redirect my DataDirectory to "D:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\" and why does the XAML editor execute my database access code?

 

How can I fix this so I can use this control in a XAML editor?

Thanks,

Greg S.

 


INSERT statement and Getting Data From User Into My Database

  

Hello,

I have spent 2 days reading and trying to figure this out and everything i have read and every book I have brought only tells how to read info from a database and how to edit info that is in a database and they all display the data in the database!

I have a page created (getinfo.aspx)

On that page I have a correctly configured SQLDatasource (SQLSource1) (it is set to allow insert, edit and delete).

I have 1 fileupload control
   uploadUserPhoto

I have 2 text boxes
   txtName
   txtPhone
   txtCity

I have 2 drop down list boxes
   dropState
   dropCountry

The 2 drop down list boxes are "binded" to to seperate tables (via 2 other correctly configured SQLDatasource controls 0 but with out permission to insert, edit or delete) and they correctly provide a drop down list for the user to pick from the 51 states and the 200+ Countries. Those work wonderfully).

I also have a Button Control
   btnSubmitInfo

The table (myFriends) that SQLSource1 is "connected to" has the following columns:
Column Name  Type   Length Nullable
   userID  uniqueidentifier 16 false
   userName  sql_variant  80

system.io.fileloadexception - could not load file or assembly system.data.sqlserverce version=3.5.1.

  

 

my application raises this exception but the file system.data.sqlserverce.dll is in the folder of the application, and the version is correct.

 

do u have any idea about this problem ?

 

thanks in advance for every answer Smile

 

hello from switzerland !

 

steve


Help me design this data structure system of multi-toggle buttons?

  

Lets say you  have three buttons, button1, button2, and button3.  Three buttons, have 2^3+1 = 9 possible binary states.

000,001,010,011,100,101,110,111

Each state will pull and retrieve data from a database based on the combination toggle states of the button.  However, not all data exists for every combination.  For example:

000 - exists

001-exists

010 - not exist

011 - not exist

100 - exists

101 - exists

110 -not exist

111 - exists

So now the problem is, how do I design the system so that when a user clicks a toggle button, the remaining possible buttons are either disabled or enabled?  I've thought about using a three-dimensional array but the problem is, when I have to add 30 toggle buttons, this looping becomes tediouis as each time a toggle button is clicked, the software  has to iterate through every possible combination again to check whether the truth table for that combination exist.

lets say from the above example, the user toggle button 1, which is 001.  His next possible choices are 101 and 111.  He can NOT choose 011 but the problem is 111 exists but to get to 111 he has to click button3 first, then button2, to get to state 111.  Because if he clicks button 2 first, his state becomes 011 and no data will be retrieved. 

see,

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend