i have an input form which connected to database...
after that i want to make a form to show all data which have been input to database..and this data will show in table and also i can sort the data by name or by date...
please help me...
I'm trying to build a visio addin that allows me to get a list of tables when a database reverse engineer is run.
I'm using the Microsoft.Office.Interop.Visio library.
I can find a list of shapes on the page, but this gives me every single shape on the page and every single piece of text. i would like to have a list of just the database tables (their physical names) in the document.
I have a database which users should not be able to alter data in unless they use the specific app. I know best practice is to use windows authentication however that would mean that users could then connect to the database using any other data enabled app and change values which would then not be audited.
Unfortunately SQL 2008 with its inbuilt auditing is not available.
Any ideas how to ensure that users cannot change anything unless its through the controlling app?
I have a MySQL database on my server and I"m pretty sure it's an int over flow on one table with an auto_increment field that's crashing it.
I can delete the table, it's not very important, but I can't get into the server.
Is there anyway to delete that database from the file system or without logging into MySQL?
HELP! THE WORLD IS ENDING!
Hi,
I have been told, roumerred, but can't find any documented evidence that it will invalidates your support contract with Microsoft Dynamics CRM 4.0 if you modify the database by scripting data into the database manually using TSQL.
Can anyone help with a link or confirmation that this is true.
Thanks in Advance
Iain
Hi all,
I have a rather large database that has alot of decimal columns in alot of tables, the customer has now changed their mind and wants all the numbers (decimals) to have a precision of 3 d.p. instead of the original two. Is there any quick way of going through all the tables in a database and changing any decimal column in that table to have 3.d.p instead of 2 d.p?
The db is on sql 2005.
Any help would be great.
Is there a simple method for copying a database diagram from one database server to another?
I have a diagram on a development server that needs to be moved to the production server.
Thanks
(Sql server 2005, SSMS2005 Express)
I installed a MongoDB database on my server. My server is in 32Bit and I can't change it soon.
When you use MongoDB in a 32Bit architecture you have a limit of 2,5Go of data, as mentionned in this MongoDB blog post.
The thing is that I have several database. So how can I know if I am close or not to this limit ?
Hi I need to backup MySQL database and then deploy it on another MySQL server.
The problem is, I need it backup without data , just script which creates database, tables, procedures, users, resets autoincrements etc. ...
I tried MySQL administrator tool (Windows) and UNchecked "complete inserts check box", but it still created it ...
Thanks in advance
I'm developing a form generator, and wondering if it would be bad mojo to store JSON in an SQL Server database?
I want to keep my database & tables simple, so I was going to have
`pKey, formTitle, formJSON`
on a table, and then store
{["firstName":{"required":"true","type":"text"},"lastName":{"required":"true","type":"text"}}
in formJSON. would this slow down the DB server too much to set live?
Any input is appreciated.
Is it possible to restore a MySQL database from the physical database files. I have a directory that has the following file types:
client.frm
client.MYD
client.MYI
but for about 20 more tables.
I usually use mysqldump or a similar tool to get everything in 1 SQL file so what is the way to deal with these types of files?
I'm developing a form generator, and wondering if it would be bad mojo to store JSON in an SQL database?
I want to keep my database & tables simple, so I was going to have
`pKey, formTitle, formJSON`
on a table, and then store
{["firstName":{"required":"true","type":"text"},"lastName":{"required":"true","type":"text"}}
in formJSON. would this slow down the DB server too much to set live?
Any input is appreciated.
I have scripted my SQL server 2000 database and created it on a 2008 server.
I update the database using a ADO .Net Dataset designed in VS 2003.
My problem is certain tables that have identity fields don't have these fields as auto increment in the dataset?
I could set these to auto increment in code, but this seams like a work around.
Has anyone encountered this problem?
It is easy to setup Datamapper with a Sqlite3 in memory database with:
DataMapper.setup :default, 'sqlite3::memory:'.
However, when testing, I'd like to destroy the whole in memory database after each test, instead of invoking automigrate! as a shortcut on dropping everything. Is it possible? Or is it enough to set the default repository to nil, and let the garbage collector dispose of it?
Hey i want to upload a MsWord file in database through joomla. And also how to retrieve it.
Actually i want retrieve it from a database and display it in a how is it possible.
Any code sample.
I'm trying to save dynamically created elements in my application.js file to the database. Would the code look something like this?:
$.ajax({
type: "POST",
data: { title: 'oembed.title', thumbnail_url: 'oembed.thumbnail_url'}
});
Is there anything I'm missing? Assume that oembed.title and oembed.thubnail_url hold the values I want to save, and that title and thumbnail are the database columns.
Is it possible to pass a SQL script to some method that Entity Framework has to run it against my model? e.g. equivalent of:
context.ExecuteStoreCommand(<tsql script path>);
Background: I want a way to reset the database during unit tests, and making a call to run the EF generated TSQL script (from Generate Database from Model) seems one way to achieve this.
Does anyone know how we can install BIDS for SQL Server 2008 without having to install the Database Engine?
With the SQL Server 2008 Express install it appears to be mandatory to install the Database Engine when all we would like the end users to have access to is BIDS to develop their RDL's to deploy to an existing SSRS instance?
It looks like BIDS 2005 was available as a standalone download - the toolkit - however I cannot find anything similar for 2008.
How is it possible to execute a direct SQL command to an ADO.NET connected database?
I want to send a DBCC SHRINKDATABASE to the SQL server, to compress the current datafile after a big deletion process. The function ObjectContext::CreateQuery returns a parser error after the DBCC command. Is there any other way to shrink the database file, or another way to send the SQL command directly to the SQL Server?
I have a text file.I need to get data from this text file and show on grid ,
1)After this user can update information from gridview,
2)Click on save button save data on database.
Before clicking on button data don't save on database.How to do that?
how to delete all records from database using linq.i want to delete all records from the database using linq.i am using MVC.so please tell me the code to delete all records using repository.
reply me soon
thanks
samir
I am working to make a basic file database, but I couldn't find the true codes.
Can anyone help me to save an exe file to sql database after read, download and use when I need it? With Delphi