If i declare a variable in the function , example i declare dim s as string now in between the funciton i click press the control + space key , it gives two variable names in intellesence , (a) s (b) s:- What's the meaning of s:-

Sorry for interrupting in ur thread , actually my question is little similar to ur’s After finding that the result is nothing /or not nothing, I have to insert the ---Select--- record in the combobox , at first place.how can it append to combobox.

Hi , I am presently doing the following thing using sql server 2005. I have the populate the combo box with a table which has two fields id and name even if there exist no record in database for that table , it shall return me the clone of that table. and after retrieving the records and put into the datatable , i add one more row at first place (---Select---) in the datatable , and finally bind it with the combo box control. I want to do the samething in LINQ , I am able to populate it with combo box using Linq , but i am facing two problems (a) If there exist no record , in this case how should i place the (---Select---) row at first place , this is the mandatory record. (b) If there exist records , even then i am unable to attach the (---Select--) row in the combo box at first place. Regards

Can u give me the link for LINQ Debugger?

wrapped property for merged cell is set. still not showing the hidden part.

I am writing a program in that populates an Excel spreadsheet. I know that it is not possible to have autoheight or autofit on merged cells. I need the height of the row to expand to fit an undetermined amount of text. I wonder if anyone has code to get around this problem. I need to find a way to get around this problem and fast. Anyone found a way around it?

modified on Wednesday, October 15, 2008 5:00 AM

i want in 2003

I am writing a program in VB.NET that populates an Excel spreadsheet. I know that it is not possible to have autoheight or autofit on merged cells. I need the height of the row to expand to fit an undetermined amount of text. I wonder if anyone has code to get around this problem. I need to find a way to get around this problem and fast. Anyone found a way around it?

I have a table , table name is table1 it has following fields. Column1 , column2 , column3 , column4 Now I write the following query

Dim query = from p in baseclass.gettable(of table1) _
Select p.column1 , p.column2

Now this query is the anonymous type. Now I want to insert one more row at position 1 at runtime.

That’s row’s display string is “----select----”
And it’s value member is “-1”

How should i add this row in Query variable? I want to check if there is not record , then I gives nothing, In case of nothing , how should I add the record.

Hi , Please go through this code....

BaseClassDataContext = New BaseClassDataContext(BLLmdlCommon.strConfiguration)

        'Left outer join for extracting the project table records

        Dim query = From p In BaseClassDataContext.GetTable(Of CP\_Project)() \_
        Group Join crt In BaseClassDataContext.GetTable(Of CP\_CLM\_ClientRating)() \_
        On p.RatingID Equals crt.RatingID Into ratingname = Group From c In ratingname.DefaultIfEmpty() \_
        Group Join cname In BaseClassDataContext.GetTable(Of CP\_CLM\_Client)() \_
        On cname.ClientID Equals p.ClientID Into clientname = Group From c1 In clientname.DefaultIfEmpty() \_
        Group Join pstatus In BaseClassDataContext.GetTable(Of CP\_PRJ\_ProjectStatus)() \_
        On pstatus.ProjectStatusID Equals p.ProjectStatusID Into projectstatus = Group From c2 In projectstatus.DefaultIfEmpty() \_
        Group Join pjtype In BaseClassDataContext.GetTable(Of CP\_PRJ\_ProductType)() \_
         On pjtype.ProductTypeID Equals p.ProductTypeID Into pj = Group From projecttype In pj.DefaultIfEmpty() \_
        Select c.Rating, p.ProjectName, c1.ClientName, p.StartDate, p.DeliveryDate, c2.ProjectStatus, \_
        p.ProjectID, c.RatingColor, projecttype.ProductType
        'grdTasks.DataSource = query

If i bind the grid now then i don't get the order of the column as i mentioned above Now instead of binding the grid now , if i create it's XML and convert into dataset . Then the order is correct.

