In my database MYDB i have a table called MYTABLE and inside it I have a column called NAME. I want to only return the first 100 characters of the column NAME. (NAME can be up to 2000 characters).How can this be done in SQL as I want to set the first 100 characters to a ASP.NET label.
View 8 Replieshow to use database return many field and insert in a object(like any Collection ,Array,Hashtable etc)
[code]....
I want to display all the items existing in database for ex:
If i enter just book. All the items with book work should get displayed
Example in google search as soon as we enter one word related all things get displayed. I am not talking about auto completion
I have a low level quiz. this is a mvc project
in PostRepository.cs, it has some code :
[Code]....
and then , in PostController.cs , I wanna a field in database call postStatus, the code is:
[Code]....
When I edit the post ,I hold the selectlist can show the option what is in database. But the code not work will.
then I use the Response.Write(postStatus); to test what happen. And the Browser show some code on top side :
[Code]....
I wanna what's up with the code and I want to know the suitable method.
I have a date field (OrderTimeStamp) in Database which allow nulls.When I try to return this field in my LINQ Query I get this following error.Cannot Convert expression type System.Nullable<System.DateTime> to return type System.DateTime
I do not get this error when I try to return other fileds which also allow nulls. Like FirstName and LastName. Then Why I get error when I try to return a date field?
[code]....
Using SQL Server 2005.
I need to return the year only from a datetime field and then group by that field, does anyone know the syntax for this?
i want my query to return results where the field address is not empty or null
however, the query i have is still returning results where address is empty i.e. ' ' .
Dim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesI want to return single field to a different webpage using hyperlink.
View 12 RepliesSay I have a table Comments with these columns: Id, Comment, Category, CreatedDate, CommenterIdI want to get the top 5 categories from the Comments table (based on the count of each category in that table). How can I do this in linq, to return either List or IQueryable?
View 2 RepliesI must be doing something wrong, but this makes sense to me. I have a Listbox loaded with tons of items from a datasource. A user clicks one of these items it grabs the selectedindex (an integer) and stores it in a HiddenField (works fine).
Now when the page does a complete a refresh (after postback) I want the ListBox to go back to that selectedindex that is in the HiddenField. Problem is, it seems that after postback the HiddenField is empty? Then I thought about storing the value in an Integer variable in code, but that is simply coming up as a zero at all times.
Question 1: What is the best/simplest way to do this?
Question 2: How?
I am currently grabbing it on selectedindex change
[Code]....
I am trying to return a column value from a database table. I am not sure if this is the best way to do it but I would like to make a funciton so all I have to do is pass a sql string and have it return my value (or row). Here is what I have:
private
DataTable sqlQuery(string sqlStringInput)
{
[code]...
In my database MYDB I have a table called MYTABLE and I have a column called Description. I am saving a long description in there with multiple HTML tags.
How can i return the values and not include all the HTML tags?
Is this even possible? What will be the best way of doing this? In the SQL statement or in code behind? And how will I do it?
This issue has a few different facets so I wasn't sure what topic to post it in.I have a DB query like this:A SELECT statement with an INNER JOIN of two tables: [programs] and [program_managers] then on an aspx page ProgramManagers.aspx, I list the Project Managers, ordered by the Priority field of [programs].
I take the query and put it in a DataTable.Then I loop through the rows 1 by 1, creating Labels, etc to display the content.
Now here's the issue: Because a given Program Manager may manage more than one program, when I display this way, the Program Manager's Bio etc, gets listed as many times as their are programs that they manage.
[code]....
I have a Gridview control on an .aspx page. what is the first gridview control event, that gets triggered/fired.
The gridview control that I have have boundcolumns. I have configured the selectcommand in the .aspx page to pull the data from database as shown below:
Code:
[code]....
Question: Where the sql doesn't return any data from the database I would like to display some message on the .aspx page saying "No records found". To do that, I need to know the gridview event that gets fired.
I have a little problem with a query. I'm selecting data using the between command, But when I select the initial date equal to the final date the query doesn't show data.I know that the problem is the format. In my database I got something like this:2009-05-22 15:32:52.000. But when I send the date parameter from ASP.NET Page I sent only the Date (2009-05-22).So, I want to fix this thing. I cannot change the Datetime inside the database.I was thinking adding 1 day to the final date, So when the user select the same date I change the range behind the scene and then show the data. What do you think?
View 8 RepliesI have a asp.net page with .net controls. For a long time, many years, pages was run correctly. But lately some signs were change from their normal display mode to squares. Looks like some encoding issue, but changing it, dosen't .How can I resolve this issue? Why do I see square boxes instead of some signs?
View 3 RepliesI would like to know what the expression for "letters only" is for my asp.net web application. I tried ^[A-Za-z] but it does not work I would also like a regular expression for "numbers only except "-"
View 3 Repliesi am trying to rewrite utl's that contain Hebrew letters, using regular expression, and i am facing some difficulties: This is rule i am using:
<rewrite url="^~/(.+)?sbc_forum([0-9]+)(_([-a-z0-9]+))?.aspx(?(.+))?$" to="~/$1Default.aspx?g=forum&c=$2&$6" processing="stop" />
The bold text suppose to validate pattern that match to Hebrew letters. I am trying to use: ^[p{L}]+$. But its not working..
How can i return images from my database (Access) to RSS in form of thumbnails this is my RSS code:
Code:
[code]....
I have a products table whereby I want to return a single row via a product id and use it as a data object.
I have used a .xsd dataset and a product class where I return a dataset and add the values into the product object that I created but I don't like having to write code like
"Product[0].ProductDescription" to get the product description. Is there a way of returning is straight as an object rather than a dataset?
I receive lists from a web service and then I convert the lists to datatable and then I add the datatables to a dataset and from there I get the xml from the dataset where I can save it into a sql database. But the problem is that the xml has /r/n between all attributes and elements. I dont know how to get this out of the xml. Can this be because of my converter. If so can anyone give me a better way to get multiple lists into a dataset.
View 2 RepliesThe instr function compares two strings and returns an integer specifying the place of the string found.
if I want to search "Quick brown fox" for any of the letters "A B C D", is there a function that can do this?
I am using Helm server for my web hosting, in my control pannel when i tried to create an email account named hr@mywebsit.com it shows error
The POP3 Account 'hr@mywebsite.com' is invalid. specify a valid POP3 account name.
but when I trid hr1@mywebsite.com i can create, so how can i create email accounts with two letters
In short, I want to implement a search engine. I pass the search string as a http querystring and my database uses it as a filter in Select. The problem occurs when I enter some non-standard english letters. Let me elaborate: on Main.aspx page, when I click on "Search", a function calls "Main.apsx?search=something". The querystring is passed as a filter to the database which returns values depending on the filter. The database holds correct data at the moment.
After that, I dynamically modify some hyperlinks' url to something like this: hlink[i].NavigateUrl = "Detail.aspx?search=" + base.Request.QueryString["search"] + some integers;. I want users to be able to click on the link to get details on the result. If they click the link, since a new page is now opened, the database has to be refilled (from cache). The same function for filtering the main database is called with a querystring which should be the same as the search string, but somehow it isn't. It looks like something was lost in a conversion or something. If I use standard english letters, everything works fine. I noticed that prior clicking the link the query string had a value like /u0100d for the non-standard letter, but after clicking the link the value had changed to something like /u0ffff. It obviously isn't the same when typing something in the search box and hitting "search", and when putting this search string into NavigateUrl and clicking on it.