SELECT * FROM tblstock WHERE Devicestatus=('Active') AND Model like '%"&criteria &"%'The statement above is a snippit from my code. My problem is that the search won't understand a space between say two words.?so if the user puts in DELL COMPUTER it won't return anything!? But if they put in DELL on its own it finds the record that says DELL COMPUTER?!!I'm just a bit confused that's all...
View 6 Replies(I'm using c#)how to select only the first 8 word from long string column?when using normal select it's select all the column how can I select only the first 8 words?
View 5 RepliesI was make last news form and I have problem with showing data am select top 3 news from table and showing oky but it's read all the filed see the image[URL]now I need first 3 words or 4 or 6 this is my code
[Code]....
i want to select only 15 words from table ,
View 4 Replies[Code]....
for some reason it doesnt return any values.
before i've added the inner join it worked perfectly.
i couldn't find my mistake, though i passed over it several times.
in my table data are stored many times ...I want select the only one data from the repeated data
select ven.Id,ven.Vendor_Name from Purchase_Requsition pur,Item_master itm,Approved_Vendors ven where itm.Item_Id=pur.Item_masterItem_Id and ven.Id=itm.Approved_VendorsId and pur.Request_StatusId=1 and pur.StatusId<>4
ID VENDOR_NAME
1 Ranbaxy
1 Ranbaxy
1 Ranbaxy
2 cipla
i want to make it thru query as
ID VENDOR_NAME
1 Ranbaxy
2 cipla
I have a pretty basic search feature on a site that queries a sqldb with a sqldarasource, and then displays the results on a page, in a panel within a Repeater. I'd like to figure out if it's possible to somehow highlight the words the user searched on as they are displayed in the search results. The code below is my repeater. Do you know of any way to manipulate the Title or Description if the words in it's body match the words searched?
<asp:Panel
ID="pnlExperience"
runat="server"
Height="500px"
ScrollBars="Auto">
[code]...
i would like to insert text in sql server that contains words like select and a single quotation mark but sql server gives errors like if i wanna insert this :
View 1 RepliesI debugged my code and it sets the visible to true and it doesn't show up in view/source either. PnlError is the one not displaying...
[Code]....
I am having one column named Location in My MS SQL 2008 Database and the values in the Column is like "Region/State/City" region, city and states are saperated by forward slash.
In that column some times City is given and somtime it is not provided means only Region and state.
Now, i need to extract that Region, state and city from one column to a view and in view there should be three columns State ,City and region.
I have tried the SUBString but it works on no. of characters but for different city and regions the no.
Sometimes, we need to remove excess spaces (including leading and trailing spaces) in a string like ' test test test test '.
We can do this in SQL server with the following user defined function:
[Code]....
Can the select command of a SqlDataSource be given by code in the code behind file. Also by calling the SqlDataSource.Select can the select statement be executed?
View 3 RepliesI am trying to add default item 'All' to my RadComboBox. It is adding at the end and also it doesn't select this default item. What could be the problem?
function OnClientItemsRequested(sender, eventArgs) {
var combo = $find("<%= RadComboBox1.ClientID %>");
var intextput = "All";
var comboItem = new Telerik.Web.UI.RadComboBoxItem();
comboItem.set_text(intextput);
comboItem.set_value("");
combo.trackChanges();
combo.get_items().add(comboItem);
comboItem.select();
combo.commitChanges();
comboItem.scrollIntoView();
}
<telerik:RadComboBox runat="server" ID="RadComboBox1"
EnableLoadOnDemand="true"
OnClientItemsRequested="OnClientItemsRequested">
<WebServiceSettings Method="GetMyData" Path="http://localhost:1606/Service1.svc" />
</telerik:RadComboBox>
I'm using a DropDownList with a data source which successfully populates the list. However, I want one of the items to be selected, namely the one where the value matches the path and query of the current request.
ddlTopics.DataSource = pdc;
ddlTopics.DataBind();
foreach (ListItem item in ddlTopics.Items)
{
item.Selected = item.Value.Equals(this.Page.Request.Url.PathAndQuery);
}
Using the debugger in Visual Studio 2008 reveals that item.Selected becomes true exactly once in the loop, but the rendered select has no option that is selected.
I populate the date field with DateTime.Today as the default date when the form loads in a TextBox then if the user wants
to change the date by clicking in the TextBox they can select a different date from the Calendar Extender that I have
connected to the TextBox so that they won't enter an incorrect date.
I tried to use an Ajax asp:MaskedEditExtender control along with the Calendar Extender, TextBox and default
date that is displayed but all of these things don't work together that way.
So the problem is that after the form loads the user still can enter an incorrect date if they highlight the TextBox
and type in a date into the TextBox instead of using the Calendar Extender to populate the TextBox.
I tried to use DateTime.TryParse to catch the bad date but DateTime.TryParse only catches some types of bad dates. For example:
99999999 will not get pass DateTime.TryParse
kkkkkkk will not get pass DateTime.TryParse
>>> However 1111/11/11 will get pass DateTimeParse but then when it tries to update the database it will give the error stating:
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
First the Date needs to be in the Format:
mm/dd/yyyy
Second 1111/11/11 if reversed is 11/11/1111 and is out of the range of what the error says the range is.
So my question is:
How can I get validate the date if the user doesn't select from the Calendar?
Below is the both html and code behind:
*** Below is the html:
<asp:SqlDataSource
ID="SqlIncomingForm"
runat="server" InsertCommandType="Text" OnInserting="SqlIncomingForm_Inserting" OnInserted="SqlIncomingForm_Inserted"
ConnectionString="<%$ ConnectionStrings:IncomingForm %>"
[Code]....
if a person does not select image in website in database null value go. when we retrieve data for that person i want if image is null then i want to show blank face image. for storing and retrieve image im using handler.ashx but not able to do the part that i have explained .
View 7 RepliesI am trying to write a stored procedure that takes out a list of blog entries from a table (tblFeedEntry) as well as the amount of comments that each blog entry has gotten (tblFeedComments) but all I can get is the total amount of comments of all blog entries together, displayed on all entries. This is how my code looks today:
[Code]....
I am guessing that the problem is that the declared variable is not picking up the id of the blog entries, instead it picks up everything. The original select and the select in the declared variable are not connected. How do I connect them?
Ive got an ASP:Menu in my page and want to display a background image for each item, and have that background change when the user hovers over, or selects it.
However, the UnselectedTab style applies when the page loads but then the style doesnt change on either select or hover, ...
Code in my asp.net page...
[code]...
I have a problem with an asp.net project.I have a default.aspx page with a webusercontrol ascx inside.I have one combobox in my default.aspx and another combobox inside usercontrol.If I fire up my simple application, I noticed that when I select an item in one of the comboboxes, the selectionindexchaged event doesn't fire and le dropdown doesn't close.I have AutoPostBack="True" an all combo.
View 3 Replies I have store procedure and I want to when I execute this procedure , Select field list in my gridview. But store procedure dont show every field(it doesnt show relation table.?)
This is my Store Procedure
ALTER PROCEDURE [dbo].[rps_CarePlan3]
@PatientName nvarchar = NULL,
@PatientTypeId int = NULL,
@StartDate datetime = NULL,
@EndDate datetime = NULL,
[Code]....
I see only BakimDestekDto(cause it is part of TblBakimDestek but other field isnt part of TblBakimDestek it is relation field). Why dont I see relation table field? Maybe public IList<TblBakimDestek> GetByStoreProcedure(string startDate) I use inside IList TblBakimDestek?
I am moving to the world of ASP.NET from an Access VBA / VB6 background and having read a few books on the subject I am still confused about communicating with SQL server in VB with ASP.NET.
As a very quick explination I am used to communicating with the server by passing strings containing the data I want to write (or read) such as:
[Code]....
I do not seem to be able to work out from ALAX, Dynamic Data, Bound Controls, DataViews, connecting to services with SOAP, DataSources and all of the other methods of database communication in ASP.NET which is the right system to do the simple reads and writes in SQL that I want to do.
At present I have a page with all of the controls on it required to collect a block of data I want to insert, it is all now fully validated but although I can build the SQL INSERT command in a string I cannot figure out how to fire it over to the local SQL Express server. Am I even doing this correctly or do I need to look at other controls?
This query does not return any record
[code]....
I have a GridView; one of the columns displays concatenated records from a tables. to extract the records that are going to be concatenated and put in this column, i have used: FOR XML path('') and it works just fine for displaying those records. the problem now is the whole gridview can not be sorted anymore and gives me a 404, document not found, error whenever i try to click the columns to sort. here is my select statement for my sql datasource select command:
SqlDataSource2.SelectCommand = "Select a1.*, keyword = substring( ( SELECT DISTINCT ', ' + keywordName FROM keywords JOIN key_mm_articles ON key_mm_articles.keywordID = keywords.keywordID WHERE key_mm_articles.articleID = a1.articleID FOR XML path(''), elements ),2,500) FROM articles a1 WHERE title LIKE '" & titles & "' Order By a1.articleID"
how to write a select distinct column1 from another select ?
i mean SELECT distinct column1 from (SELECT column1,column2,column3 where column1 =1)
I've just deployed my first ASP.NET MVC 2 site, and all appears to be well except I've run into an issue with IIS banning double-escaped characters, which I was relying on for a few routes.As I don't have control over IIS (it's on a shared host) I've decided to go around the issue and replace the spaces with underscores in my URLs. Have tested and verified that this works on my local machine, and deployed the two new model classes which contain the methods that url-encode and url-decode the various bits that need this.
However, the remote website hasn't apparently noticed that I've updated the code. I've edited web.config a couple of times to try and force a recompile, deleted the remote model classes and reuploaded them, and googled around for any other reason why this would be happening.