Thanks for your prompt reply.

rmr

Hi, I would like to know which is the most latest and good way of writing SQL Joins. Is it by using *=, =* etc. eg: select distinct * from employee,department where employee.DepartmentID *=department.DepartmentID ( or)is it ANSI Standard? Eg: SELECT distinct * FROM employee LEFT OUTER JOIN department ON employee.DepartmentID = department.DepartmentID Please help.

rmr

Of course, yes. This is the javascript. function sample(fieldId, title) { if (title == "") title = "Long Description"; document.Form1.submit(); } Code behind: this.btnSubmit.Attributes.Add("OnClick", "javascript:sample()"); rmr

rmr

select f.financialTrendSeq from #tempAllobligor a left join obligor o on a.obligorSeq = o.obligorSeq left join obligorFinancialTrend ot on o.obligorSeq = ot.obligorSeq right outer join financialTrend f on ot.financialTrendSeq = f.financialTrendSeq where o.quarterDate=ot.quarterdate and ot.quarterdate = '06/30/2006' When I join 3 tables, am not getting the result containing all financialTrend f data. Only, financialTrends in obligorFinancialTrend ot is displayed. Am I wrong? Can somebody please help me?

rmr

Hi, Am assigning a dataset to dataview and trying to sort dataview. But, its not sorting. DataView dv = new DataView(DataSet.Tables[0]); dv.Sort = "ColName"; Please help me as this is urgent.

rmr

Hi, I have to update a dataset. Grid shows in this format and hence Dataset is in this format 10 100 8 70 9 30 when update is done to this, it is such that proc calculates 10 based on 8 and 9 (70+30 =100). the update call is given to sqlhelper class and hence 10 goes I and then 8,9 I need to alter this sort. Am now going to Dataview for this. DataView dv = new DataView(ds.Tables[0]); //apply a sort dv.Sort = "Lastname Desc"; 1.now i need to assign dv back to ds. How do I do it? Can you help me?

rmr

Hi, You can use the TabStrip Web control and create tabs in it. For having different pages in it, you can use Multipage web control and you can have different pages in multipage and each page can be linked with each tab.

rmr

Hi, Am populating data into a tabstrip control dynamically. When more tab gets added to tabstrip, it stretches out. Can somebody tell if there is any property to make it come to the second line

rmr

