|
Well, the point is that I couldn't join two tables from different data sources. One table from SQL Server database and another one which is represented as a file in AS/400 machine. I'm sure this will make you wonder why I need such data to join from these sources. This is not designed by me I only have to make this join and sum the Amount values by Month. But I couldn't. I only succeeded to make a connection to each of the sources and to select the data without the join (just for test). The file in AS/400 contains the Amount values and some other columns. The months i take from SQL Server table. I prefer using SQL in separate logic layer too but in this case the join doesn't work. Maybe I'm wrong to not to keep trying it with the SQL. I thought it might be easier to do it in C# class.
|
|
|
|
|
OK. In this case you have a system design which obstructs proper processing. That's often a political matter. Sometimes it's not a matter where proper design wins out -- the "IT" team may jealously guard the data and its processing... whatever.
In this case, extract a bona fide table from the data and process it how you ought to.
Don't let people who don't know what they're doing stand in the way of getting the job done right. Stomp toes. Lecture. Whatever. Embarrass them with how they are obstructing proper processing. No good technical person stands in the way of doing a job properly. If they worked for me, they'd already be outed.
|
|
|
|
|
Incidentally (again, if you don't understand so yet), my recommendation to go ahead and iterate the cells was sarcastic. You probably didn't even find documentation for that, did you? (I haven't looked, but I know any such controls I've worked with -- in many languages -- either have no such documentation, or the process is so obscure it would be an extremely advanced skill based for instance from careful, meticulous study of code such as the VCL which comes with Delphi/C++ Builder.)
My idea was that you are vacillating. You first wanted SQL. Then you did not. Everyone has to study their options carefully. It is by studying them that you should have opted not to want to derive your data any longer by iterating your control. That idea is plain silly. The data already exists in a form by which it can readily be iterated or processed by SQL. *That* is why documentation for iterating the control [probably] does not exist [in any plain, accessible form].
When it comes down to it, this just a plain/usual problem where a first issue is to identify what to process. You want to process the data. It exists (even in the informal table/AS/400 file) in a form which is more conducive to processing. Read the AS/400 file to populate a formal SQL table with the same tools you have to use for the other table, and everything is compatible, and easily processed.
Simple.
|
|
|
|
|
How to define optional parameter in C# fuction or can define single optional parameter????
please help me
Thanks in Advance..
|
|
|
|
|
C# does not support Optional parameters..
Need to pass NULL instead.
"If our Mind can, the Program can !!"
|
|
|
|
|
Do you mean how can you add a variable number of parameters?
public void DoSomething(params object[] parameters)
{
foreach (object parameter in parameters)
{
...
}
}
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Create an overload. As long as the function signatures differ in the parameter list (or return type, but not advisable), you can have two functions with the same name.
You end up with something like this:
function Add(object item)
{
...
}
function Add(object item, string name)
{
...
}
-----------------------------
In just two days, tomorrow will be yesterday.
|
|
|
|
|
Hi there,
Can anyone please tell me why I cant disconnect or even get ANY exception out of this code..
private void btnDisconnect_Click(object sender, EventArgs e)
{
try
{
IntPtr m_ConnectedRasHandle;
RASCONN lprasConn = new RASCONN();
m_ConnectedRasHandle = lprasConn.hrasconn;
RAS.RasHangUp(m_ConnectedRasHandle);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
Thanx a bunch guyz
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
It's a strong bet that after creating a new RASCONN object, the hrasconn field is probably zero. To hang up a dial-up connection, you'll need to pass the handle you got back from RasDial or from RasEnumConnections .
You don't show the code, but I'd guess that RAS.RasHangUp is an extern function called through P/Invoke. As such, it won't throw an exception - instead, it will be returning an error code.
Style: in most conventions, the m_ prefix should be reserved for member variables and should never be used for a local variable. In the Windows C API, lp indicates a (long) pointer to an object. I would only use this in C# for actual pointer variables, unless in a P/Invoke declaration where I tend to match the original declaration's parameter names.
|
|
|
|
|
Thanks a bunch Mike, but sorry .. I'm kinda new to this RAS thing that I will be very glad if you can show me in brief how can you do it.. I've imported a class called "RAS.cs" from this project and I used this code in a button I just created..
private void btnDisconnect_Click(object sender, EventArgs e)
{
try
{
RASCONN lprasConn = new RASCONN();
lprasConn.hrasconn = IntPtr.Zero;
IntPtr m_ConnectedRasHandle;
m_ConnectedRasHandle = lprasConn.hrasconn;
RasStats stats = new RasStats();
RAS.RasGetConnectionStatistics(lprasConn.hrasconn, stats);
int Minutes = ((stats.dwConnectDuration) / 60);
MessageBox.Show(Minutes.ToString());
RAS.RasHangUp(m_ConnectedRasHandle);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
Thanx again for your help Mike
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
Hi All
I am displaying a listview on or in a panel and I would like to save the listview/panel as a jpeg. I have already done this but my major problem is that it is saving the panel rather than what it is in it.
What is being saved is what is on the screen, scrollbars included.
How do I get it to save that which is not visible on the screen.
James C Mullaney(N Generation Steam)
|
|
|
|
|
Hi,
Do you want the contents of the ListView be saved in a Text File or in some form of image ? If it is the text file, then just iterate through the items and create a string. Use this string to create a new text file.
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
Hi coolestCoder
Thanks for the reply, I want to save the ListView as a JPEG but as a text file would be good as well.
My problem is that I am saving the panel rather than the ListView that it is displaying.
James
|
|
|
|
|
hi
i wanto create an aciveX in C# .
i search in internet but can not find anything .
can you guide me ?
|
|
|
|
|
Right click on Toolbox > Choose items > help yourself
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
|
hi, there is no concept of ActiveX in C#. the workaround for this -- Try this it will work (Register and Unregister)
namespace test{
[GuidAttribute("register with some guid ")]
[ProgId("Any string")]
[ClassInterface(ClassInterfaceType.AutoDual)]
public class ActiveXControl : System.Windows.Forms.UserControl
{
// ur code + constructor + all other stuff
[ComRegisterFunction()]
public static void RegisterClass ( string key )
{
StringBuilder sb = new StringBuilder ( key ) ;
sb.Replace(@"HKEY_CLASSES_ROOT\","") ;
RegistryKey k = Registry.ClassesRoot.OpenSubKey(sb.ToString(),true);
RegistryKey ctrl = k.CreateSubKey ( "Control" ) ;
ctrl.Close ( ) ;
RegistryKey inprocServer32 = k.OpenSubKey ( "InprocServer32" , true ) ;
inprocServer32.SetValue ( "CodeBase" , Assembly.GetExecutingAssembly().CodeBase ) ;
inprocServer32.Close ( ) ;
k.Close ( ) ;
}
[ComUnregisterFunction()]
public static void UnregisterClass ( string key )
{
StringBuilder sb = new StringBuilder ( key ) ;
sb.Replace(@"HKEY_CLASSES_ROOT\","") ;
RegistryKey k = Registry.ClassesRoot.OpenSubKey(sb.ToString(),true);
k.DeleteSubKey ( "Control" , false ) ;
RegistryKey inprocServer32 = k.OpenSubKey ( "InprocServer32" , true ) ;
k.DeleteSubKey ( "CodeBase" , false ) ;
k.Close ( ) ;
}
}
}
|
|
|
|
|
tanks
i am going to test it.
|
|
|
|
|
Hi, I want to create a custom textbox control in ASP.Net using C#, which extends the properties of the normal textbox control and it only allows numeric, alphabetic and alphanumeric characters depending upon the users choice. It should have a built-in client side validation for the same. Also, it should have a property called required, which when set to true, the text box also shows the property of the required field validator.
-----Have A Nice Day-----
|
|
|
|
|
assiduous wrote: Hi, I want to create a custom textbox control in ASP.Net using C#, which extends the properties of the normal textbox control and it only allows numeric, alphabetic and alphanumeric characters depending upon the users choice. It should have a built-in client side validation for the same. Also, it should have a property called required, which when set to true, the text box also shows the property of the required field validator.
-----Have A Nice Day-----
Well good for you. Let us know how you get on with that.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Combine all these and put it to one user control ? Now what problem u r facing ?
|
|
|
|
|
HI CODEPROJECT TEAM.
SOMEONE KNOW HOW INSERT A AUTONUMBER COLUMN IN EXCEL USING OLEDB?.
CONNECTION STRING EXAMPLE:
string cst;
cst="Provider=Microsoft.Jet.OLEDB.4.0;" +<br />
"Data Source=c:\\file.xls;" +<br />
"Extended Properties=\"Excel 8.0;IMEX=1;MaxScanRows=0;" +<br />
"HDR=YES\"";<br />
OleDbConnection conn = new OleDbConnection(cst);<br />
conn.Open();<br />
I NEED DO SOMETHING LIKE:
string SQL;<br />
SQL="ALTER TABLE [sheet1$] ADD [row_id] NUMBER NOT NULL AUTONUMBER";<br />
OleDbCommand cmd = new OleDbCommand(SQL, conn);<br />
cmd.ExecuteNonQuery();
THANKS IN ADVANCED.
SINCERELY.
ANTHONY ACUÑA
PREFERED PHRASE:
SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
|
|
|
|
|
Sorry, I cant read CAPS.
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
AFAIK, Excel doesn't support autonumber columns. You'll have to use a database that does, like Access or SQL Server.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
You may have to *fake* an autonumbered column with a formula incrementing the value of the preceding cell.
imho, a person should stay away from anything complex in Excel. The next version may well break all your work -- and impose costs neither you or your clients are prepared to swallow. The more glorious your work, the more costly the *probable* catastrophe.
|
|
|
|