|
A permission/rights problem. Fire up SQLManagement and look under security to see if the user under wich
you ran the app has the necessary privileges.
All the best,
Dan
modified 4-Dec-11 9:40am.
|
|
|
|
|
overloaded Name wrote
CREATE PROCEDURE [dbo].[ShowStudent] AS
SELECT * FROM StudentInfo
...
SqlConnection connection = new SqlConnection("Data Source=MUZE-LAPTOP\\SQLEXPRESS; Initial Catalog=StudentInfo;Integrated Security=SSPI;");
Which one is the database name ShowStudent or StudentInfo ?
Wonde Tadesse
MCTS
|
|
|
|
|
Nice catch. I completly missed it.
All the best,
Dan
|
|
|
|
|
I spent 4 hours  trying to get a simple report rdlc to display with no success. I keep getting this error "a data source instance has not been supplied for DataSet1"
To make it simple, I tried to bind with simple arraylist
In Winforms-(VS2010)
-I created DataSet with a table of 2 columns(Firstname,LastName)
- I created report1.rdlc with a table (2 Columns) from the DataSet
Note I can bind statically on page load, but I need to bind dynamically like below.
void OnClick()
{
ArrayList arr = new ArrayList();
arr.Add("Tim","Duncan");
arr.Add("Babe","Ruth");
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = "Report1.rdlc";
ReportDataSource drs = new ReportDataSource("DataSet1, arr);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(drs);
ReportViewer1.RefreshReport();
}
|
|
|
|
|
ReportDataSource drs = new ReportDataSource("DataSet1, arr);
have you missed " after DataSet1 here
ReportDataSource drs = new ReportDataSource("DataSet1", arr);
|
|
|
|
|
I wish I have. It's a typo while copying to the forum. Do you know if there is any simple working sample source code that I can download, then I can work backwards from there. I have tried several things I found on net, including binding to different datasources, like Datasets from Database, only works statically, but not dynamically. Any help would be appreciated.
|
|
|
|
|
Hi...
I want to create remoting server and client using sql server and store recordset. Please tell me how to solve this problem step by step!...Thank you in advanced...
|
|
|
|
|
You've got this wrong!
You work out the steps to solving the problem and then code it. If you have any problems with the code you've written that you can't solve, then you ask for help here with the relevant section(s) only.
|
|
|
|
|
Hi all,
let suppose var res = result.Select(s=> new {id=s.id,name=s.name}).ToList();
now i want pass this res in another method like func(res).
Please tell me that how can i get the type of this res or how i can get data from res.
|
|
|
|
|
Don't post to multiple forums, you have already asked this in Q&A. If the question is in multiple locations you will sort through multiple responses and people responding will not benefit from other responses in other forums and possibly give you duplicated and/or conflicting responses.
No comment
|
|
|
|
|
|
How can I assign an additional "enum" property to a pre-existing object?
I'm building a Trophy system for my website where user's can earn trophies for various achievements. I currently have a "Trophy" object which was created for me automatically in Linq when I created my dbml file. Nice and simple so far 
Now however, I want to include an additional property to my "Trophy" object of type enum called "TrophyLevel". For several, long winded reasons, I don't want to include TrophyLevel as a part of the actual "Trophy" object. So, I've tried setting it up in a partial class like the following:
public partial class Trophy
{
public enum TrophyLevel
{
Bronze = 1,
Silver = 2,
Gold = 3,
Platinum = 4
}
}
Is this the correct way I should be setting this up, and if so, how do I access it? So, basically, I want to be able to have code like the following:
Trophy.TrophyLevel = 1;
OR
String level = Trophy.TrophyLevel;
Am I going about this correctly?
Thanks
|
|
|
|
|
|
Yes, you are certainly creating a valid extension to the Trophy class via using the 'partial keyword, and I assume you realize that both the original and added classes should/must be declared with the partial keyword:
public partial class Trophy If I assume, based on what you present here, that 'Trophy is not a static class, then you are going to be creating instances of Trophy: you'll be using the instances like this:
Trophy tp1 = new Trophy();
Trophy tp2 = new Trophy();
tp1.theTrophyLevel = Trophy.TrophyLevel.Platinum;
tp2.theTrophyLevel = Trophy.TrophyLevel.Silver;
String level = tp1.theTrophyLevel.ToString();
"Anyone who shows me my 'blind spots' gives me the gift of sight." ... a thought from the shallows of the deeply shallow mind of ... Bill
|
|
|
|
|
Hi folks,
I am currently working on a side project for entertainment/ minor work related use. I am very much an entry level programmer.
The issue I am having, is I am attempting to output a series of strings with line breaks into a read only text box (user read only; I can of course access it in the code). I am storing them in a temporary string (although I also tried line by line printing), and then printing them to the labelbox. It is taking a huge ammount of time; 9 items takes .5 seconds. 200 takes several minutes. This is on an i7 2600k etc. etc (although the app is on one thread but still).
txtOutput.Clear();
StringBuilder builder = new StringBuilder();
foreach (string s in sorted)
{
builder.Append(s);
builder.Append("\r\n");
}
txtOutput.Text = builder.ToString();
}
I have pinpointed the problem to the code in bold. I have tried both stringbuilder and + concatenate. Can anyone help me improve efficiency and explain why its so slow?
Thank you,
Travis
modified 2-Dec-11 8:45am.
|
|
|
|
|
Good question! Should be like lightning. What is 'sorted'?
Regards,
Rob Philpott.
|
|
|
|
|
string[] strOutput = alFormOutput.ToArray(typeof(string)) as string[];
Func<string, object=""> convert = str =>
{
try { return int.Parse(str); }
catch { return str; }
};
var sorted = strOutput.OrderBy(
str => Regex.Split(str.Replace(" ", ""), "([0-9]+)").Select(convert),
new sortAlg.EnumerableComparer<object>());
Part of this I borrowed from another document, but to my understanding sorted is an array of strings. Before I send it to the 'sort' (where all of the above code and previous code posted is located) function, it is an arrayList. Do note that the sorting itself takes probably only a second on several hundred items. I tested that with timers and it was not the issue. Wish I could answer better, but I only partially understand natural sort.
Here is the article the code above is based on.
http://www.interact-sw.co.uk/iangblog/2007/12/13/natural-sorting[^]
scroll to the bottom.
appreciate the quick reply
|
|
|
|
|
Ah, well 'sorted' isn't a simple collection, its an IEnumerable which means in you foreach loop it will actually go away for each iteration and do all that sorting stuff. The Regex in the middle of it all is probably responsible.
Make sense? The thing you're iterating over isn't sorted, it gets sorted with each iteration.
Regards,
Rob Philpott.
|
|
|
|
|
I get the general sense of what your saying. Will have to research this ienumerator business. So is 'sorted' somehow calling class related sorting functions every time it is concatened?
Additionally, is there a better way to do a natural sort? Also Cint is off limits, as mixed letters and numeric characters is quite possible. And finally, is this a memory transfer issue? Processor is about dead while all of this is going on.
Really appreciate the good info.
~Travis
|
|
|
|
|
Pretty much. sorted is not an array, its an IEnumerable class which has basic 'get next' functionality. The foreach calls the get next which calls the RegEx stuff.
Without intense study, I can't see what the sorting algorithm is trying to do. Call me old fashioned, but put everything in an array, create an IComparer and sort the array using Array.Sort with that.
Sorry, I can see no reason why the CPU would idle while you wait for this.
Regards,
Rob Philpott.
|
|
|
|
|
That isn't true unless OrderBy is really, really dumb. It should create an order vector which the enumerator will then read sequentially.
|
|
|
|
|
Fair dos. So why does it take so long to execute then?
Regards,
Rob Philpott.
|
|
|
|
|
If I knew that I'd have posted a reply directly under the OP 
|
|
|
|
|
First off please use the correct formatting when posting code snippets to make it easier to read. Use the "code" toolbar item above the textbox when entering your question/response.
If all you are doing is iterating through the string array to insert a separator you could use the String.Join[^] method
string withSeperators = String.Join("/r/n", sorted);
However, with very few items in the array the StringBuilder method should be faster than you have indicated.
No comment
|
|
|
|
|
Tried the join method. It actually took quite a bit longer than the builder one. I think the processing time has to do with the class I attached in the link in my 3rd post. Apparently the methods in that class are called upon when concatenating 'sorted' with "\r\n" (didn't even know that was possible to tell the truth).
Anyone know of a better natural sort, or am I maybe implementing it wrong?
Can I convert 'sorted' (ienumerator type) to a string[] somehow, and then append based on that copy?
If anyone can help demystify the best approach to a natural sort that would be great.
Appreciate all the help guys. I'm off to school, so I won't reply for some time most likely.
~Travis
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