xElement = New XElement("Root", From p In query Select New XElement("Leaf", _
New XElement("Rating", p.Rating), _
New XElement("ProjectName", p.ProjectName), _
New XElement("ClientName", p.ClientName), _
New XElement("StartDate", p.StartDate), _
New XElement("DeliveryDate", p.DeliveryDate), _
New XElement("ProjectStatus", p.ProjectStatus), _
New XElement("ProjectID", p.ProjectID), _
New XElement("RatingColor", p.RatingColor), _
New XElement("RatingColor", p.ProductType)))
ds = New DataSet
ds.ReadXml(New System.IO.StringReader(xElement.ToString()))

i have a function with two parameters , I want to start the thread and want to give the address of that function in the thread.Now my question is how should i pass that function in thread. According to my understanding , i should create a class , there i would create two variables of same type that of parameter list of function , and a function which contains that fucntion implementation .and now create an instance of the class and pass that address in the thread. This seems to be a very lengthy process. Please help. Thanks

Hi Howards, How r u? can u provide a link or any chunk of code? Thanks

Hi, how should I write the following query in LINQ ?

@TableName nvarchar(128)

DECLARE @DB_NAME NVARCHAR(128)
SET @DB_NAME = DB_NAME()

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = @DB_NAME
AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = @TableName
ORDER BY ORDINAL_POSITION

Regards

i have a method that contains two parameters . Now my question is , how should i give the address of that method to thread , as the thrad don't allow two parameters ?

sir , i know that , but instead of making fun of the issue , May we sort out it's solution. Regards

Hi, i am using infragistics ultragrid to display the record with the help of following query

Dim query = From p In BaseClassDataContext.GetTable(Of CP_Project)() _
Group Join crt In BaseClassDataContext.GetTable(Of CP_CLM_ClientRating)() _
On p.RatingID Equals crt.RatingID Into ratingname = Group From c In ratingname.DefaultIfEmpty() _
Group Join cname In BaseClassDataContext.GetTable(Of CP_CLM_Client)() _
On cname.ClientID Equals p.ClientID Into clientname = Group From c1 In clientname.DefaultIfEmpty() _
Group Join pstatus In BaseClassDataContext.GetTable(Of CP_PRJ_ProjectStatus)() _
On pstatus.ProjectStatusID Equals p.ProjectStatusID Into projectstatus = Group From c2 In projectstatus.DefaultIfEmpty() _
Group Join pjtype In BaseClassDataContext.GetTable(Of CP_PRJ_ProductType)() _
On pjtype.ProductTypeID Equals p.ProductTypeID Into pj = Group From projecttype In pj.DefaultIfEmpty() _
Select c.Rating, p.ProjectName, c1.ClientName, p.StartDate, p.DeliveryDate, c2.ProjectStatus, _
p.ProjectID, c.RatingColor, projecttype.ProductType

in vb.net window application. after binding the colown order was totally different clientname , deliverydate ,producttype , projectid , projectname , projectstatus , projectrating , colorrating , startdate this is actually not required. can u help me ?

Hi, i am using the infragistics textbox , i want to make the multiline property true.How should i do this ?

i am using window application

I was running the select query to show eight columns in the grid. say dim query = from p in baseclass.Gettable(of tablename) _ select p.column1 , p.column12 , p.column3 , p.column4 , _ p.column5 , p.column6 , p.column7 , p.column8 when i bind it with the grid , it does not give the order of columns in grid , in which i placed them in the query. it shows in grid like p.column12 , p.column3 , p.column1 , p.column4 , p.column6 , p.column5 , p.column7 , p.column8

hi, i was using the following query to bing it with the data grid.

dim baseclass as baseclassdatacontext = nothing
baseclass=new baseclassdatacontext

dim query = from p in baseclass.gettable(of table1)() _
select p

now the problem is , if i want to use aliases i write in following way

dim query = from p in baseclass.gettable(of table1)() _
select name = p.name

if i have to use the alias by seperating the word like

dim query = from p in baseclass.gettable(of table1)() _
select first name = p.name

then i am getting error due to alias , please help , i want a column name of two words