I have a table converted from Access and the identity keys were lost. Now I need to make the id column the identity column, but it already has a lot of null values, how do I auto generate integer values for the null rows? The row ids are incremented, so if there is a way to auto increment the ids
I have a sql table which has one row of value. In my application i want to rename the column name as the first row values. I am using as keyword but waht do i put after 'as' for the first row values
I know this is a newbie question but, alas , that's what I am. How do I keep values in specifc sql server table unique, in other words how do I prevent any duplicates happening upon creating (inserting) a new table row?
I was thinking about the fastest way to retrieve a "set" of objects related to a specific user. For instance, if I was to create a website similar to Flickr where people upload lots and lots of photos(jpegs) what would be the fastest way to be able to retrieve those photos from the SQL Server database. Scenario 1: You store metadata about each file they upload to the website as a single row in a database table. Then when you want to retrieve a specific users uploaded files you simply scan the database file for every row matching the UserID and store them in memory.
This, of course, gets all the information about all the photos a single user has uploaded. My concern with this approach is when the user activity goes from a few thousand to being in excess of a million.
This approach seems fine for a small website but does this method work for a million plus user website like Flicker or MySpace? When you have a million users and millions more photos does this approach still perform at acceptable speeds?
create a collection in memory of "ALL" the PictureIds' for a single user and store them in-memory, in a collection and then save this collection as a single VARBINARY(MAX) field in the SQL Server Database. So instead of having to find multiple records in the Photos database you would simply need to find one, which would include all the PhotoIds' that belong to the user. In essence, translating into the phrase, "If you find one, you have found them all". And improving server performance by leaps and bounds. I only have about a year experience in working with SQL Server and ASP.NET so Im not sure if this solution is practical, if its already been tried, if it can be done.
Now the issue is that that every document doesn't has document number. I want to make invisible the docuNumber column of the grid viwe if all values in the docNumber retrieved are null.for example:
docnumber tite null Document 1
null Document 2
null doucment 3
null document 4
if returned result match above where all docnumber are null then make the gridviwe docnumber column ivisible eslemake the greidviwe column visible.
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?
Possible Duplicate: How to assign Profile values?I want to save some values in Profile in asp.net MVC controller, How can I access the profile object in controller ? What namespace Do I need to add. I have added few name value pairs under profile section in web.config.
I have a simple web app built in asp.net webforms c#where and how would be the best way to save info from the code behind?(and also retrieve that info)eg all i want to save is a dateTime. and a flag set to True or False.and be able to access them in the code behind.Im not using a db for this web app.Edit: and can't really use session variables for this purpose.
I want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
I have a website project in asp.net (c#). I created some text fields and dropdownlists. the user fills the text fields etc.., the dropdownlists gets data from database (.mdf) and when the user clicks on the <submit> button, I want save all the values from textfields, etc.. in my database table. How can I do this exacly ? I get the values for ddl from database with this method, [URL]
I have a checkboxlist on a c# page where when a box is checked it saves its value in the following format to a textbox
1,2,3, etc...
[Code]....
This works ok however the problem is i want to be able to audit the values i save in the DB. For example i may want to do a count how many times 1 appears or 2 etc..
I am creating dynamic view using two tables.one is emp_Tbl and 2nd table emp_salary which is created dynamically .creating view it gives error 'Create View or Function failed because no column name was specified for column 2.
my code is: create view [dbo].[Emp_Salary_pay] as select dbo.Emp_Tbl.Emp_Status, (select column_name + ', ' from information_schema.columns where table_name = 'Emp_salary' ) FROM dbo.Emp_Tbl INNER JOIN dbo.Emp_Salary ON dbo.Emp_Tbl.Emp_Id = dbo.Emp_Salary.Pay_Emp_Id
I have a code here,where it will store temporary data in a gridview from textbox where when the data is stored temporarily in gridview. Alternately,it will be linked to search the word in google. Now i want to save the values in the gridview to database. I m new to asp.net,seeking ideas from all. Here is my .aspx code:
I have an application where in a simple aspx page I have a linkbutton called "View" that redirects me to another page passing scenarioId as a parameter.
In the new page, I would like to pull up a db record pertaining to that Scenario and store those values somewhere so that, if I do a post back on that page, I am able to access those values, along with other new parameters to pass into another stored procedure that does db updates.
As there are about 10-15 different values, it does not make sense to me to have a property declared for each variable. I feel there is a better way to store those values together as a single entity like a class or a structure and save and load from viewstate during page loads and postbacks respectively?
What I want to happen is, I will populate or load the patient Name into TextBox. If the patient are 20, the page will dynamically create 20 textboxes to display the patient name..And when I click save, Changes will be save base on the input on textbox..
I have a form with several DropDownlists and TextBoxes, Each dropdownlist depends on the selection of the previouse one.. and there is a submit button. Once the user clicks on it, information entered by the user is displayed in a GridView and saved as well in the database. The GridView holdes information from two tables I used joining) , but once I click on the Submit button I receive this error: Arithmetic overflow error converting varchar to data type numeric. The statement has been terminated. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Arithmetic overflow error converting varchar to data type numeric. The statement has been terminated. Source Error:
[Code]....
Imports System.Data.SqlClient Imports System.Web.Configuration Partial Class Members_MembersCalculator Inherits System.Web.UI.Page Protected Sub CalculateButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CalculateButton.Click Dim objConnection As SqlConnection Dim objDataCommand As SqlCommand Dim c_manu, c_model, c_date As String Dim sSQL As String Dim ConnectionString As String Dim c_factor As Double Dim c_result As Double Dim c_milage As Double Dim c_id As Integer Dim c_year As Integer c_manu = ManDropDownList.Text c_year = YearDropDownList.Text c_model = ModelDropDownList.Text c_milage = MilageTextBox.Text c_factor = FactorDropDownList.Text c_id = CarIDDropDownList.Text c_date = CarDateTextBox.Text c_result = c_factor * c_milage ConnectionString = WebConfigurationManager.ConnectionStrings("Carbon_free_ConnectionString").ConnectionString objConnection = New SqlConnection(ConnectionString) objConnection.Open() sSQL = "Insert into car (Manufacture, year, Model, car_factor)" & _ "values('" & c_manu & " ', ' " & c_year & " ',' " & c_model & " ', ' " & c_factor & " ')" objDataCommand = New SqlCommand(sSQL, objConnection) objDataCommand.ExecuteNonQuery() objConnection.Close() objConnection = New SqlConnection(ConnectionString) objConnection.Open() sSQL = "Insert into car_Result (car_id, car_Result_Date, Car_result)" & _ "values('" & c_id & " ', ' " & c_date & " ',' " & c_result & " ')" objDataCommand = New SqlCommand(sSQL, objConnection) objDataCommand.ExecuteNonQuery() objConnection.Close() msgLabel.Text = "Your records have been calculated successfuly, Thank you." 'CarDateTextBox.Text = "" 'MilageTextBox.Text = "" CarGridSqlDataSource.DataBind() CarGridView.DataBind() End Sub End Class
