I have 2 tables:
- Salesmen with Pk.SalesmenID
- Appointments with Fk.SalesmenID and busy(bit)
How can I check if every salesmen has at least one appointment
Am I on the right way with statement below, though I got syntax problems
[Code]....
I have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
How to return count of true/ false in a column of a table. I have a table in sql containing 5 columns with bollean type. Now I have to return the number of trues and falses in each column and display on my frontend.
View 1 RepliesI have an approve button.on clicking on this button it should show that an inactive value is present .Onclicking yes conformation it should save the data or else clicking on no conformation should return false; how i will do that?After alert it always submit the data.
protected void ibtApprove_Click(object sender, ImageClickEventArgs e)
{
string otherAffiliateName = txtRequestedAffiliate.Text;
int inActiveAffiliates = new BLRating().InActiveAAffiliateChecking(otherAffiliateName);
if (inActiveAffiliates > 0)
[code]...
This is the code i used.how i wiil stay back on Confirm 'no' click?
I have a SQL database that creates a record for every document uploaded by the user to the server. I want to check this table before a user uploads a document to ensure they don't upload a file with name that already exists.
I know how to make the connection and make the SqlCommand to query the table for an existing record. But I don't know how to check the record count from the sqlCommand I made.
Does that make sense?
Using myConnectionCheck As New SqlConnection(myConnectionStringCheck)
Dim myCommandCheck As New SqlCommand()
myCommandCheck.Connection = myConnectionCheck
myCommandCheck.CommandText = "SELECT * FROM Req_Docs WHERE Doc_Name =" & DocName
myConnectionCheck.Open()
myCommandCheck.ExecuteNonQuery()
End Using
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]...
how to check if the particular values in a table exists?
if it is not existing i need to insert that values in the table?
I need to check whether table named 'CSE' is existing in database or not. if it exists, i want to drop the table 'CSE'.
View 1 RepliesUsing C#.NET and VWD 2008 Express
I'm looking for a hand with:
When inserting, i would like to check if the record exists in the table, then if it doesn't, insert it, else either redirecting to a different page, or showing a message box saying "Record already exists" ...
if It is okay to delete entry directly in any aspnet_* table ? because i screwed something.
View 3 RepliesI have two tables as below.
I tried to establish a relation between two tables in such a way that Table_Contracts will still accept NULL values for [PO_No], but [PO_No] on TableContract will be automatically updated when [PO_No] on Table2_PONo changed. Moreover, if you want to delete a record on Table2_PONo, it needs to be stopped if there is a related data in Table_Contracts.
I set a relation with these parameters:
Check existing data on creation or re-enabling>
No
Enforce for replication>
No
Enforce foreign key constraint>
No
Delete Rule>
No Action
Update Rule>
Cascade
I got this error
Introducing FOREIGN KEY constraint 'FK_Table_Contracts_Table2_PONo' on table 'Table_Contracts' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Table2_PONo
[PO_No]
(primary key)
[Project_ID]
[SupplierID]
[Description]
[TotalPrice]
[PO_Currency]
[VATpercent]
[CostCode]
[Notes]
[PO_Date]
[Reality]
[UpdatedBy]
[FromAccess]
Table_Contracts
[ContractID]
[ProjectID]
[PO_No]
(accepts null values)
[ContractNo]
[ContractDate]
[ContractValue_woVAT]
[ContractCurrency]
[SupplierID]
[ContractDescription]
[ContractType]
[LinkToTemplatefile_DOC]
[SentToSupplier]
[SignBySupplier]
[SignByMercury]
[CollectionBySupplier]
[LinkToPDFcopy]
[ArchivedByMercury]
[UpdatedBy]
[Retention]
[Note]
I have a table with three columns (ProdID,ProdName,Status). I m fetching that into a dataSet and binding that to my gridview. I have a very basic and simple rowdatabound event like this :
[code]....
how can i compare my status against True or False in my if condition.
how do i check if a bit value is true or false and if false, then write another value.
Here is my code
<%# DataBinder.Eval(Container.DataItem, "gp_referral").Equals("False")?"":"xxx"%>
Am trying to check if gp_referral is false, and if so then write xxx, but in my code, whether true or false it evaluates to xxx
I have three table in my database they are ...
1. Category
2. Forum
3. Topic
I need to above three table information into a single table ...
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 RepliesMy table is :
ID Dated
-------------------------
1 2010-01-01 00:00:00.000
2 2010-02-20 00:00:00.000
3 2010-09-15 00:00:00.000
4 2010-04-03 00:00:00.000
5 2010-11-09 00:00:00.000
6 2010-12-11 00:00:00.000
7 2011-01-18 00:00:00.000
Now I want to find(select) Id and dated columns which have a difference of 4 months(less or greater than) from previous ID (row).
Expected Result
ID Dated
1 2010-01-01 00:00:00.000
2 2010-02-20 00:00:00.000
6 2010-12-11 00:00:00.000
7 2011-01-18 00:00:00.000
How to do this.
How can I search a word in all the columns of a table?
View 4 RepliesI've a table where one person teaches multiple classes. It looks like this.
Table1
Id Name Class Subject
----------------------------------------
2 Sam 12 English
2 Sam 10 Maths
2 Sam 10 English
2 Sam 8 History
2 Sam 12 Economics
Here Sam teaches Class 12 - English & Economics, Class 10 - Maths & English, Class 8 - History
I want to display the result like this -
Id Name Class Subject
---------------------------------------------------------------
2 Sam 12 English, Economics
2 Sam 10 Maths, English
2 Sam 8 History
How to concatenate multiple Rows?
I would like to use ASP.net, C# and SQL to display a list of games with radio buttons like below (the x is the radio). One team can be selected for each game.
game 1: x team 4 x team 2
game 2: x team 6 x team 1
game 3: x team 5 x team 3
The game list is stored in a table in an SQL database. So far, I can pull all teams into one big RadioButtonList. I cannot figure out how to create multiple RadioButtonList controls from this single table of games. Does anyone know how this can be accomplished - or reference to an example / tutorial that accomplishes something like this?
how to give a multiple inner joins to the single table
View 1 RepliesI tried nested ListViews but can get the display wanted.In my database I have a Category Table and a Product table.They share the CG_ID value.I want to make a stored procedure that will use two select statements to produce a single table.that can be used as a ListView DataSource.
[code]...
I would like to check whether a folder exists or not if not create. I'm sure this folder exists, but for some reason I get "false" when I check with "Exists" method.
The only reason I think could be because of the W: drive? I moved this application to production site and even there it returns false.
while I'm type in Windows explorer on my localhost and on the server "W:/Webs/ASPPages/cropper/uploads" it opens this folder. So my localhost and IIS server has W: mapping.
for test I tried to create the folder then it says can't find the path...
userFolderName = @"W:/Webs/ASPPages/cropper/uploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried "W:\Webs\ASPPages\cropper\uploads"
DirectoryInfo dirInfo = new DirectoryInfo(userFolderName);........
I am doing a data warehouse project.I have two tables tblA (id, type) and tblB(city, no_crimes, type).I want to create (insert) a number of rows based on the value of no_crimes.For Example, in tblB(Leeds, 2000, murder). SO, I need to insert 2000 rows into tblA by a single INSERT statement (not 2000 statements).
View 3 RepliesI need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
I want to be able to display the entries in this table based on the date and time of recorded in the entry.
So as an example:
Entry A only appears on Mondays at time X.
Entry B appears on Tuesdays at time X and Sundays at time X.
Entry C appears every day of the week at time X.
Entry D appears every day of the week but twice on each day at time X and y respectively.