|
|
Hello, I need to design a weekly planner report the report needs to look something like this-->
========================================================================
Monday Tuesday Wednesday n so forth
========================================================================
Date: 11/01/06 12/01/06
Location: ABC XyZ
Time: 10:00 AM 11:00
--------------------------------------------------------------------------
Sr. Dr. SPT Dr. SPT Dr. SPT
Can anyone come with some solution? It would be nice to manipulate the data in the sql server however its not compulsory. By the way its a windows application on C# and sql server at the backend.
I couldnt format this msg properly but basically the Date location time will fall under each day, having a Drs name, his/her speciality and the level for each day. If someone has any solution i would get the sample report scanned and send it to their email address. Also, I am toying with the idea to have an excel sheet and automate it via C# but it does not appeal me though and it would be nice to stick to CR.
Best regards,
Krunchu
|
|
|
|
|
Hi,
I have been looking around and working with the Express editions of C# and SQl Server 2005 for a few days now. Currently I am unable to create a Procedure using the new CLR. From my understanding you must create a "special" stored procedure project that you later use in SQL Server 2005 by creating an assembly and linking to it...
My problem is the Express version of C# does not include the template files for this. As a matter of fact there is no database project folder at all.
I was wondering if there is somewhere I can download the needed templates or if I have to upgrade my version of C#.
Thank you for your time,
Will
I hate users. Not all of them, just the ones who talk.CP member: Al Einstien
-- modified at 14:02 Thursday 12th January, 2006
Cant spell...
|
|
|
|
|
Also, did you enable CLR Integration[^]? For security reasons it is turned off by default.
You might also get some good information here: CLR Stored Procedures[^]
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
thanks for reply's
Yes i have enabled the CLR in sql server 2005.
so in short I dont need a template? I can just use the code on msdn2 and it should work?
Will
I hate users. Not all of them, just the ones who talk.CP member: Al Einstien
|
|
|
|
|
Hello all!
I am new to c#.net 2.0. I am using a datagridview and would like to update the current(selected) row in it. Can anyone provide some help. I read about datatable, datarow. Yet, I found no property that returns the index that points to the current row.
Thanks All,
Tan the man
Tan the man
|
|
|
|
|
|
Hi,
How to delete rows from a DataTable completely from the memory.
Regards,
Subbu
|
|
|
|
|
Do you want to remove them from the table, or the data source ? If just the table, just delete them.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi,
I am writing an application containing a treeview.
The requirements state that the treeview should have checkboxes to help multi-selection. However, the checkboxes on the treeview do not look nice at all  . The checkbox outline is thick and looks rather silly. How can I change this?  Is it possible to make the outline thinner?
Any help is much appreciated
Regards
Peter
|
|
|
|
|
First, there are some free controls on Codeproject that do this already. Check them out if you haven't yet.
Secondly, you can try drawing the checkbox using either the system drawing (which is unthemed):
System.Windows.Forms.ControlPaint.DrawCheckBox
Or if you're using .NET 2.0, you can try drawing the system themed checkbox which looks a lot nicer:
using System.Windows.Forms.VisualStyles;
...
if(VisualStyleInformation.IsSupportedByOS == true)
{
VisualStyleRenderer renderer = new VisualStyleRenderer(VisualStyleElement.Button.CheckBox.CheckedNormal);
renderer.DrawBackground(myGraphicsSurface, rectangleToDrawIn);
}
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Little House on the Flickr
Judah Himango
|
|
|
|
|
Thanks for your reply
I'm using .NET 1.1 so will try the System.Windows.Forms.ControlPaint.DrawCheckBox approach. I'll also have a look for the controls you talked about too.
|
|
|
|
|
I have two simple dlls and one main application.
first dll is:
namespace baseDll{
public class baseClass{}
}
the second dll is:
using baseDll;
namespace childClass:baseClass{
public class childClass{}
}
//with a correct reference to base dll
and the main application is:
public static void Main(string[] args){
Assembly a1 = Assembly.LoadFile(@"C:\childDll.dll");
Assembly a2 = Assembly.LoadFile(@"C:\baseDll.dll");
System.Type t2 = a2.GetType("baseDll.baseClass");
System.Type t1 = a1.GetType("childDll.childClass");
if (t2 != null){
Console.WriteLine(t2.FullName);
}
if (t1 != null){
Console.WriteLine(t1.FullName);
}
}
It prints only t2, while t1 has an undifined value..
What's wrong, and what can be a workaround to this?
-- modified at 14:45 Thursday 12th January, 2006
Now I tried to run it with mono, and it works ok..
Moreover when I use Assembly.LoadFrom instead of Assembly.LoadFile it works fine...
|
|
|
|
|
Have a look at the LoadFile documentation (I only have a german link at hand but you should easily find it on MSDN). It says something like that i should only be used to load and check assemblies with same identities on different paths and that i doesn't resolve references like LoadFrom does.
The workaround is clear: Use LoadFrom
|
|
|
|
|
thanx!
Can you please elaborate though on what is "same identities"?
If I use Assembly.LoadFrom it doesn't have the same identity? (what is this identity of an assembly...)
|
|
|
|
|
Have a look here[^].
I'm not really an expert on this topic, but I think if you just copy one assembly to another path than those two assemblies have the same identity.
|
|
|
|
|
Hi,
I want to develop a web service, that has to access a local file. Can I use relative path, like ../data/filename.dat or Application.Startup + "//data//filename.dat", to navigate to the file?
Thanks a lot!
Alan Shen
MCAD for .NET Version
^~^~^~^~^~^~^~^~^~^~^
Great idea is the beginging of success!
|
|
|
|
|
Use HttpServerUtility.MapPath() method.
From the web service, you have the access to the "Server" object. You can simply write Server.MapPath() and pass in a relative path to get the full physical path back.
Example: Server.MapPath( "bin/YourWebService.DLL" ) returns the full physical path of YourWebService.DLL.
For more information, see the MSDN help on HttpServerUtility.MapPath().
Koushik Biswas
|
|
|
|
|
Hi,
My project has several tab pages. When tabCoS is clicked on (which contains a datatable/datagrid), if a row was previously selected, I like to select it again.
private void tabControl1_SelectedIndexChanged(object sender, System.EventArgs e)<br />
{<br />
if (this.tabControl1.SelectedTab == tabCoS)<br />
{<br />
if (rowState == "unselect"){this.dg.Select(row);}<br />
}<br />
}
This doesn't work. Although when I throw a messagebox in before this.dg.Select(row);, after I hit OK, it works fine and the row is selected. This type of thing has happened before (commands don't work unless I put a messagebox in and click ok). Any idea why??? 
Thanks!
Mel
|
|
|
|
|
Are you sure your datagrid shows selection when it doesn't have focus?
It may be that the tab control maintains focus when you switch between tabs. The return from MessageBox may be handled in a different way (i.e. set focus to first tab stop).
Try replacing
{this.dg.Select(row);}
With
{this.dg.Select(row);this.dg.Focus();}
|
|
|
|
|
ok i'm a newbie with database and i'm just making some exercise to learn.
I'm learning also with ADO.NET book.
But i want to understend by you this concept.
If i query a database and i get the values into a DataSet object, then if i have to insert a new row o delete or update one just i do it on my DataSet then at the last make something to apdate again the database or all these operation need to do directly on the original database then empty the DataSet and update it again?
Thanks for help!
|
|
|
|
|
Hello,
I' m also a newbie (2weeks now) and did also some excersises on a database.
Are you using an SQL database ?
I do the updates on the dataset. When you generate the dataadapter and oledbconnection for sql, visual studio generates automatic update command for the sql. Is that what you are trying ?
Best regards Harry
|
|
|
|
|
yes, but my database is Access
|
|
|
|
|
Hi sasuko and harry, would you like some light reading[^]?? :P it's a good article.
You should be able to understand how to use ADO.NET the easy way, because believe me, it's difficult.
daniero
|
|
|
|
|
So here is my issue. I am communicating to UPS via there rate web service. I am retreiving the shipping options and costs and adding listItems to a radiogrouplist control (code below). I then have a button control that fires and event to take the value of the selectedItem and pass that through a calculateShipping() function...which updates order and cost. My problem is that when I fire the button event no value is able to be retrieved. I have tried retreiving the item.Text and nothing comes through there either. Here is the unusual point. If I manually add an item before the programmatic items are added then I can get the manually added items value..but none other. Am I building the line items incorrectly? Is this an issue with the control. PLEASE HELP!
C#
Code for programmatically adding listItems to the RadioButtonList control (rbUPS):
if (us.ServiceCode == ShipCode) {
ServiceName = ServiceName.Replace("®","");
odb.UpdateTempOrderShipping (cid,
ServiceName,
us.ServiceCharge * shipments *
decimal.Parse (ConfigurationSettings.AppSettings ["ShippingMultiplier"]));
this.rbUPS.Items.Add(new ListItem( ServiceName + " ($" + Math.Round(ShipCost,2) + ")", us.ServiceCode));
ListItem selectListItem = rbUPS.Items.FindByValue(ShipCode);
selectListItem.Selected = true;
}
else
{
this.rbUPS.Items.Add(new ListItem( ServiceName + " ($" + Math.Round(ShipCost,2) + ")", us.ServiceCode));
}
Code for the button control (updateShippingBtn):
public void UpdateShippingBtn_Click(object sender, System.EventArgs e)
{
if (rbUPS.SelectedIndex > -1)
{
string upsCode = rbUPS.SelectedValue;
//Response.Redirect("test.aspx?test=" + upsCode);
Session["ShipCode"] = upsCode;
}
else
{
Session["ShipCode"] = "03"; //UPS Ground Default
}
step.Value = "2";
headlineCheckoutStep.Text = titleCheckoutStep.Text = "Confirm Your Order";
checkoutStep.ImageUrl = ConfigurationSettings.AppSettings ["SystemImagePath"] + "steptwo.gif";
stepTwoPanel.Visible = true;
stepThreePanel.Visible = false;
CustomersDB cdb = new CustomersDB();
string cid = cdb.GetCustomerID();
calculateShipping (cid);
outputStepTwo (cid);
}
WHAT AM I DOING WRONG?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
