Hi to all I am trying to add windows assembly to the GAC using the following command in the command prompt. C:\Program Files\Microsoft Visual Studio 8\VC>gacutil /i C:\WINDOWS\system32\odb c32.dll But it is not being install and I am getting the following error. "Failure adding assembly to the cache: The module was expected to contain an assembly manifest." I am not getting the reference of the assembly neither in the .NET Assembly nor in the COM objects. Can anyone tell me how can I install this assembly in the GAC. Thanks in advance Amit

Hi to all I was interested in listing the sql servers available. I found some code " using System.Runtime.InteropServices; " Code is used like that for using windows dll. For that we need to define the method that we want to use as follows : [DllImport("odbc32.dll")] private static extern short SQLAllocHandle( short hType, IntPtr inputHandle, out IntPtr outputHandle); So I want to know that is there any tool to find the declaration of the functions available in the DLL. Please lemme know how can I find the tool to do the same ? If I use IDSAM then it gives the same for .NET libraries only not for windows library. Thanks in Avdvance

I think no need to write sw.Writer(ws.Cells[1, 1]); sw.Writer(ws.Cells[1, 2]); sw.Writer(ws.Cells[1, 3]); Only ws.Cells[1, 1] = "CardNo"; ws.Cells[1, 2] = "PharmacyName"; ws.Cells[1, 3] = "CostPerCard"; will give u the desired result. I tried it's working. Try in this way.

DashBorad gives the view of present position of the company , using Pie charts and table charts etc. http://www.microsoft.com/downloads/details.aspx?FamilyId=130F7986-BF49-4FE5-9CA8-910AE6EA442C&displaylang=en I have recently found above link to download " Microsoft Chart Controls for Microsoft .NET Framework 3.5 " Actually I was talking about that only. Wheather it will gimme the option to desing the Charts for the Dashbord and use them to show the present situation of the comppany.

Hi AndieDu I did not read ur requirement fully. But i designed the similar code and I got the data from the Database and stored the values in the excel tablewise. I think It may help you. using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient ; using System.Text; using System.Windows.Forms; using System.Reflection; using Excel_12 = Microsoft.Office.Interop.Excel; namespace WindowsExcelSheet { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { Excel_12.Application oXL; Excel_12._Workbook oWB; Excel_12._Worksheet oSheet; try { // Start Excel And get Application Object. oXL = new Excel_12.Application(); oXL.Visible = true; // Get a new Workbook oWB = (Excel_12._Workbook)(oXL.Workbooks.Add(Missing.Value)); oSheet = (Excel_12._Worksheet)oWB.ActiveSheet; // Add Table Headers going Cell by Cell //oSheet.Cells[1, 1] = "SaleID"; //oSheet.Cells[1, 2] = "Product"; //oSheet.Cells[1, 3] = "SalePrice"; //Format A1:C1 as Bold, Vertical Alingment = Center. oSheet.get_Range("A1", "C1").VerticalAlignment = Excel_12.XlVAlign.xlVAlignCenter; SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Server=192.168.10.113;Database=AmitTestData;User ID=sa;Password=sa;Trusted_Connection=False;"; DataSet ds=new DataSet(); Bussiness objBussiness = new Bussiness(); objBussiness.fncReturnDataTable(conn, "select * from BigScreenProducts", ref ds,"Table0"); objBussiness.fncReturnDataTable(conn, "select * from Employee", ref ds, "Table1"); // sqladp1.Fill(ds,"Table2"); int tblIndex = 1; int AscciVal = 65; // Ascci Value of Capital 'A' // Table Count for (int tblNo = 0; tblNo < ds.Tables.Count; tblNo++) { // Creating Headings in the Excel string[] arrcolumn = new string[ds.Tables[tblNo].Columns.Count];

Hi to all My need is to create a Dashboard using C#. Currently I am using Framework 2.0. I want to know that is there any class of library by using that I could make my Dashbord quickly. I am also new to .NET and in the beginning state. So Please gimme an idea How can I complete the task with .NET using some tools present in .NET. I have heard that there is some updates regarding Dashboard in .NET framework 3.5 service pack 1. Is it true. Will it solve my problem ? I don't want to use some readymade tools from some other providers. Please advice me as soon as possible. Thanks in Advance Amit