I have currently have Microsoft Visual Web Developer 2008 Express Edition and SQL Server 2008 R2 installed on my PC but I am having problems finding out where I enter my data to populate tables held in my db.
On the SQL 2005 version their was a option to open the specified table and add in information.
I've looked at both 2008 programmes and it's not obvious to me on how I would do this.
I am using Visual Studio 2010 and have a full version of SQL Server 2008 (not SQL Server Express 2008). I would like to be able to use the database that I created in Sql Server 2008 (not sql server 2008 express) but when I go to app_code -> Add Item and select SQL Server I get the following error message:
"Connections to SQL Server database files (.mdf) requires Sql Server 2005 Express or Sql Server 2008 Express to be installed an running on the local computer ..."
Do I really need to have sql server 2008 express installed on my local computer when I already have the full blown version of Sql Server 2008 installed on my local computer.
is there a way to add an image in SQL server database entry
say i got an colonm name [carmodel] in Sql Server and in that colomn name i got Toyota Supra can i attach an image to that Dataentry and how to ?
we have been able to return information from the database and then select the relevant link and return that row of information from the SQL table. The next part I am working on is adding information to the database.
So far all the coding in done in a class file, we are using stored procedures and have used user controls to return the information from the database and then also to select the row of information for each news item from the database. The sql database connection information and executing the stored procedure information is all done in the class file. how to add the news items to the SQL table. Below is the code that is used to return each news item from the SQL Table, how i need to amend this to rather than display the information, save it to the database. Also having used stored procedures, would I need to create another stored procedure to to the INSERT INTO statement
[code] ....
Scenario : I want to add data from database to checklistbox on page_load and checked data should be stored in other table.I want to bind data to checklistbox like a gridview, i m trying but i m not able to.
View 2 RepliesI have deveopmed i web site in ASP.NET and C# using Visual Studio 2008. I have a problem with performing button events twice. A user has a web page open. He click on a button (Save) and data is added to the database. He then presses F5 to update the page, and the button event is fired again adding more data to the database that should no be added. My question is how can I avoid this scenario?
View 3 RepliesI have created a web form where users input there details and submit it to an acess database. I also want the current data and time of there submition to be stored into the database along with the other information. I was thinking about making the time and data displaying in a lable or textbox and submit the the values within them into the database. I have been looking around the internt on how to do this but I couldn't get any of the examples I have tried working. Is there another way to create this funnctionality.
View 5 RepliesI created a site that updates a database through a detailsview grid, however it wont let me input decimals. An example of my code is
HeaderText="Assignment_Job_Type" SortExpression="Assignment_Job_Type" />
here's the situation:
You're using NHibernate with Fluent NHibernate for mappings.
You have an application in production with a database with live data You're adding a new feature in development and it requires a new database column.
The new column cannot be blank. For example, I recently had to a DateCreated column to a table and the app now uses that date. As the only time the data will be missing is now, it seems unnecessary to add code to check for errors.
In my application I have an updater which can execute a SchemaUpdate to add the new database column - however, the application will starting crashing as it is expecting a value in the new column.
I need to get some sensible default data into that column. In this case I manually ran an Update to set the date to the current date (good enough for the situation). In this particular case I believe that you cannot set the column default to getdate() using fluent mappings.
Keep a schema version number in a config file In the updater that runs SchemaUpdate start adding upgrade methods for each version. These methods would run updates to add default data (or other required actions).
After the schema update has been run, call all methods required for a version greater than the current version (i.e. those that haven't previously been run). So if the app is now version 4 and version 2 is installed, methods 3 and 4 would be run.
Is it possible to add values from different database rows to a dropdownlist?
I'm currently trying to add both ItemSizeSmall and ItemSizeMedium, but through trial and error I can still only add one row from the database. I want the dropdownlist to display "Small" and "Medium" etc.
I guess my primary question is: How do I create a database with product size attributes?
I apologize if this thread should be in another forum, but if the dropdownlist can display two database rows I'll settle with that solution.
Could the database look like this:
table1: product
PK: productID
table2: productAttribute
PK: productID
PK: attributeValueID
table3: attributeValue
PK: attributeValueID
FK1: attributeNameID
table4: attribute
PK: attributeNameID
name
If this is right: How do I make the dropdownlist display the different sizes?
i have read and used this script.Adding Dynamic Rows in ASP.Net GridView Control with TextBoxes..it is very usful to me but i want to fetch data from sqll database and fill the newest row with it. the past row data hav to be remain same. becoz of the same name of textbox it happens. whenever i try to fetch data from database and fill textbox all rows get updated with the same data.
View 1 RepliesI a problem defining the variable @Bestilling in the codeBehind for adding the record to the database using a single form page. The database design with corresponding form are as below:
My ASPX.CS:
private void GridView1_BindData()
{
SqlConnection conn = new SqlConnection(connStr);
SqlDataAdapter dAd = new SqlDataAdapter("SELECT kart_DemoOrder.OrderID,
[Code]....
I get error in the method: "GridView1_AddNewRecord".
Must declare the scalar variable "@BestillingID". Is there a way to use only one Add Method and not two as I did?
I have a dropdown list inside gridview which has a object data source and I am adding the list items as true, false which stores in the database table as a bit value. Even if i am addin the values 1 and 0 to the drop down list, its throwing the below error'grdDebug' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value My code to add the dropdownlist with list items are as below
<asp:TemplateField HeaderText="Debug">
<ItemTemplate>
<asp:DropDownList ID="grdDebug" runat="server" AutoPostBack="false" SelectedValue='<%# Bind("Debug") %>'>
[code]...
I am using this reference to make some application .. In this article we can only save with varchar data types
So how to use some other data types like datetime, money, int..or how to use parameters to convert data.
[URL] ....
I simply have a lot of data in two columns in an excel spreadsheet of data that I gathered. I want to copy and paste this (manually) into a table that I have created in my ASPNETDB in my ASP.NET web application. I thought it'd be as easy as copy the column, and hit paste in the "table data" view, but it's not (it only pastes one cell).
Is there a way for me to manually copy data from excel and paste it in a table in my SQL Server?
Does anyone know where I can find some info on how to support data binding in my control? I would like to get data primarily from a sql server.
View 3 RepliesI am tring to add a value to a hyperlink in a repeater and I am getting an error that the server tag is now well formed ? I have tried a bunch of different things and I still have not had any luck. I think its time for a second set of eyes at this point :)
[Code]....
m stuck at one place...i want to tranfer data from one database-1 to another database-2...both databases are for different web application.
Currently i am doing the same using dataset..but the problem is that when Large amount of data is coming in dataset so during the tranfer of data server gives me a Time out Error.
And another thing i am not want to utillise a server memory because there is Lacs of data into the Database for migrate.
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
I want to extract data from pdf form to sql server database. But I don't know how do achieve it?
View 1 Replieshow to copy data from one SQL Server database to other SQL server database using two connection string...
View 4 RepliesI have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
ight now I'm using below '<connectionStrings>' for my system on my local computer.
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=MY-PCSQLEXP;Initial Catalog=DBSOS;Persist Security Info=True;User ID=sa;Password=abc123" providerName="System.Data.SqlClient"/>
</connectionStrings>
Because I have a plan to connect and retrieve data from SQL database table from another server. Can I do that?
I need to create a script that accesses data from a few tables, one of the table is from a database that resides on a different SQL server. Does some one know the syntax for accessing a different server in a select statement. I tried the following
SELECT top 2 * FROM [myservery01].mydatabase.dbo.mytable
but it gave this error:
Could not find server in sys.servers. Verify that the correct server name was specified. If necessary execute the stored procedure sp_addlinkedserver to add the server to the sys.servers
This is a SQL server 2008 environment.
I am adding new clients to a database using ASP.net I want to check if the username the client has chosen is not already in use by another client and highlight the relevant input box and write a message to select a different user name if it is.
Is there way to write to a specific place in the HTML similar to innerHTM? I haven't been able to find such. Alternatively i guess I could try an interact with client side Java, or re-write the whole page.