I have created a table in my SQL database that has a primary column (Title) and another column named Callsign. How can I access the table row that has a certain title and Callsign using C# in a web page event handler?
View 7 RepliesI'm trying to add these 4 co,umns to the table as bit type woth a defaut of FALSE. What am I doing wrong here? I get a syntax error near (
create PROCEDURE [dbo].[AddADIFields]
AS
ALTER TABLE dbo.tblTESTS ADD (AI1 Bit 0,AI2 Bit 0,AI3 Bit 0,AI4 Bit 0)
Is it possible in to set up an SQL table column to have multiple values? Or would I have to put my values into a new table and link it to the original one?
View 6 RepliesI have just started using LINQ with VS2008. I have added extra columns to my table, saved the changes, but class ClassName.Designer.CS didn't get updated. What do I have to do to updated the class? Do I have to do it manually, or is there a way to automatically synchronize tables and ClassName.Designer.CS?
View 2 RepliesI am trying to replace all null value with space for all columns in a table.
(note: just we have to pass parameter table name "XYZ" result will come aotumaticly, we dont need to bother about column name)
i have done it through C# application. but love to do it through Sqlserver only like using storeprocedure, function.
my C# code is like that
[code]....
I wanted to know if it is possible to dynamically add columns to a table in the Database?I know how to create a table dynamically in the DB the code for it is given below, howver I do not know, how do I add columns to it dynamically.
Dim NewTable As String = "CREATE TABLE Dynamic " +
" (" +
" job_id smallint" +
" IDENTITY(1,1)" +[CODE].....
I've requirement where user can enter multiple columns like first name, lastname, email, age, sex fields and insert them into database.on my frontend aspx page, i'll be showing a single row initially with 5 text boxes(first name, lastname, email, age, sex) and a button to add more columns. when user clicks on add more, another 5 textboxes will be shown and then i'll be taking 5 + 5 (textbox values) and comma seperate them and need to insert into a table with primary auto increment key ID and the remaining 5 columns(firstname, lastname, email, age, sex). I previously worked on the same requirmeent but with only single column. Now i need to insert for 5 columns, How can i do this? Below is my stored proc which i used for single column insertion.
[Code]....
where can i find the tableadapeter to add data to my database table? and is that the best way or there a easier way... i have a csv file that i would like to add to my data table but i don't know how?
View 1 Repliesi am trying to find the column length of a particular sql table, it is working very fine if its 'nvarchar' or 'text' type. But if i try to get the numeric(int/bigint/bit) data type i am getting error. please help me out. The sample code is given below for you reference,'*** Source Code Start
Dim da
As
New OleDbDataAdapter(strQuery, PortalConn)
[code]...
how can i find the total null values in a table without using sql cursor .
i want to find the percentage of the data which is avaibale in the table and how much percentage of data is unavailable ( or null). to make a comparision chart.
i have 6000 rows and 200 columns in a table , if i use sql cursor , it is taking too much time to execute ( 6000 * 200 ) loops. is there any inbuilt-function in sql to do it .?
I have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?
View 6 RepliesI am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 RepliesI have a stored Procedure, which copies the data in one table to another table in other DB.
I have the query to copy the records to other table.
But, tomorrow, new columns are added to the source table, then, how to dynamically copy the data from those columns to the destination column..
I am trying to add dynamically gridview (headerstylewidth, back-color, height, etc…, itemstyle width, back-color, height, etc…), in codebehind but I am receiving this error:
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
See the code:
<asp:GridView
runat ="server"
ID="gridview1"
Height="175px"
Width="750px"
GridLines="Both"
onRowDatabound="gvdata_onRowdataBound">
[CODE]..
I'm creating a table in an asp.net code behind dynamically, and I want to have a footer row that only has 2 cells. The first should span all the columns in the table-1. Is there some way other then keeping track of the # of columns in the table manually for me to set the colspan to be # of all the columns in the table-1? Preferably a HTML or CSS solution?
View 2 RepliesI've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
Dim current as Double = 0
If Double.TryParse(xyz123.Tables(0).Rows(0)(x).ToString(), current) AndAlso current <> 0 Then
count += 1
totalNumber += current
End If
Next
Dim averageRating as Double = totalNumber / count
I have a datasource, which includes many columns, idealy, I need use a gridview to show:
1) first 3 columns: template fields, these fields depends on values in some columns of datasource. I use template fields, hard coded. works fine.
2) the other columns. This is I do not know how to do it. In the data source, there are about 10-20 columns data, each time, the # of columns of the data varies. idealy, I need show each of them as a seperated column in gridview. The entire data source may have 30 columns, but some of them are used in 1), and I only want show these 10-20 columns in gridview. Some columns in data source, I may not use them at all. is there a way to do this? or have to seperate them as a detail view style UI?
I wonder how to muliply two columns in a table and the result is displayed in the blank column and be specified by its row..
View 3 Repliesi need to extend this so that i can inlcude another column from a different table. so let's say i have a colume in table Price and the column i want to display in datagrid header is cost, how can i do this? there is code backend but could i simply code the below to include this column?
[code]....
i have a table that has some columns and rows i want this table to have borders that are visible inside it i want every column an row to be closed in borders how can i do that?
View 1 RepliesUsing formview or details view, I want to allow users to both input data into columns (I know how to do that) and add additional columns to the existing table if necessary.
View 3 RepliesBelow Error I getting Some Time Only once refresh the page its working ? System.IndexOutOfRangeException: Cannot find table 0.My live server database stored large data ,i can improve my application efficient.
View 1 Replieshow can i select a record from A table and insert into B table using linq?
View 2 RepliesBasically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
I pivoted my gridview with this code. But This code is not mine. Just tested and worked. But i dont know how can i add remove/add buttons to all columns.
[Code]....