Comments by Mayur Panchal (Top 63 by date)

Try _dt.Tostring() in below line
SqlDataAdapter adp = new SqlDataAdapter("select * from tblPSData where code_id='" + _id + "' and SDate='"+_dt.Tostring() +"' order by serial_no", con);
or
if it dosen't work then, debug your code get the exact query and try to run in sql query editor.

Then, you can do this stuff same as last solution, build another property for date and put extra condition on that method used to fetch data for grid. Simple !!!

This is your re-post, you have asked this question before and solved it. Below is link :
How to show all record on cell double click event in datagrid view to new winform using datagrid view?[^]

There is no any musical instrument in my .wav file. It's just normal speech of any person.
i.e. Someone specks "This is test" that need to be written in a textbox.

Something like speech to text recognition. But it's a .wav file in place of speech.

but, what about that exception ?

Please, show your property declaration.

It's working fine at my side. Exception is same or changed?

See updated solution. Write property as updated below.

On which line ?? which method ??

Plz show your code of, when you are double clicking on cell and opening new form. So i can suggest you.

and all those records are present on your current form or you will fetch those records when you load another form.?

Do you want to show all the records related to clicked entity or only count ?

Have you bind both controls with same datasource ?

at which line, you are getting the exception ? bcz i've tried at my side i m not getting any error.

tabControl1.Focus();
tabControl1.TabPages[0].Show();//If currently other tabpage is selected.
tabControl1.TabPages[0].Select();

Not clear. what you are trying to say?

What is the problem ??? any error ??

Is it winform or web(asp.net)??

Refer below link
http://www.codeproject.com/Articles/9781/How-to-Load-and-Display-Crystal-Reports-in-VB-NET

show us code for that and stotedproc.

But if report is in your project/solution then u can access it directly. you don't need the path for that.

int UploadFile_id = 0;
if (ds_UploadFile_id != null && ds_UploadFile_id.Tables.Count > 0 && ds_UploadFile_id.Tables[0].Rows.Count > 0)
{
UploadFile_id = int.Parse(ds_UploadFile_id.Tables[0].Rows[0]["Video_id"].ToString()) + 1;
}

field means ? a particular cell or whole column ?

please put it as a separate question on code project. and explain exactly what you want.

Great!!

Is there any other columns present in that Datagrid view control ?

You can handle TextChanged event of textbox. put a condition there, when limit reached then transfer focus to other textbox.

Which event of datagridview, you are handling to do your stuff?

ok. then you need to put a condition something like:
if (node.Attributes["name"] != null && node.Attributes["name"].Value == "USERID")

you can refer above method of reading elements. To update you just need assign innertext property of the tag you want to update or if case of attributes you need to update value of the same.
for example:(Code in above method)
if (node.Attributes["name"] != null)
{
node.Attributes["name"].Value = "NewValue";
}

Nothing special in it. There's a join of two tables in above query.

Look at the updated solution above.

it's not possible to set e.Handled on checkbox's checkedchanged event.
You have to do some other workaround for that.
I suggest you to maintain disable chars in List<char> when you check on checkboxes and then handle it in keypress event. You need to find in list whether your disable char is present or not.

But why you want to call another method ? you can make a condition in KeyPress event though.
What's your condition, when u want to disable 'A' and 'a' ?

You mean previous twenty months? Right?

Do you want any specific range or only current year and month.

Can't you start maximized?

Set the System.Windows.Forms.Form.WindowState property to FormWindowState.Maximized

I have tested what u want to do with some sample data :

dtCombo.Columns.Add("DoseDesc");
dtCombo.Columns.Add("DoseId");
dtCombo.Rows.Add(new object[] { "Dose1", 1 });
dtCombo.Rows.Add(new object[] { "Dose2", 2 });
dtCombo.Rows.Add(new object[] { "Dose3", 3 });
dtCombo.Rows.Add(new object[] { "Dose4", 4 });

doseid.DataSource = dtCombo;
doseid.DataPropertyName = "Doseid";
doseid.DisplayMember = "DoseDesc";
doseid.ValueMember = "DoseId";


dt.Columns.Add("doseqty");
dt.Columns.Add("doseid");
dt.Columns.Add("timesqty");
dt.Columns.Add("timesid");

dt.Rows.Add(new object[] { 500, 1, 3, 1 });
dt.Rows.Add(new object[] { 100, 2, 3, 1 });
dt.Rows.Add(new object[] { 500, 3, 3, 1 });
dt.Rows.Add(new object[] { 300, 4, 3, 1 });

dataGridView1.DataSource = dt;

and its working nice..I can see display member (Dose1 ,Dose2...)
Is anuthing different than let me know..

I think u should handle OnPreviewKeydown event to catch 'Enter' key in user control and write your stuff there.

I have implemented above code..for the xml you have given.
I works fine with it. Please test it with other XMLs alos.
If u face any problems then let me know.

Is it winForms application or web(ASP.net) ?

Please, Confirm you want only those tag which have 'name' and 'type' attributes and others will be ignored. ??

It is possible but, there should be something fixed format, I mean to say root tag or the parent element of your start tag.
Let me explain : In above xml your first tag is 'rule' then 'interface', and you want to start with 'fixParam' tag. So the path would be fixed from where you want start or which will be your first element.

XmlNodeList titleList = rssDoc.GetElementsByTagName("name");
XmlNodeList urlList = rssDoc.GetElementsByTagName("type");

Above two lines are wrong. Because there is no tag with "name" and "type" name, those are attributes of tags.
We can see tag names are "fixParam", "chgParam" etc..
Let us know that which tags you need as output?

Your dataset is blank or there is a table with no row ?

Fist of all execute your exact query with where condition against your database in sql query editor and see whether it returns any result or not ?

I think, You can use ViewState.

Yes, you need to debug the code. Find what the actual query is executed and try that query to execute in SQL query editor then you will find what the actual problem is.

You can try this:
System.IO.Path.GetFileName(SaveFileDialog1.FileName);
System.IO.Path.GetFileNameWithoutExtension(SaveFileDialog1.FileName);

with extention or without ??

Do you want to convert it into c#?

Can you show a bit of code of OnSizeChange() event ?
Are you using form.Refresh() method in above event ?

Do you want result for only one class?

Is it windows(desktop) application ?

Thanks but that's not what i want to do. I have already done that you've reffred. Actually i want to draw extra image over ListViewItem image.

Thanks for the solution..

It works great..
I must appreciate this.


Thanks again.