in my application (asp.net) i have a filed ( phone code) and it contain a text box. and i want to restrict the user to enter only 4 letter after that the cursor should not print any character how can i write the code
How i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.
Currently we are saving files (PDF, DOC) into the database as BLOB fields. I would like to be able to retrieve the raw text of the file to be able to manipulate it for hit-highlighting and other functions.Does anyone know of a simple way to either parse out the files and save the raw text on save, either via SQL or .net code. I have found that Adobe has a filtdump utility that will convert the PDF to text. Filtdump seems to be a command line tool, and i don't see a way to use a file stream. And what would the extractor be for Office documents and other file types?-or-Is there a way to pull out the raw text from the SQL Full text index, without using 3rd party filters?Note i am trying to build a .net & MSSql solution without having to use a third party tool such as Lucene
I am new here, I was thinking about using a text box to function as a search box. For example, I key in the ID, the value will be searched in the SQL database and return other values in the same row. I was thinking of combining this with GRIDVIEW.
i'm bindng data to gridview using bound field.one column of gridview is linkbutton.if the text is more than the cell width then the gridview width is increasing automatically.for ex if i have text like "microsoft asp.net forums" then it's displaying the whole text.but i need that text like "microsoft.....".how to display like this in gridview?
i've made a list view to get data from my database. One field of the database is text. How can i make the listview to display only the beggining of my text? Because, now it displays all the text and it does not look good when you enter a large text.. (e.g. displaying the beginning of an article)
I'm using an ASP.net 3.5 FormView. I wanted to add an unbound text box with the ID="tbxEditFormMode" and set it to "EDIT" when a user selects an existing record from a dropdown list control. Here is my code
Protected Sub ddlSelectClient_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlSelectClient.SelectedIndexChanged
Dim tbxFormMode As TextBox = FormView1.FindControl("tbxEditFormMode") tbxFormMode.Text = "Update" End Sub
When I run it I get the following error message.
Object reference not set to an instance of an object In the tbxFormMode.text = "Update" Line
I have a field called IsAdmin in my user database which is a bit and i have used a checkbox for entering its value in my forms...but i get an error
Conversion failed when converting the varchar value 'System.Web.UI.WebControls.CheckBox' to data type bit. How do i sort out this error....and i want IsAdmin to be either 1 or 0 in my database
My asp page having 'ONLY ONE' record from database containing 150 text box fields.
User can modify any field but at the time of saving, some set of the fields should be updated into database and other set of fields into an xml file for later verification. This selection condition is dynamic for each text fields.
Since the page contains only one record from database table, the Update statement of stored procedure contains all the 150 records.
My plan is to keep old values in text boxes before the user making any change, and at the time of saving, set old value or new value to string variables and pass these variable to procedure.
I couldn't find any way to sort this out. I tried using hidden variables to store values, but at the time of saving, i'm unable to set old or new values into string variable. This was one way of thought, but can do any possible way to achive this.
I have MS SQL Server 2008 and I would like to store formatted text from a rich textbox. Formatted in the sense that I want to store a multiple choice question's formatting, an example would be like this:What is 2 + 2?
4 6 2 8
Then when I retrieve it from the SQL database it saves its formatting.
I have 2 tables A and B. Table A has a text field, fundIDs with comma delimited values like 23,44,55 etc. I would like to select all the records in table B whose ID matches the values in the fundIDs field from only one record in Table A. So, I need a function which first gets 1 table A record and uses the fundIDs field values to query and return all the matching records from Table B. I don't know how to parse and query in sql
I know that this is easy for those that know but alas this is not me ;)
I have a multi part form that is going to write to a dB.
As a point of reference I can offer [URL](i.e., the quote process) as a model for my project.
I need to write a record on the first page and then use the auto number generated from this to populate the child records with the parent's key field.
What I was hoping to do is write the record and then send the data from the dB to the second form. Iwill then need to repeat this process for the children of the child
I am only moderately familiar with ASP.net
one thing to add is that i am not forcing the user to create an account in order to maje the initial inquiry, only if they wish to reaccess theinformation at a later date.
I have a column with a random length of text, basically it's an old crappy mfg system that stores data in a tilde delimited list. I need to output this column into each seperate column for a view. Column names don't matter, they can all be unnamed but so long as the data returns as seperate columns is what I'm after.
I am using sql to create a table from stored procedures and then streamwriter in vb.net to create a text file based on the sql table. Where and how do I control the right or left justification of the records in the text file?
i have made fulltext index in 4 columns in a table ( 2 ARABIC columns (title,Desc(html) AND ENGLISH(title,Desc(html))it works fine locally when i use contains function in search but in sever arabic search doesnt work well .
I need to populate a text box from a stored porcedure call that does not have any parameters. I've made the database connection and am executing the stored procedure, but I cannot figure out how to set a text box value to the return value of the stored procedure. BTW, the stored procedure only returns one value.