skran

Hello! Why when I try to save a null value from textbox at sql server 0 is saved? The field type is number. I use an insert query to do that thanx in advance

Hi all! I have a user interface where I want to filter a datagridview.. I 've achieved to create filters but I 've failed to filter tha data by date.. I have a sql db and the column of date is of datetime type. When I try to filter the …

Great job! I m a newbie too and I found this information very helpful! Thanks a lot!

Hi, I am trying to eliminate crystal reports duplicates. For some reason, the same record showed 18 times!!!! Craziness!! I tryed to create groups, to check suppress if duplicates .. but nothing happened!! Plz help!

I try to filter my datagridview with a datetimepicker. When the datetime value is just date (eg.15/5/2010) everything work fine. But when there is also date and time value occurs conversion problem "conversion failed when converting date and/or time from character string". Iused also combobox populated with the dattime values …

Hi, First of all in line 30 I think you should change to '" & Combo_Bank_1.SelectedIndex.ToString & "' Try this and tell us..

HELP ME plzzz! I try to make my datagridview rows change colour depending on value on a row cell. I ve tryed everything i found on the web but nothing.. plz help Last I tryed this one: http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.cellformatting.aspx but stil nothing :(

Hello all! I would like your help please.. I have a datetimepicker and I want to use it for the time part only! So, I would like to disable its dropdown calendar.. Thank you in advance!

[QUOTE=ryan311;1574768]Just put this code in your keypress event in your textbox [CODE]Select Case e.KeyChar Case "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", vbBack e.Handled = False Case Else e.Handled = True End Select[/CODE] if you want to change the input length of textbox just click the properties …

Hi all! I m trying to filter a datagridview (connected to sql server). I have used if statements in order to take all the possible combination but now I have 8 textboxes into which the user should insert values and filter the datagridview.. it is too complex.. I have asked …

Hi all I m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query [CODE]query = "Select * from T_INCIDENTS1 where IFF (txtPostcode.text is notNull) then Incident_Postcode='" & txtPostcode.Text & "') and iff (txtDMA.text is notNull) then Incident_DMA='" …

Hi all! I try to filter a datagridview and I wrote an sql statement for that reason. The problem is that although I achieved to have multifilter I can find how to make my cod ignore the criteria which are null (empty criteria, when the user doesn t give any …

[QUOTE=bhavan kamble;1739263]Tried...... But it shows 'DataSource' is not a member of 'System.Windows.Forms.TextBox' 'DisplayMember' is not a member of 'System.Windows.Forms.TextBox'. But Thanxx..... Please Help .... I hv to submit My Project In Next week....[/QUOTE] Hi bhavan kamble! I've tryed to fill a textbox which was dependent on a combobox choice.. what …

Hi all! I use vb2010 and I try to filter a datagridview. I achieved to do this but not at the column of dgv like in excel.. I found information about datagriviewAutofilterColumnHeader library but i dont have this library and I dont know if it is ok fro vb2010. I …

Hi! I m trying to open a filter form at the center of a form which is inside the panel 2 of a split container.. I ve selected Start Position of the filter form => Center Screen but the problem is that when I push the button which opens the …

Hi all! I have a problem with autocompletion of a combobox..the combobox includes the names of employees.When I insert the first character the list whith the names which start by this letter doesn t appear any more.. :( I don t know what happening.. i think that i changed something …

Hi all! I have cascading comboboxes and when I choose the value for the first one everything is fine. But when I try to choose the value for the second combo the value of the first disappears. However, the second combobox is populated with the appropriate values and then I …

Hi! I had the same question.. The answer is at thread named "Cascading Combobox vb".

HELP!! I try to bind a textbox to a datatable but i cant.. I checked if the datatable is filled (it includes the results of a sql query)and it s ok.. i can depict the result in a combo box but not in textbox. I wait for only one result …

I would like to give me your help please.. I have connected my sql db with vb and I m trying to make a UI. My question is that when I write code in order to create datatables and I fill them with the results of queries I've created, where …

Hi all! I am writting beacause I desperately want your help.. I want to connect 3 comboboxes. I have a table which contains Streetnames, Post Codes and Municipalities. I want to choose the Streetname from the first combobox something that I have done. The second Combobox I want to display …

I have achieve to populate my combobox from sql and from this combobox to populate a textbox but now I have to do something more complicated.I would like to populate a combobox from an other combobox choice. And what i mean is that I have a table with Streenames and …