|
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.
|
|
|
|
|
You seem to be confusing me with the original poster. My string was "the bestiality displayed by the main character, Ali, suggests that there is a causality at stake here". Try that one.
|
|
|
|
|
Now i got you, please try bellow
static void Main(string[] args)
{
String s = "the bestiality displayed by the main character, Ali, suggests that there is a causality at stake here";
string pattern = @"\bali\b";
string replace = "/";
var s1 = Regex.Replace(s, pattern, replace, RegexOptions.IgnoreCase);
string[] parts = s1.Split('/');
for (int i = 0; i < parts.Length; i++)
Console.WriteLine(parts[i]+ i.ToString());
Console.ReadLine();
}
|
|
|
|
|
Using the Regex.Split method[^] (as OG suggested[^]) is a better solution:
string input = "the bestiality displayed by the main character, Ali, suggests that there is a causality at stake here";
string pattern = @"\bali\b";
string[] parts = Regex.Split(input, pattern, RegexOptions.IgnoreCase);
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
http://stackoverflow.com/questions/6025560/how-to-ignore-case-in-string-replace
|
|
|
|