Hi all I'm using datagridview with vb.net, I have a CHECKBOX COLUMN then I fill it I use CellContentClick event that when the user change the CHECKBOX COLUMN vlue then do ......... something what is happened, when the user change CHECKBOX COLUMN value the CellContentClick is firing , for eg: CHECKBOX COLUMN value before click = true after click will be = false when I go to get it's value

Dim chk As Boolean
chk = MyDataGridView.CurrentRow.Cells("Col_Check").Value)

it's still keeping its orginal value (True) it's saving the new value after you change the row if any one can help thank you

jooooo

Greeting All, I need to switch between calender type at Regional and Language options, Any one has an example or link that define that Thanks for all

jooooo

so thanks i found it CrystalReportViewer1.SeparatePages = false;

jooooo

Thanks for reply, I'm designing a report which contain alot of component in addition to CrystalReportViewer1 ,, then i'd like to view all pages of the report as html , I hope I can do it

jooooo

Hi all , I'm using asp.net and crystal report I'd like to view all pages of the crystal report in the web page without using crystal toolbar to navigate the pages .. can I do that ?

jooooo

Hi all , I'm using asp.net and crystal report I'd like to view all pages of the crystal report in the web page without using crystal toolbar to navigate the pages .. can I do that ?

jooooo

I'm using vs2008 , I try to view multi line at crystalreport textobject as next Dim s As String s = s & "this is first line " & Chr(13) + Chr(10) s = s & "this is second line " Dim rpt As New CrystalReport1 Dim txt As TextObject txt = rpt.Section2.ReportObjects("Text1") txt.Text = s but it isn't working , it print the text at single line ,, despite of when I export the report to doc file, I fount that it's printed at two lines .. what can I do Thanks

jooooo

I'm using vs2008 , I try to view multi line at crystalreport textobject as next Dim s As String s = s & "this is first line " & Chr(13) + Chr(10) s = s & "this is second line " Dim rpt As New CrystalReport1 Dim txt As TextObject txt = rpt.Section2.ReportObjects("Text1") txt.Text = s but it isn't working , it print the text at single line ,, despite of when I export the report to doc file, I fount that it's printed at two lines .. what can I do Thanks

jooooo

Thanks for reply I use print as you said <code>print ' SELECT * FROM ' + @table_name + ' WHERE Name ="' + @sName + '"' it's ok no errors ,, but no rows are returned ,, for eg @sName = "Jooo" this name is already exit but no rows return ,, I test the same statement but with another column type <code>print ' SELECT * FROM ' + @table_name + ' WHERE ID =' + @iID @iID = 1 it's ok and return the the required row, what the diff between nvarchar and int column to get the int and nvarchar no

jooooo

Hay , I edit a stored procedure to select a Name column from various tables as the next : Create PROCEDURE [dbo].[SelectName] @table_name sysname, @sName nvarchar(50) AS exec ( ' SELECT * FROM ' + @table_name + ' WHERE Name =' + @sName ) then when i execute it and pass the next valriables @table_name = 'emp' @sName = 'NameTest' the next error message appear Invalid column name 'NameTest' what the error here ,, thanks

jooooo

thanks my friend for your attention

jooooo

thanks Marcelo .. it's ok now

jooooo

Hay I don't know if it's possible or not ... can I get any file that the user copy it on the hard disk .. thanks

jooooo

Hay .. in SQL server 2005 I can make any select statement , but how can I get the last record : like that id invNo 1 a1 2 a2 3 a3 @newinv nvarchar(10) output AS SET NOCOUNT ON begin SELECT * FROM table ORDER BY invNo end I want to get the field invNo of the last record then by substring function i can add One .. I hope my question is clear . thanks

jooooo

Hay .. I have a table for eg , emp with the next data : ID Name 1 AA 2 BB 3 CC I fill the combo box as the next : combobox.ValueMember=ID; combobox.DisplayMember = Name; the user see Name but the application save ID in the database . then when I navigate records , sure the combobox dispaly the ID which is saved on database ,, I tried to do that : combobox.SelectedValue = combobox.Text; but it didn't give me the required result.. I want to view the Value (Name field) instead of text (ID field) thanks

jooooo

thanks my friend ... now it's ok

jooooo

Hay ... the next error message Both DataSource and DataSourceID are defined on 'GridView'. Remove one definition in spite of the page was ok , I tried to solve it without any result

jooooo

I need to know the current system language , I found that code : Bll.Language.Language.GetSystemLanguage(language); but i don't know the namespace of Bll thanks

jooooo

Thanks my friend .. what I mean that for eg .. I have users . every user is subscribe in group and every group has it's permission Read and Add and Del of all forms ... user A is subscribe in Group M and N for eg : customer form : Group M Read true - Add True - Del False Group N Read true - Add False - Del False then i want to select the permission of the user a from the table of permestoin .. you can see that the user has Add is true in group M and the same user has Add is false in group N i want to select True if i hase true or false of the same permissoin .. i hope if you see what mean

jooooo

Hi ... I have a table for eg called Forms (fid int , Read bit , Add bit , Del bit ) the problem that more than one row with the same Form like that : fid - Read - Add - Del 2 - True - True - False 2 - True - False - False 2 - True - False - True you can see that the form takes Add True and False in second row .. I want to select only one row but if I have Add col has two value True and False in another row then select True to be : 2 - True - True - True I'm using Sql server 2005 ,, can I create stored procedure do that ... really thanks ...

jooooo