|
Shouldn't your app do that for him and then just show the statistical results? Or do you mean he's going to copy your data, paste it into Excel, and perform statistics there? Your app can do that.
|
|
|
|
|
Have you asked the users? Have you shown them what it looks like?
|
|
|
|
|
I would tend to agree with you.
Having worked with datasets in the 300 million row range my experience is that beyond 1,000(and probably fewer) rows the data stops making sense, and becomes useless, in a non-aggregated non-summarised format.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
frndz kindly help me how to select the data from table in sql server 2012 in c# using visual studio 2010 i have connected the database with the form. but its giving me error kindly tell how to reteive data from db.
|
|
|
|
|
What error?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
its telling that object name is invalid and the name he is showing thats the name of the table
|
|
|
|
|
public partial class Form1 : Form
{
SqlConnection sc = new SqlConnection("Data Source=AHASSAN-PC\\SQLSERVER2012;Initial Catalog=Sindh2_LARMIS_UAT_March;Integrated Security=True");
SqlCommand cmd;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
//string a = ("Select * from Taluka order by taluka_id ");
try
{
sc.Open();
cmd = new SqlCommand("Select deh_id from Deh",sc);
cmd.ExecuteNonQuery();
MessageBox.Show("selected");
sc.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
|
|
|
|
|
Check your DB:
You need a table called "DEH" and a column within that table called "deh_id" - unless both are present, you won't get anything.
And make sure you are on the right computer / SQL Server instance: if you have a production and a development server (and you should) you may be connecting to the wrong one.
If that doesn't do it, use the debugger to step through your code, and look at exactly which line throws the exception - it may help you to narrow it down a little.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Ive got a List<myClass> instance added to a DataGridView.DataSource. Now I want to filter this. What is the correct way to do so?
modified 18-Mar-15 4:57am.
|
|
|
|
|
You don't - instead, you use a DataView object, and filter that, having set that as the DataSource. Here's my code for my music player list filter:
private DataView dvFiles = new DataView();
List<Track> tracks = GetTracks();
tracks.Sort();
DataTable dt = tracks.ToDataTable();
dvFiles = new DataView(dt);
dgvTracks.DataSource = dvFiles;
private void textBoxFilter_TextChanged(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
AppendFilter(sb, "TrackName", tbTrackFilter.Text, "");
AppendFilter(sb, "Band", tbBandFilter.Text, " AND ");
AppendFilter(sb, "Album", tbAlbumFilter.Text, " AND ");
dvFiles.RowFilter = sb.ToString();
}
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
i often add asmx web service reference to my project and then i call the 3rd party web service. so i like to know how could i consume and call asmx web service dynamically without adding web service reference to client. please help me with code.
if possible then please discuss all possible ways to call asmx web service from dotnet client. looking for details guidance. thanks
tbhattacharjee
|
|
|
|
|
For your own good, I'm going to have to point out that you are being a Help Vampire[^]. We aren't here to do all your thinking or research for you so, read the link and decide whether or not you want to be a useful member of this site once and for all. You have a repeated history of this behaviour so I'm afraid that we're going to have to tell you like it is. Learn to use Google. Don't expect us to answer open ended questions. Do research for yourself. Only come back if you have a specific question that you can show evidence that you have tried to solve it yourself and that you have an area that you can't get past.
|
|
|
|
|
And "discuss all possible ways ...".
I may get flamed, but I'll say it anyway: a culture of entitlement.
|
|
|
|
|
You won't get flamed by me.
|
|
|
|
|
How to split a String on the basis of a specific word...
which means a string: My Name Is Ali
i want to split the string when ever Is comes.
|
|
|
|
|
Use a regex:
string input = "My Name Is Ali";
string[] parts = Regex.Split(input, @"\sIs\s");
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Any reason for the RegEx rather than just string.Split?
Regards,
Rob Philpott.
|
|
|
|
|
Because the syntax you have to use to split on string(s) rather than character(s) is so damn clumsy: 
string[] parts = input.Split(new string[] { " Is " }, StringSplitOptions.None);
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Fair point... There is a rather obvious overload missing.
Regards,
Rob Philpott.
|
|
|
|
|
When you split the string, are you wanting to split it so that "Is" is the start of the phrase or end of one?
|
|
|
|
|
try this
string s="test1 ali test2 ali";
string[] parts = s.Replace("ali", "/").Split('/');
|
|
|
|
|
And what happens when s contains "the bestiality displayed by the main character, Ali, suggests that there is a causality at stake here"?
|
|
|
|
|
static void Main(string[] args)
{
String s = "aaa ali jskdfhskjdfhk ali sjkhfkjsfhkjsdh ali";
var regex = new Regex("ali", RegexOptions.IgnoreCase);
var s1 = regex.Replace(s, "/");
string[] parts = s1.Split('/');
for (int i = 0; i < parts.Length; i++)
Console.WriteLine(parts[i]);
Console.ReadLine();
}
|
|
|
|
|
Nope, that's still wrong. Seriously, try it out with the sentence I gave you. There's only one occurrence of the word Ali in that sentence, but "ali" appears as a substring in other words. So, you should only get two phrases - your version returns 4 and you are corrupting the string so characters are being removed.
|
|
|
|
|
Message Closed
modified 18-Mar-15 8:36am.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
