|
|
hi,
i use asqldatareader to read my data which the commandtext
has two transaction inside,when i attempt to get the data by Read() method it gets the first result set and the other is lost,when i use NextResult() method i get the other result set but first result of the set is skipped,
what should i do?
here is my commandtext:
mycommand.CommandText="SELECT COUNT(TypeId) FROM mytable1; SELECT Name, TypeId FROM mytable2 ";
|
|
|
|
|
|
hi,
here is my code:
com.CommandText="SELECT COUNT(TypeId) AS idcount "<br />
+"FROM NewsTypes ; SELECT Name, TypeId FROM NewsTypes "<br />
+"ORDER BY TypeId";<br />
try<br />
{<br />
SqlDataReader rd=com.ExecuteReader();<br />
rd.Read();<br />
temp=new NewsTypes[(int)rd["idcount"]];<br />
int index=0;<br />
while(rd.NextResult())<br />
{<br />
rd.Read();<br />
temp[index]=new NewsTypes((string)rd["name"],(short)rd["typeid"]);<br />
index++;<br />
}
thanks
|
|
|
|
|
Hi UAU,
The problem is with your while statement. Instead of that use a do while loop while using the NextResult on datareader. Guess the following code will help you.
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "";
conn.Open();
SqlCommand percommand = new SqlCommand("select * from person;select count(*)as name from person;",conn);
SqlDataReader reader = percommand.ExecuteReader();
do
{
while(reader.Read())
{
MessageBox.Show(reader["name"].ToString());
}
}while(reader.NextResult());
Thanks and Regards
SGS
|
|
|
|
|
|
unfortunatley this doesnt work yet,i lost first row of
the next resultset,i examined several ways but i loose my rows
|
|
|
|
|
|
I did so but i lost the first row of resultset.
I think i'd better use dataset instead.
|
|
|
|
|
My windows application creates word documents from template document with bookmarks and data from database. I create one document for each user, e.g. I select five users and application creates five MS word documents filled by data from database. Documents are saved in memory. I use reference to "Microsoft Word 9.0 Object Library" (MS Word 2000). My target is application creates word documents and merges into one document and saves it. Can you help me?
|
|
|
|
|
Have a look here[^].
It's a Web-based solution but it's quite similar to what you are after, and can easily be ported to a Windows application.
Hope this helps
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
Hi Guys,
I have a problem though I think it's hard to solve this unless you see the codes. Allow me to share to you and if you have any ideas that can help or comments is most welcome.
I have a tracking system web based program that record a daily activity of a certain operation department. Most of the time 2 or more users are working at the same time from different building. What I',m doing since it's a header/ detail information everytime they create new record and fill up the detail part I saved the record straight to our SQL database using a temporary key then when the USER PRESS a SEND BUTTON what I do is update the TEMP KEY with the original key of a record. The problem is that IF two users do this at the same time sometimes I get the other information record so when I open the file the next time for checking there is inconsistency of record because I can see that the information on the screen is supposed to be in the other person. If two page are open at the same time SOMETIMES I saved the page information which is wrong.
I don't used GLOBAL variable, all are local. Any Ideas?
Thanks
/dabuskol
|
|
|
|
|
I think you should consider reviewing your Database structure rather than your application's architecture. A good way for handling concurrent multi-usability would be to provide locks on the tables you are using (e.g. pessimistic/optimistic record or table locks, etc.).
I haven't done this before on SQL Server but I am 101% sure there are ways to handle multiple users.
Hope this helps
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
Hi,
Can someone help me to pass parameters from C# to a .au3 file (with a sample preferably).
Regards,
Abi
|
|
|
|
|
How to merge / include / embed an image file (such as jpg, wmf, etc.) in an Assembly so that the image file is also compiled inside the Assembly executable itself, instead of keeping the same as an outside file.
Keeping an image file outside the Assembly requires the presence of the image file alongwith the executable, causing error if the user has by mistake deleted the image file.
|
|
|
|
|
Have a look here[^].
Regards,
Polis
Can you practice what you teach?
|
|
|
|
|
Hi,
1) Create a resource file using ResEditor.
2) Using AddExistingItem option of the project add the resource file to the project and Build the application.
3) Use the ResourceManager class to retrieve these resources (use getstring and GetObject methods).
Thanks and Regards
SGS
|
|
|
|
|
Hi,
Can someone help me to pass parameters from C# to a .au3 file (with a sample preferably).
Regards,
Abi.
|
|
|
|
|
I've finally gotten my Crystal Reports to work with a DataSet. However, I am now facing a new problem.
I created a packing list in Crystal Reports, but now we need to be able to modify how the interface reacts based on data in the report - hence, the need for using a DataSet. Because of the amount data involved, the same data that is collected in the C# and passed as a parameter field to Crystal, is being used in a WHERE clause to limit the amount of data pulled into the DataSet (if we pulled everything into the dataset every time, we would be pulling 300-500 orders 400-700 times a day - too much load.)
The problem with this approach is that the DataSetis limited to the particular order that a box belongs to. Each time they try to process another box, it starts from scratch (theoretically). However, it only seems to work on the first box because something is keeping stale data. I tried disposing the dataset and dataadapters at the beginning of each try, refreshing the report object before and/or after setting the datasource method, and refreshing the reportviewer object before and/or after setting the reportsource method. All to no avail.
At this point I'm at a loss as to what to do to refresh the data so that I'm not using stale data each time I run the report. Any ideas would be greatly appreciated.
--In a world without fences, who needs Gates?
|
|
|
|
|
I wrote a class that binds a specific property of a control to Properties in another class. For example, given the class below:
<br />
public class MyClass<br />
{<br />
public int MyProperty<br />
{ get {
{ set {
}<br />
I can bind the SelectedIndex property of a ComboBox to MyClass.MyProperty
It all worked great until I run into properties that return enumerated types.
I looked at the IL code of my classes and the enumerated types are int32 so when I call the PropertyInfo.SetValue method with the value casted to int32 my program still crashes. The error I get is System.ArgumentException "Object type cannot be converted to target type".
I did try using Whidbey and it works, but I can't wait until it gets released.
Following is my code:
<br />
private void SetPropertyValue(object obj, string propertyName, string val)<br />
{<br />
Type objectType = obj.GetType();<br />
PropertyInfo propInfo = objectType.GetProperty(propertyName);<br />
string dataType = propInfo.PropertyType.FullName;<br />
<br />
if (dataType == "System.Integer" || dataType == "System.Int32")<br />
{<br />
propInfo.SetValue(obj, Convert.ToInt32(val), null);<br />
}<br />
else if (dataType == "System.Decimal")<br />
{<br />
propInfo.SetValue(obj, Convert.ToDecimal(val), null);<br />
}<br />
else if (dataType == "System.String") <br />
{<br />
propInfo.SetValue(obj, val, null);<br />
}<br />
else<br />
{<br />
Int32 val2 = Convert.ToInt32(val);<br />
propInfo.SetValue(obj, val2, null);
}<br />
}<br />
|
|
|
|
|
You can't set a property whose type is enum to an int. You have to convert it to an enum type. The best way to do this is to get the type of the property you are SETTING, using PropertyInfo.PropertyType. Then, using that type, get the TypeConverter from the TypeDescriptor.GetConverter. Test for "CanConvertTo", and if successful, to a ConvertTo and pass the resulting object to the SetValue method.
Marc
MyXaml
Advanced Unit Testing
YAPO
|
|
|
|
|
Marc,
Thanks a lot for your help.
I couldn't do a conversion from integer, but interestingly enough I was able to convert from string and the problem got solved. The code below has the fix.
<br />
else if (propInfo.PropertyType.IsEnum)<br />
{<br />
TypeConverter tc = TypeDescriptor.GetConverter(propInfo.PropertyType);<br />
if (tc.CanConvertFrom(Type.GetType("System.String")))<br />
{<br />
object valToSet = tc.ConvertFromString(val);<br />
propInfo.SetValue(obj, valToSet, null);<br />
}<br />
else throw new Exception and figure out next problem<br />
}<br />
|
|
|
|
|
rudy.net wrote:
I couldn't do a conversion from integer
If the "number" is a string, like "5", then it should still do the conversion to the enum type. At least, so it says in the docs for Enum.Parse, which the type converter should be using.
In general, you should be able to convert any value type to a string, and then be able to convert it to the appropriate property type. Otherwise, things like MyXaml wouldn't work.
Marc
MyXaml
Advanced Unit Testing
YAPO
|
|
|
|
|
I would like to invoke any control's event just as if the user or another source would. This, of course without building my own derivated class.
I've been looking around but i just don't seem to find the answer.
I tried the following but didn't work.
//What i'm trying to do here is to invoke a form's or a control's event by code. The idea seems right but i just could get it to work.
Form1 _fasoc = new Form1();
Type f = _fasoc.GetType();
System.Reflection.EventInfo ev = f.GetEvent("DoubleClick");
System.Reflection.MethodInfo minfo = ev.GetRaiseMethod();
//minfo gets null but the event is recognized. What's wrong?
minfo.Invoke(_fasoc, new object[]{this, new EventArgs()});
If anyone knows about this, please help me out, i'd appreciate it.
|
|
|
|
|
Why would you want to invoke an event when it is not supposed to fire? I just don't get it...
Is it because you want to be able to reuse the code contained in that event? Cause if this is the case there are other ways to implement it, rather than trying to fire an event when it is not supposed to.
Regards,
Polis
Can you practice what you teach?
|
|
|
|