Hi, Here is the code . And when i debug, the dataset is getting populated. The error 'Object reference not set to an instance of an object' pops up at grid1.DisplayLayout.AutoGenerateColumns = true; line in the code. Am now having the grid in design time..and am giving this also <%@ Register TagPrefix="igtbl" Namespace="Infragistics.WebUI.UltraWebGrid" Assembly="Infragistics.WebUI.UltraWebgrid.v2"> Please help. using Infragistics.WebUI.UltraWebGrid; using System.Data.SqlClient; namespace A { public class sample : System.Web.UI.Page { protected Infragistics.WebUI.UltraWebGrid.UltraWebGrid grid1 ; private void Page_Load(object sender, System.EventArgs e) { if (!Page.IsPostBack) { LoadContent(); } } private void LoadContent() { string strConnectionString = "data source=abc" + "Database=Sample;User Id=a;Password=a;"; SqlConnection cnn; cnn = new SqlConnection(strConnectionString); try { cnn.Open(); } catch (Exception ex) { throw ex; } grid1 = new Infragistics.WebUI.UltraWebGrid.UltraWebGrid(); SqlDataAdapter da; DataSet ds1; string s = "select * from a"; ds1 = new DataSet(); da = new SqlDataAdapter (s,cnn); da.Fill(ds1, "Grid"); grid1.DataSource = ds1; grid1.DisplayLayout.AutoGenerateColumns = true; grid1.DataBind(); } private void grid1_InitializeLayout(object sender,LayoutEventArgs e) { grid1.Width = System.Web.UI.WebControls.Unit.Pixel(400); grid1.Height = System.Web.UI.WebControls.Unit.Pixel(400); grid1.Bands[0].AllowAdd = Infragistics.WebUI.UltraWebGrid.AllowAddNew.No; grid1.Bands[0].AllowDelete = Infragistics.WebUI.UltraWebGrid.AllowDelete.No; grid1.DisplayLayout.AllowSortingDefault = AllowSorting.OnClient; grid1.DisplayLayout.AllowColSizingDefault = Infragistics.WebUI.UltraWebGrid.AllowSizing.Free; grid1.DisplayLayout.RowSizingDefault = Infragistics.WebUI.UltraWebGrid.AllowSizing.Free; grid1.DisplayLayout.RowHeightDefault = System.Web.UI.WebControls.Unit.Pixel(22); grid1.DisplayLayout.HeaderStyleDefault.Height = System.Web.UI.WebControls.Unit.Pixel(20); grid1.Columns.FromKey("reportTitle").HeaderText = "Report Title"; grid1.Columns.FromKey("reportTitle").Width = System.Web.UI.WebControls.Unit.Pixel(550); grid1.Columns.FromKey("reportTitle").AllowUpdate = AllowUpdate.No; grid1.Columns.F

Can anybody help me to bind data to Ultrawebgrid at runtime dynamically? I dont want to create it at design time at all. When I bind ultrawebgrid just like datagrid, it says, object reference not set to an instance of an object. using Infragistics.WebUI.UltraWebGrid; protected Infragistics.WebUI.UltraWebGrid.UltraWebGrid grid1 ; grid1 = new Infragistics.WebUI.UltraWebGrid.UltraWebGrid(); grid1.DataSource = dataset; grid1.DisplayLayout.AutoGenerateColumns = true; grid1.DataBind(); Please help

rmr

Thanks for the reply. But am not still able to get the tabcontrol. Please help Design : <%@ Register TagPrefix="iewc" Namespace="Microsoft.Web.UI.WebControls" Assembly="Microsoft.Web.UI.WebControls" %> Code : private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here Microsoft.Web.UI.WebControls.TabStrip tabControl = new Microsoft.Web.UI.WebControls.TabStrip(); Microsoft.Web.UI.WebControls.Tab tab=new Microsoft.Web.UI.WebControls.Tab(); tab.Text= " ok" ; tab.ID = "1" ; tabControl.Items.Add(tab); Page.Controls.Add(tabControl); } -- modified at 10:20 Wednesday 6th September, 2006

rmr

Can we design dynamic tabstrip control at runtime without creating tabstrip control at design time? Am trying to do it by adding %@ Register TagPrefix="iewc" Namespace="Microsoft.Web.UI.WebControls" Assembly="Microsoft.Web.UI.WebControls" %> at asp.net design page (.aspx) and Microsoft.Web.UI.WebControls.TabStrip tabControl = new Microsoft.Web.UI.WebControls.TabStrip(); at code behind. Microsoft.Web.UI.WebControls.Tab tab=new Microsoft.Web.UI.WebControls.Tab(); tab.Text= " ok" ; tab.ID = "1" ; tabControl.Items.Add(tab); Am not getting anything on page. Can somebody help???

rmr

How do I create a multipage control dynamically? Microsoft.Web.UI.WebControls.TabStrip tabControl = new Microsoft.Web.UI.WebControls.TabStrip(); tabControl.ID = "tabcontrol1"; Microsoft.Web.UI.WebControls.MultiPage multipage1 = new Microsoft.Web.UI.WebControls.MultiPage(); multipage1.ID = "multipage1"; tabControl.TargetID = multipage1.ID ; Microsoft.Web.UI.WebControls.Tab tab=new Microsoft.Web.UI.WebControls.Tab(); tabControl.Items.Add(tab); lbl1 = new Label(); pageview1.Controls.Add(lbl1); multipage1.Controls.Add(pageview1); There is nothing coming out for this code. But, am able to create the multipage and tabstrip control at design time and get it working. But, I need them to be generated dynamically to call from another control. Please help

rmr

Thanks. Actually, am trying to use the Tabstrip control with the multipage control. Am able to bind data to a Tabstrip dynamically when tabstrip and multipage are created at design time. But, am not able to create multipage at run time. Microsoft.Web.UI.WebControls.MultiPage multipage1 = new Microsoft.Web.UI.WebControls.MultiPage(); Please help me on this.

rmr

Can somebody give me an idea of how to build multipage dynamically without having it created at design time at all??

rmr

Hi, Am trying to add tabstrip control to my page. I have put the microsoft.web.ui.dll into the appli/bin/ folder. Then, webctrl_client folder has been added to the wwwroot/appli/ folder. I could create the tabstrip in design time. But, when I run it, data is displayed as lines. The same is true even if I put a treeview. After seeing some forums on the internet, I have put the below lines in web.config.

Still, its not working. I referred to the ViewSource and it has "MultiPageTree/webctrl_client/1_0/tabstrip.htc" referred. Am unable to find any solution as I have spent couple of days on this. Am using 2003 version of .net (framework 1.1) Please help Thanks.

rmr

Am trying to dynamically build a tab, multipage and pageview protected Microsoft.Web.UI.WebControls.TabStrip tc; protected Microsoft.Web.UI.WebControls.MultiPage mp; protected System.Web.UI.WebControls.Label txt; Microsoft.Web.UI.WebControls.Tab tab=new Microsoft.Web.UI.WebControls.Tab(); Microsoft.Web.UI.WebControls.PageView pv= new Microsoft.Web.UI.WebControls.PageView(); //Am building a control here and adding it to pv System.Web.UI.WebControls.TextBox txt= new TextBox(); txt.Text = "Microsoft"; pv.Controls.Add(txt); pv.ID = id.ToString(); tab.TargetID = pv.ID; Error: TargetID does not point to a valid PageView the tab.TargetID has to be set to pv.(something). can somebody help me on this? rmr

rmr

Hello, Its not that I dont know the basics of posting on forums, I needed to change the subject so that someone can help me out, I posted it again. Thanks for your advice and if you had helped me out, I would have told you double thanks.

rmr

Am trying to dynamically build a tab, multipage and pageview protected Microsoft.Web.UI.WebControls.TabStrip tc; protected Microsoft.Web.UI.WebControls.MultiPage mp; protected System.Web.UI.WebControls.Label txt; Microsoft.Web.UI.WebControls.Tab tab=new Microsoft.Web.UI.WebControls.Tab(); Microsoft.Web.UI.WebControls.PageView pv= new Microsoft.Web.UI.WebControls.PageView(); //Am building a control here and adding it to pv System.Web.UI.WebControls.TextBox txt= new TextBox(); txt.Text = "Microsoft"; pv.Controls.Add(txt); pv.ID = id.ToString(); tab.TargetID = pv.ID; Error: TargetID does not point to a valid PageView the tab.TargetID has to be set to pv.(something). can somebody help me on this? rmr

rmr