how I add multi-column constraint to a table in SQL2005 ?
I want to prevent a user from entering a row in the table where Column_A = 1, Column_B = 2 etc where there is already a row where Column_A = 1, Column_B = 2.
I am working with a set of data that looks something like the following.
[Code]....
The name and number of assignments, I need to get results simlilar to the following.
[Code]....
"New york, NY, 01134000"
I have to detect the "," (the coma character in the above field that contain address informatiom) in order to to be able to break and transfer the information into 3 independent fields
I want to be able to insert any kind of text into a sql 2005 database. The column im using to store this is ofVARCHAR(MAX) type . Basically , even if the text contains special charectars or unicode content or html tags I should still be able to insert it into the database without any errors. Please guide me on how to achieve this.Things I tried that did not work !- changed the column to type NVARCHAR(MAX)-Tried Server.HTMLencode for the column that accepts the textIs regex a solution for this problem. If so how can i implement it?
View 8 RepliesI have a multi- statement transcation in my stored procedure, that is either inserting or updating records in table1 and table2.
table1 has a check constraint. Will the check constraint be checked only after I call COMMIT in above transaction, OR will it be checked before I call COMMIT when using INSERT or UPDATE statement?
is there a SQL statment i could write that would sum each column and allow me to then access each sum individually
i.e
Dim objCmd As New OleDb.OleDbCommand("SELECT SUM(expression) FROM orderForm WHERE OrderDate=@OrderDate", objConn)
is there anything i can replace expression with such that all the columns in orderForm could be summed and returned as one record
or is there a way to replace expression with something that would allow me to just keep changing the paramater so i could continuously reexectute the same command w/o having to create a new command for each column
I have two tables - dt(Mods) and dt(Mods2) - I am trying to create a relationship between them. So dt(mods) has department, category and item columns dt(mods2) has parentDept, Parentcategory and parentItems Now I need add them to a dataset with a relationship key - Something like this but with three cloumns
Dim ParentCol As New DataColumn, ChildCol As New DataColumn
How do I select multiple columns into IQueryable<Employee>?
View 2 Replieshow to write that below query in linq
DECLARE @Name varchar(20)
Select @Name = empFirstname+','+empLastName+','+empBankCode From srpEmployee
PRINT @Name
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 Repliesthere are multiple rows with same SubContact_No and with same value of some columns. for a single column I am firing query like
Select distinct (Financial_Status) from mtblSub_Contract where SubContract_No=@SubContract_No";
it's working fine.... (it's ok with a Single column)
But Now I need multiple columns value so how to query for this.
Select distinct (Financial_Status, colums2, column3) from mtblSub_Contract where SubContract_No=@SubContract_No"; is not working
So how to do that.
This question is for wrapping up work on a database driven AJAX AutoComplete Control that I am using to provide keyword hints to user on search pages. Each record has 6 columns for keywords where each column is for an advertiser to add a keyword. These are used in meta keywords tags, but I also want to use them for AutoComplete. The problem is that I don't know how to write a SELECT statement in Visual Studio that treats all 6 keyword columns as if they were all one column. I am looking for something like
SELECT (keyword1 + keyword2 + keyword3) AS Keywords
FROM (Merchandise)
WHERE Keywords LIKE @term
The only other thing I can think of the gain this level of functionality would be to combine them into a new table.
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]....
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 want search with multiple names in Name coloumn. example I have pass the criteria to Name cloumn is 'Atul', 'Mayur', 'Suraj' this three names how to pass in a query.
View 1 RepliesI have a question in gridview, I want to combine my two or more records into a single cell with two rowsfor Example i have a ID, Name, Year Start, and Year End for Column name in database and i want call it into my gridview that the Year Start and Year End will combine to Year like:
In Database
ID Name Year Start Year End
1 Yourname 2010 2015
In Gridview:
ID Name Year
1 Yourname 2010 2015
in a year column i want it to two row..
I want to bind three column with one row in gridview in asp.net with c#,
i want like this,
Name | Info
----------------------
name | lastname
| phone number
| address
I get this by default
name | last name | phone number | address
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 have a scenario in which I want to display Multiple Columns in ListBox. I am working in .NET 1.1I am binding data to ListBox from DataTable. Example: I have Two Columns in Table ID, Name. So I want to display ID and Name in a Single LISTBOX.
View 6 RepliesHow can i create DropDownList which shows multiple columns and only one column selected on selection.
View 1 RepliesThe user enter the name,address,country,qualifiction,experience the user enter more than one qualification, and experience the add another button click will add another qualification, and experience...i am confused in designing the database how to design the database for this . i am design this tables .
==employee table== ===Qualification== ==Experience===
employee_id qualificatin-id Experience_Id
employee_name University Company
employee_address Degree Year-of-0experience
employee_qualification End_Date employee-id
employee_Experience employee-id
I want to search data from three text boxes how can i write code in one button click ??? This if else is not gud formed
protected void Button2_Click(object sender, EventArgs e) {
if (TextBox2.Text == "" || TextBox3.Text =="") {
DateTime dt = Convert.ToDateTime(TextBox1.Text);
SqlCommand cmd = new SqlCommand("SELECT * FROM Transactions where report_type = @report_type and dateadd(dd, datediff(dd,0, [R_date]), 0) = @R_date ");
[Code]...
Gridview code :
<div class="table-responsive">
<asp:UpdatePanel ID="ExistingBuilderGrid_UpdatePanel" runat="server">
<ContentTemplate>
<asp:GridView ID="ExistingBuilderGrid" CssClass="table" EnableViewState="False" AutoGenerateColumns="False"
[Code]....
I want to merger both Fields and both Values column HEADER to one Header cell like Business Assigned Resource ...
NOTE:
dont merge the data cells , only merge header cells
I have one dropdownlist control in my web page.
I want to fill my dropdownlist with multiple columns.
How can i acheive my goal?
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
