I tried to query an excel file which contains a lot of customers' information but my problem is most of those don't have a specific column names. E.g. it's in the following format. (Excel File)
A B C Info1 blur blur Info2 blur blur Info3 blur blur
So, when I query using SqlDbDataAdapter, in my DataTable, info1 blur blur becomes column header. e.g. it's in the following format. (DataTable)
Info1 blur blur Info2 blur blur Info3 blur blur
I been working on it so that it actually goes down one row and Change the column name in the DataTable into some appropiate name. Something like the following format.
Is there any way that I could work around it rather than actually going back to change the excel files ? Because I have like 1,000 excel files in that kinda format and seriously giving me headache now.
What I have is a datatable being constructed from Sharepoint API. We dont need to worry about the sharepoint api.The code where it fills the data is as follows
Datatable dt = new datatable(); Sharepoint.fill(dt);
Write what I want is as the dt is being filled is to create another column called full path which has a formula col1+col2I dont want to do a for next loop after the dt is filled . very slow !
I'm using a DataSet to fill my gridview. The dataset contains several columns, like: direction - fromNumber - toNumberThe column direction can contain the values "incoming" or "outgoing". In my gridview, I would like to show only 2 columns, direction and from/to. If direction = "incoming", the values from fromNumber has to be inserted in "from/to". If direction = "outgoing", the values from toNumber has to be inserted in "from/to".I know I can use a TemplateField to show different text values in a column...But I have no idea how to do this when I want to show the values from a column...
How can i select all columns of table but to distinct by one column? i am tryin to figure it out without success, i know how to make distinct (select distinct column from table, but i need all the values from the table and to distinct by Delcompany.
I want to select the list of messagetext from the messages table where the message text contains any of the Carriage Return Characters?? (Eg: /r/n) what are the other Carriage Returns characters and how can i filter those from the message text?
Using a ListBox, where multiple items can be selected. Using StringSplit SQL function the string passed from Listbox is separated where the delimeter is comma ( , ).ListBox is in search form where user enters search criteria using other controls and the ListBox. All works good by simply using below SQL statement in Stored procedure that carries search.
[Code]....
Question:- Now one of List Item is None , when None is selected or None is selected with other ListItems from ListBox it is required to retrieve all records where COLUMN IS NULL.Example: When the Male, Female and None is selected from ListBox, SQL statement in Stored procedure will be
[Code]....
Like to know how this can be handled? It is required to retrive NULL values when None is selected in ListBox as well as in combination of other ListItems(Male and Female) i.e., Male, Female, Null when user selects multiple items from ListBox.
I have a gridview which has a column of auto generated select buttons, where a user can select a row.However, I would like to add a column header to my auto generated select buttons in order to make the gridview look complete, but I am unable to see how I can do this. Does anyone know how I can add a header text to an auto generated select button?
I tried to use a DropDown-Control (WebDropdown from Infragistics) for the following function: Let the user enter any text or if he wishes choosing by a context menu two different "Already exist entries" in the DropDown-List from where he can choose a value. The behaviour should be this for the DropDown: Right-clicking on the DropDown-Control, filling the DropDownList in the server depending on the choosen context menu item, opening the DropDownList in the client.
The way I tried to solve:
Open (by javascript) a context menu by right clicking on the control
[Code]....
What's the problem? The problem is, that the above javascript function does find the WebDropDown1 control only if it is called client side (e.g. with a OnClientClick button event), calling it from server side (as in the ContextMenu_ItemClick subroutine) it does not find the WebDropDown1 control. The error is shown (translated into english): run time error: object expected.
Maybe a completly different solution is necessary as I transfer a windows forms program into a web form ajax style program. I could use a textbox with dropdownextender for example. But the problem seems to be always the same: uncoupling the dropdown function, which is a client side one, by first filling the dropdownlist on server side, and then invoking the dropdown event makes the problem.
A site that utilizes Windows Authentication.It accesses the LOGON_USER variable to pull the domain and user.It works fine in the development environment.It works fine on one of my servers.We are in the process of setting up a new server for this application to be hosted on.When I setup the new server,the LOGON_USER is always empty for remote computers.Windows Auth is turned on.I have tried it with Anonymous Access on (how the current server is setup) and also off.If I remote on to the server and run the application locally,LOGON_USER is filled.When I access the site via IE from a remote machine,it prompts three times and then fails.Even if I key in credentials in the Windows prompt.nothing
I am quite new to LINQ, and I am stuck with this probably basic problem, but haven't been able to find a solution, so I thought I could ask here.
So, I have this repository where I put my functions for data accessing, and now I need to write a function to get all the applicants that have applied for this particular advertisement, and their values too. Now, the values are stored in a separate M:N table, where every row consists of the applicantID,advertisementID and value. I just wanna append the value to every applicant that I show, so that it would look like a Ranking List.
However, I do not seem to know how to select just the name column from the Applicant table, and just the Value column from the ApplicantValue table.
And there's this Iqueryable interface that further confuses me...
Here's my function to get the Applicants only:
[Code]....
Now, if I try to add to the definition of the type two columns, it says that it only messes with types, i.e. one type should be passed. So I figured I would do a ViewModel and then pass it, like this
[Code]....
and then in the function I have no idea how to pass the values:
I 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?
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?