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?
View 1 RepliesHow do I left justify? Somce of my coluns are numeric and the users need to seem them left justified.
View 2 RepliesThe first step to reproduce the behaviour is pasting a specifc text from a PDF document into the HTMLEditor:
After that, select the text:
And then, click the Justify button. The selected text simply disappears:
The HTML code generated by the content:
The same happens for other texts like (also pasted from the same PDF):
The correspondig HTML markup generated by the HTMLEditor:
It seems like HTMLEditor has problems with some characters like " or subscripts. If the same texts are pasted into Word and then copied into the HTMLEditor, it works ok and the text is justified correctly.
The DoctorGen Table has primary key DocId and Doctors has Keys set on DocId and MemId. I want to get all records from DoctorGen where UserID = @UserId even if there are no matches in the Doctors Table. I'm not getting any records.
[Code]....
I am reading a column value from the database. The field is defined as 30 charswide. If the vale read is less than 30 chars, I need to pad it on the right side withblanks. So that the value when written to a text file will appear to be left justified.How can this be done? I know how to right justify like below. But how do I left justifyand pad on the right side with blanks?Right(LTRIM(RTRIM(CustomerNum) + SPACE(30)),30) As CustNum -- This right justifies.This will NOT left justify so I am stuck :LEFT(SPACE(30) + LTRIM(RTRIM(CustomerNum)),30) As CustNum -- This WIL NOT justify as I wish
View 2 RepliesHow to use Left and Right Outer Join in C# using Linq with Eg.
View 2 Replieshow to do this query in EF1:
[Code]....
I have 2 different datatables. 2 datatables from 2 different servers.
My first datatable is this:
SELECT DISTINCT a.name, a.create_date, a.Modify_Date, a.Object_Id
FROM dbname.sys.objects a
and my 2nd datatable is the same, but from a different server connection string
SELECT DISTINCT b.name, b.create_date, b.Modify_Date, b.Object_Id
FROM dbName.sys.objects b
Basically, I want to compare which procedures are on one server and not the other (dev and prod)
So after I have my 2 datatables i want to create a data relationship on the name and then do a left join to see whats in a and not b.
how to get sql query output in text file?
View 1 RepliesI have a text file. now I want to insert those text file's data into my database by C#.net
my text file is like:
rec alex dallas usa 25/2/1989
rec farguson la 12/8/1988
rec hopkins ny 17/9/1988
I want to insert data from name (alex, farguson...etc). I don't want to insert 'rec' keyword.
If one record is already inserted then that record will not be added again.
I would like to do an attachment on my database but I lost the full-text catalogs file. Sql server won't let me attach the database without it. What do I need to do to overcome this issue? Is there a way to tell Sql Server to skip the missing catalogs? If not, how do I generate another full-text catalogs file to replace to lost one?
View 3 Repliesi want to add leading space in dropdown list after binding from DB.
for that i used leftpad method but not working.
code are as below
[Code]....
I have encountered a problem about "order by" sorting in SQL. As some of the items (strings) in a dropdown list contain negative sign on the left, it is surprising for me that the SQL server cannot sort the items in an alphabetical order and as a result I was forced to set the property value (IsSort = False) of the Ajax ListSearch, which slow down the searching speed a lot. Below are examples of two of the string items with a negative sign on the left.
View 6 RepliesI'm new onto LINQ and im working on a asp.net application which uploads a requisition from a preformated text file that is coming from another application.
Th format of the file its like:
HDR 001000 Description
DTL PartNumber CatalogNumber ItemDescription RequestedQty RequiredDate
DTL PartNumber CatalogNumber ItemDescription RequestedQty RequiredDate
DTL PartNumber CatalogNumber ItemDescription RequestedQty RequiredDate
I want to insert information gathered from the text file readed using streamreader with master/detail using LINQ datacontext into the database.
Heres the code of a test page to loop through the file:
[Code]....
I am trying to Export data from SQL server table to a text file using OpenRowSet.
View 3 RepliesMy code css:
[Code]....
I have a button. I have a picture in the background. I'd like to know how to move text to the left and up? My button: [URL]
I've been looking around but didn't find any members that seemed to let you set this. Can it be done?
View 2 RepliesI'm using ckeditor in my CMS for website .. everything working fine ,, but when we write in Arabic and display the page the text always goes left even if we choose right from CKeditor ..
View 3 RepliesSqlDataSource1.SelectCommand = "select * from [xw] where [CustName] Like '" + TextBox2.Text +
"%'"
How Can I make two textboxt1.text and texbox2.text ?
SqlDataSource.selectCommand = "Select* from [xw] Where [Country]= textbox1.text and [CustName] Like '"+Textbox2.text+"%"
I have some text files I need to parse in order to display my data, and what I have now are two text files with lots of redundant data. Instead of this I would like to replace the redundant data with a number referencing the text in another text file.
View 1 RepliesCurrently 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
View 5 RepliesHow 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.
View 1 RepliesHow do I create a schema.ini file from a tab delimited file?
I have this so far:
[myFile.txt]
ColNameHeader=True
Format=TabDelimited
CharacterSet=ANSI
I think I need something like this after my last line from above:
Col1=first TEXT width 150
My text file has 7 columns, the first row is the header row. The data comes from a Micosoft SQL Server Database where the fields are of the following types:
int
nvarchar(MAX)
nvarchar(50)
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
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.