I wanted to use the "create database query" from my ASP.Net page, say "install.aspx". So that when the page is run, it works as an automated tool to create database and tables required for the application.
1. What should be the connection string (if any)?
2. What functions are to be used?
how I can create a Database in SQL Express, then add tables and columns .. etc to the Database.
On PHP & MySQL I use to go into PhpMyAdmin and do that all there ! However with SQL Server Express and Visual Studio 2010. how to do it.
I am having problem when i was trying to attach .mdf file while create a new connection of SQL server, create a new connection of SQL database file and open the database in Server Explorer. I am using VS 2010 Ultimate and SQL Express 2008 R2.
Here are the error message.
1. Attach .mdf in SQL database file and open the database in Server Explorer
2. Create a new SQL server and attach .mdf
If I have a DataTable (in-memory) read by my C# program from a flat file, and I want to create it as a new table in a SQL Server database... what is the simplest way to do that?
It seems like something like SqlBulkCopy with an option to create a new destination SQL server table would be on my line of thinking, but I dont see a way.
I'm trying to restore a sql server 2k8 database from a .bak file. I've tried using two methods and both are unsuccessful. I've tried using the SMO classes and the error that I get is simply "restore failed for <serverName>". I also tried to simply run a query with the proper syntax for restoring a database. This runs but I get an error message that says the timeout expired. I tried extending the timeout through the connection string to 20 mins but it still fails within a minute.
This is my code:
SMO Method:
[Code]....
SQL Method:
[Code]....
I have some problems in database connection and wonder if I have something wrong in my code. Please review. This question is related: Switch between databases, use two databases simultaneously question.
[code]....
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Cannot open database "db" requested by the login. The login failed. Login failed for user 'root'.
.net frame work. I know about few controlin .net and I have tried few programs also. Now want to learn a databaseconnection in .net so please provide me one easy example of such program.
View 2 RepliesI have an page with upload the image by fileupload to the database the display the list of all the images in the same page by grid view,
I am not able to view the images but the rest of details like imageid, name are displayed here the code like have an look into this and let me know where i went wrong its urgent...
.aspx
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Item Name"></asp:Label>
<asp:TextBox ID="itmname" runat="server" Width="125px"></asp:TextBox>
[Code]....
How to store aspx code or c# code or any server control code in database?is this possible or not?i am trying to give Aspx code in textbox and click save button comes an error...
View 6 RepliesIa m new in asp.net and i had made a web project in asp.net+vb. how to create restore/backup web page in asp.net +vb so that the databse backup can be made and thereafter it can be restored through the web page.
View 1 Repliesi have a web application which is used for managing a workshop activities. i am willing to make a backup otion so that the database back (SQL) can be made.
View 2 RepliesUsing sql server and trying to insert decimal values using a ASP.NET C# code. I get the value for hours from a text box through user input and I'm trying to insert it to the database.
strSQLWAUpdate = " UPDATE Project SET WAHours='" + txtWAHours.Text + "' WHERE WAProjectID='" + hidWAProjectID.Value + "' ";
What happens is it rounds off the hours to interger value. So if I insert 22.3 in the text box what i get in the database is 22 and if I insert 22.7 I get 23 in the database. I do not need any rounding but need to get the values as it is. ( that is 22.3 and 22.7 respectively)
figure out the missing codes to get data from database and plot the latest 10 entries to database on the map.
this is the coding i came up with so far
[Code]....
I want to store the following code into the database:
[Code]....
and then get it back in the dataset and display on a page.
As of now I have successfully stored the questions with varchar(MAX) datatype but when I try to get it in the dataset i get the following error:
Failed To Enable Constraints. One Or More Rows Contain Values Violating Non-null, Unique, Or Foreign-key Constraints.
I am doing this in a ASP.NET web application.
EDIT:
Here is the Table definition of the table I am inserting the data into
The query I am using to insert the data into the table:
[Code]....
And finally the code by which I am extracting the data from the dataset
[Code]....
I want to bind a grid view by code not by wizard.
View 2 RepliesIt is a dynamic menu control that supposed to be used on different sites.
However sometimes there is no "childitems" to show etc...
Usually I would use a simple repeater that creates an unordered list.... eg. <ul><li></li></ul> or something like that.
But I need more control due to some of the Items in the list needs to be checked for some values and if they have a specific value they should be a head node like:
<ul>A
<li>1</li>
<ul>B
<li>1</li>
</ul>
</ul>
What about using a literal on page? And in code-behind build a method that returns a string, something like menyString = <ul><li>something</li></ul>.
Honestly is this really a way to go when you creating a menu, I thinking of loading-time etc...??
i want that site manager will create his own tables in the Database in 2 steps!!! the first one is to create table in the database the user can choose the name of the new table by textbox and the table get only one ID column:
[Code]....
in the next step i want the user will add/insert the columns to the table (one column each time) the user will have textbox for the column name, drop down list with few kind of data type (datetime, int, varchar) and after press button the column will add to the table.
code for creating hyperlink in c#
View 1 RepliesI built a VB.Net 3.5 web form which has the following fields; Category, Title, Keywords and Code. I would like to use it to upload common code that I have come accross for easy access to it for future projects (code re-use). It will be stored in a SQL database. My question is how do I place the code (html, css, javascript, .net,...) that I enter into the code field of my webform (asp:Textbox) in my table (nText field) so that it displays in a webpage with all the appropriate line breaks, html tags, javascript... Should I enclose it in "<pre>" tags?
View 6 RepliesI am creating HTML objects in my code, and giving them IDs (see below) :
[Code]....
But whenever I try to make reference to this ID in my code, it does not work. After viewing source, the ID has been changed to ctl00_ContentBody_divMTR. Why is this happening and can I prevent it?
what I need to do is turn a text boxs text into a url and redirect to the new page. here is what I have so far but I can't get the double values I need to work right and it does not do a redirect but opens in new page how do i get it to redirect.
If isAdmin = True Then
If bmName = "" Then
bmName = "(not set)"
End If
lblBMName.Text = bmName + "<a onclick='javascript:window.open(""EditMetric.aspx?sid=" & myDataTable.Rows(0)(1) & +"&kpName="& myDataTable.Rows(0)(0) """", """", ""fullscreen=yes scrollbars=yes"");' & "style='text-decoration:underline;cursor:hand;+
bmname'>"
Else
lblBMName.Text = bmName + "<a onclick='javascript:window.open(""EditMetric.aspx?sid=" & myDataTable.Rows(0)(1) & +"&kpName="& myDataTable.Rows(0)(0) """", """", ""fullscreen=yes scrollbars=yes"");' " _
& "style='text-decoration:underline;cursor:hand;+ bmname'>"
End If
How do i create access rule using code in web conf.
for example i have folder named secured and some rootdirectories under it e.g forum, account, members e.t.c so that anoynimous user shall be redirect to login page.
A have a web page that does an AJAX callback. When the CallBack event is handled, my ASP.NET code generates some JavaScript that is then returned to the browser. The idea is that this JavaScript will then immediately be executed. The reality is that it isn't....
Here is an example of my server code that handles the callback (the JavaScript has been simplified to a single alert):
[Code]....
I've tried using some of the browser DevTools in IE, Firefox and Chrome, but I can't get them to spot changes after an Ajax event...]
Does anyone have a working code for creating an affiliate link button such as that used by popular sites such as Facebook, twitter etc?
View 2 RepliesI am creating a check all box in a gridview from the code behind page by
case
DataControlRowType.Header:
CheckBox checkAll =
new
CheckBox();
[Code]....
i click in the checkbox -- the page reloads and the checkbox disappears.