I have a master document which is composed of other document types (some are required and some are not). While the master document's status is "Draft" I need to ignore all not nullable constraints (because the writer may decide to work on one of the children documents that is not required and save as draft).
The closest solution I found for this problem is check constraints but I have not yet to see an example of this in check contraint and I'm not even sure if this is possible. Has anyone implemented a similar solution with check constraints (or any other methods)?
In my project I have to open excel application on click of a button without having ms-excel installed in server and the same case applies to word also. Please suggest me a solutions asap
We are deveopingawebiste in asp.net. There are tempelates of each aspx page made in the form of excel sheet. Upon completion of the online calculation, the user is to be allowed to export the results to excel and save them. There would be obviously no formulae in such sheet
I do not want to install Excel on theserver and instead want to utilize the Excel installed on the user's computer for this purpose as every user's computer is expected to have Excel installed. Is this possible to do? How to do this?
I am not an expert in this. let me know if you would need any more information or clarification.
I need to read a column in excell which has more then 255 characters. The problem is that i can only read 255char max from one column, so i dont have the entire text from excell
I'm reading the file with the following code:
[Code]....
The problem is that the string 'opmerking' is allways limited to 255 characters... i need the other characters as well
I have read the excel in asp.net. I am using OledbDatareader for read the column name.
[Code]....
Now my problem is the "date" field. If Excel sheet having column name "Date" then i got the error. i could not use the Column index because its also not fix. How can i ignore the upper case charactors in column name ?
I have created a GridView whose columns are dynamically created based on my data source. One of the column is a status field which displays Yes?No image based on the status field in database.
But, displaying status for every row in table is generating a lot of visual noise on page. So, instead of this approach I would like to display only yes status if there are more of entries on page and display both [Yes/No] icons if entries are few in number.
I can do this just fine declaratively, using a template column and then using something like this:
[Code]....
I am dynamically creating this grid based on the data, so I'm already added columns with one set of controls. But now I need to figure out how to show multiple images, which expand/contract if the groupImg image control is clicked (i just toggle the ul) ..
I am having an Excel file in that column names are having spaces. to get specific columns from that am using query like this "SELECT DOB,EMPLOYER,[ACCT TYPE#] FROM [Sheet1$]" but i am un able to get the data from that Excel because of spaces in columns.
I am doing Import/Export. While export i want to disable some column in excel sheet, so during upload or import same primary key I can use, instead of user modify such column.
I am binding a gridView to a List<model>. I am able to export it to an excel file but I am not able to remove a specific column. I tried gridView.Columns.RemoveAt(myIndex) but didn't work and threw a null exception and I am assuming this is because the gridView is not binded to a dataTable.
var models = new ModelService().List(startDate, DateTime.Now); var gridView = new GridView { DataSource = models }; gridView.DataBind();
I am using following code to get the columns from excel into datatable. In that in my excel file columns started from C to E means columns A and B is blank(Headers also). When i am reading excel file into datatable that time it's taking columns C to E. I want A and B also.Means when i am reading file that time blank columns are avoiding. I want blank columns should be read.
Excel File Data:
A B C D E
1 2 3
5 6 7
And in Datatable i am getting:
C D E
1 2 3
5 6 7
So i want Columns in Datatable also just like excel.
i have list box, in that list box have some fields(SQL Table fields) in run time i arrange the fields(based on my requirement order) , based on the list i want to change the columns in data table dynamicaly. how i change the columns in the datatable.
I have a database with two columns: Retailers or Traders. A row can have only one of them with values while the other must be 'Null'. Both are nvarchars kinds. What I am trying to do is to show data if a radio button is selected for either Retailer or Trader. So I constructed a SelectCommand statement which is getting column names of either 'Retailers' or 'Traders' as a parameter but the SelectCommand statement still returns all records. What can I do?
I want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value