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 …

Hello I am trying to display an ID which is a primary key in my table by selecting the corresponding name in my table. the names have been saved in a combo box and depending on the name selected the textbox will display that Id. the code I have so …

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 am new to progarmming. Am using using combo box control in vb.net combo box getting filled properly Public Sub new_entry_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim cn As New SqlClient.SqlConnection("Data Source=KAU-4A76A124FB9;Initial Catalog=SRRY;Integrated Security=True") cn.Open() Dim adp As New SqlDataAdapter("select * from Bank_Details …

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!

Hey I want to control a textbox to only allow numbers, backspace and a certain length. Ive tried with the IsNumeric function but I cant seem to get it to work. Thanks.

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 …

I have 1 Table Called "Menu" there are some textboxes and a combobox. I want to fill data in the Textbox called "Menu_Rate" on Selection of combobox selected item & coressponding rate of the Menu shoud be displayed in the textbox. [U]This is my Code[/U] [CODE]con.ConnectionString = "Data Source=localhost;Integrated Security=true;Initial …

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 …

when insert in the first char then it display the related item the combo box

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 there, Sorry to ask a silly/stupid question... I'm new to all this and i'm in the process of learning VB .NET using Visual Studio 2010... I just had a question because I cannot seem to find the answers anywhere on the internet... also we are not upto this part …

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 …