|
That code you linked to is some of the worse ive seen. Its awful, don't use it.
|
|
|
|
|
Thanks for the head sup.
Any example code or wrapper that you have or might know of that is considered to be good?
Thanks in advance
Kind regards,
The only programmers that are better C# programmers, are those who look like this -> ![Green Alien | [Alien]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/alien.gif) |
 Programm3r
My Blog: ^_^
|
|
|
|
|
Personally I like the Microsoft Enterprise Library for data access, but in all honesty I usually roll out my own wrapper for this purpose.
The important thing to note about the library you linked to is that they are trying (for some odd reason) to circumvent the connection pooling that is already present in ADO.NET, as well as using dynamic sql for data access which is inherantly slow and unsafe.
|
|
|
|
|
|
At least it was formatted pretty! 
|
|
|
|
|
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
|
|
|
|
|
Here's one solution, as you are new, why don't you try learning the basics and then work your way up until you have a better idea about how you could achieve what you need. Then give it another go...
Or is this URGENT, what do you have to do it for?
Life goes very fast. Tomorrow, today is already yesterday.
modified on Thursday, May 21, 2009 5:27 AM
|
|
|
|
|
ammit.it2006 wrote: create a Dashboard using C#.
What exactly do you mean by 'a dashboard'?
ammit.it2006 wrote: How can
I complete the task
By writing code and designing a UI.
ammit.it2006 wrote: I have heard that there is some updates regarding Dashboard in .NET framework 3.5
If you haven't yet written it and sold it to Microsoft then I don't see how there can be updates for it in the 3.5 framework version. I think you're probably refering to WPF for fancy UI stuff. If so then yeah that's in there.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
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,
I'm doing a project that stores present and absent time in the database,
What i need to do now is to calculate the total time the difference between the present and absent time in 'minutes format'.
Can i have an code snippet/example that shows briefly about the time difference calculation? Thanks alot. Looking forward to all experts help.
|
|
|
|
|
How are you storing these 'present' and 'absent' times in your database?
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
DateTime presentTime = blah blah blah get values from database
DateTime absentTime = blah blah blah get values from database
TimeSpan difference = presentTime - absentTime;
Console.WriteLine(difference.TotalMinutes);
Simon
|
|
|
|
|
if BODY tag contains onload=window.print() then a PrintDialog is displayed with the page on browser.
I don't want that PrintDialog to be displayed , how to do in c#
|
|
|
|
|
Try the ASP forum.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi All,
sorry guys i have to rewire my question.
I am using Microsoft.Office.Interop.Excel.Application COM to create a Excel spreadsheet, and write the value (not from any dataset) into that spreadsheet, and then StreamWrite to the disk.
For some reason, the following code is not working.
This is the declaration of ws:
Microsoft.Office.Interop.Excel.Worksheet ws =(Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1];
ws.Cells[1, 1] = "CardNo";
ws.Cells[1, 2] = "PharmacyName";
ws.Cells[1, 3] = "CostPerCard";
sw.Writer(ws.Cells[1, 1]);
sw.Writer(ws.Cells[1, 2]);
sw.Writer(ws.Cells[1, 3]);
I thought this code will write to the spreadsheet like this:
A | B | C
-----------------------------------------------
CardNo | PharmacyName | CostPerCard
but, it wrote to spreasheet like this, all them just in column A:
A
-----------------------------------------------
System.__ComObjectSystem.__ComObjectSystem.__ComObjectH40655
I have been spent quite lots of time on it, but still couldn't work it out.
Thanks heaps
modified on Thursday, May 21, 2009 6:32 AM
|
|
|
|
|
Hi. YOu need to specify a row and Column count. I.e.
int iR, iC;
iR = 4;
iC = 1;
Now, when you write your data you do the following:
objSheet.Cells[iR, iC] = CLIENTSURNAME.Trim();
objSheet.Cells[iR, iC + 1] = CLIENTFORENAMES.Trim();
objSheet.Cells[iR, iC + 2] = TITLE.Trim();
This will move you to the next Column in the current row.
HOpe this helps
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
|
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];
int ColCnt = ds.Tables[tblNo].Columns.Count;
for (int colname=0; colname < ds.Tables[tblNo].Columns.Count; colname++)
{
arrcolumn[colname] = ds.Tables[tblNo].Columns[colname].ColumnName;
}
char start = (char)AscciVal;
char end = (char)(AscciVal + ColCnt-1);
AscciVal = AscciVal + ColCnt+1; // Value set to the next cell of the Excel sheet
int rowCnt = ds.Tables[tblNo].Rows.Count + 1; // Couting no of rows in the current table
oSheet.Cells[1, tblIndex] = "Table" + tblNo.ToString(); // Filling Table Name in the Table
tblIndex = tblIndex - 1;
tblIndex = tblIndex + ColCnt + 2;
oSheet.get_Range(start + "2", end + "2").Value2 = arrcolumn;
oSheet.get_Range(start + "2", end + "2").Font.Bold = true;
string[,] arr1 = new string[rowCnt - 1, ColCnt];
for (int i = 0; i < ds.Tables[tblNo].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables[tblNo].Columns.Count; j++)
{
arr1[i, j] = ds.Tables[tblNo].Rows[i].ItemArray[j].ToString();
}
}
oSheet.get_Range(start + "3", end + rowCnt.ToString()).Value2 = arr1;
}
oXL.Visible = true;
oXL.UserControl = true;
}
catch (Exception theException)
{
String errorMessage;
errorMessage = "Error: ";
errorMessage = String.Concat(errorMessage, theException.Message);
errorMessage = String.Concat(errorMessage, " Line: ");
errorMessage = String.Concat(errorMessage, theException.Source);
MessageBox.Show(errorMessage, "Error");
}
}
private void button2_Click(object sender, EventArgs e)
{
}
private void btnStop_Click(object sender, EventArgs e)
{
this.Close();
}
// Function for Manupulate a variable no of columns
//private void DisplayQuarterlySales(Excel_12 oWS)
//{
// Excel_12._Workbook oWB;
// Excel_12.Series oSeries;
// Excel_12.Range oRecizeRange;
// Excel_12._Chart oChart;
// String sMsg;
// int iNumQtrs;
// // Display How many Quaters to Display Data for.
// for(
}
}
------------------------------------------
namespace WindowsExcelSheet
{
class Bussiness
{
public Bussiness()
{ }
public void fncReturnDataTable(SqlConnection conn, string strQuertString, ref DataSet ds, string strTabName)
{
SqlCommand cmd=null;
SqlDataAdapter sda=null;
try
{
cmd = new SqlCommand();
cmd.CommandText = strQuertString;
cmd.Connection = conn;
cmd.Connection.Open();
sda = new SqlDataAdapter(cmd);
sda.Fill(ds,strTabName);
}
catch (Exception Exp)
{
}
finally
{
cmd.Connection.Close();
cmd.Dispose();
cmd.Dispose(); sda.Dispose();
}
}
}
}
|
|
|
|
|
thanks very much for your help mate
|
|
|
|
|
Hi All
I worked it out. lol
I can't use the StreamWriter to write the value into spreadsheet and save it, i have to use Excel.Workbook.SaveAs() method to save the spreadsheet.
Thanks for your help anyway.
Andie
|
|
|
|
|
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.
|
|
|
|
|
thanks mate, i already worked it out myself, and your way does work.
|
|
|
|
|
Hi there. Hope this is in the right place since I *think* it's language specific.
I am currently creating an interop DirectX library and providing methods and structs on the C# side as needed. I'm translating one of the DirectX tutorial samples to test. Things were going swimmingly with all of the methods returning the correct data and setting relevant pointers etc, until I got to this line of code:
result = d3d10Engine.DXGISwapChain.GetBuffer(0, ref gs, out pBackBuffer);
At this point a SystemAccessViolation exception is thrown with message details "Attempted to read or write protected memory. This is often an indication that other memory is corrupt."
The GetBuffer method is declared as:
[PreserveSig]<br />
int GetBuffer(uint Buffer, ref TestConfigurationManager.GuidStruct refiid, [Out] out IntPtr ppSurface);
where TestConfigurationManager.GuidStruct is defined as:
[StructLayout(LayoutKind.Sequential)]<br />
public struct GuidStruct<br />
{<br />
public uint Data1;<br />
public ushort Data2;<br />
public ushort Data3;<br />
public byte b0;<br />
public byte b1;<br />
public byte b2;<br />
public byte b3;<br />
public byte b4;<br />
public byte b5;<br />
public byte b6;<br />
public byte b7;<br />
}
The DirectX API defines the method signature as:
HRESULT GetBuffer(<br />
UINT Buffer,<br />
REFIID riid,<br />
void **ppSurface<br />
);
However, once the C++ preprocessor has done its bit, it actually looks like this:
long GetBuffer(<br />
uint Buffer,<br />
const GUID & riid,<br />
void **ppSurface<br />
);
where GUID is defined as:
typedef struct _GUID {<br />
unsigned long Data1;<br />
unsigned short Data2;<br />
unsigned short Data3;<br />
unsigned char Data4[ 8 ];<br />
} GUID;
Originally I had Data1 as ulong in the GuidStruct and then realised that ulong and unsigned long in C++ have different sizes and that could be causing the access violation by overrunning the stack allocation during marshaling but I've changed it to uint now and I still got the error. I thought it could perhaps be the void pointer parameter but IntPtr should cover that fine as it's just an integer address surely? So the last theory I have is that it has something to do with the fact that the unmanaged method receives a C++ reference and not a pointer. Trawling through the documentation on MSDN regarding marshaling it seems to me that if you're using the ref argument, the marshal copies a pointer onto the unmanaged stack to the memory space of the guid in the CLR. However, because the unmanaged side expects a reference, it doesn't deference the pointer and when it accesses what it thinks is a reference, an access violation results.
Is this the case and is there any way to deal with it, or would I have to resort to C++/CLI?
Thanks in advance.
|
|
|
|
|
OK. I've done some reading and discovered that C++ reference arguments are in actual fact just the memory addresses of the objects they refer to and the compiler inserts the code to dereference them so bang goes my theory. I'm even more stuck now.
|
|
|
|
|
Scratch all that. It is a completely different issue. Looks like the COM objects are not being created or something. Apologies for wasting anybody's time if I have.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
