Comments by rezaeti (Top 113 by date)

cmd.Parameters.AddWithValue("@UserName", UserName);
da.selectDataUser(cmd);

but error in :(bl_bind()) shown.
Error : 'BLL.bllUsers.bl_bind()': not all code paths return a value

hi . thanks for reply.

[code removed]

but why it does not work . the error is :
Error 1 No overload for method 'SelectDataUser' takes 1 arguments

the problem is that value does not show on label

hi Richard Deeming thanks for reply
how can i filter my query to load only 50,000 records or less

hi thanks I set adp.SelectCommand.CommandTimeout = 0
and set findcmd.CommandTimeout = 0;
and all things is ok and error solved
so thanks

I mention that all things is ok, but when I dont run for about 30 seconds and then run , this error display

hierror yet remaind but shift to this line :
SqlDataReader dr = findcmd.ExecuteReader();

thanks for reply
I check and then coming

hi thanks
I use sqldatasource
i find this code for total number of rows in grid:
int totalRows = e.AffectedRows;
but yet question 1 is remaind without solution

thanks

hi thanks for reply
but when I add sh_ghab to GROUP BY list all records display
I want to display last record of each group

hi thanks for reply
i have this query:

Use mydatabase
Select emp_num,group_num,edit_num,id=MAX(id)
From tbl_child
Group By emp_num,group_num,edit_num

it make group my detail table(child) successfully and show last record but only display 3 columns when I add other column to SELECT error show:
Column 'tbl_child.sh_ghab' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

id field is identity

hi thnaks for reply
yes I use sql server 2008
i mean last record that insert in table naturally i think the last record has highest ID

thanks.

thanks.

I have a question about stimulsoft do you can help me

I have a question about stimulsoft do you can help me

very thanks

so thanks it work

hi thanks
I try but code dont work
if (e.Row.RowType == DataControlRowType.DataRow)
{

e.Row.Cells[4].Text = String.Format((e.Row.Cells[4].Text), "#,##0.00");

}

i check and sure the txt_egample is exist in my page and Text5 also exist in my report

thanks Jochen Arndt dont work
the error :
Object reference not set to an instance of an object.

txt_egample is not null
but txt.Text is null
i dont know what is wrong in here?

thanks for reply i try it.
but my problem is remaind yet.

excuse me
this line is correct
txt.Text = txt_egample.Text;

thanks for reply
can you help me?

txt.Text = txt_date.Text;

the above code is good but it is not answer for my question

hi I find that answer by search in google

Hi Richard Deeming Thanks for your attention you are true and I edit my code
thanks again

is there any one to answer me ?

yes my above code is code behind.how to solve my problem?

please help me!

all of ddl work correctly but one of item for all ddl does not selected

hi thanks for reply
viewstate enabled for all the ddls is true.
my question is:
suppose that my ddl items are:
2012
2013
2014
2015
when I select 2013 the ddl item does not select and item 2012 be selected. but for other items work correctly

thanks richard MacCutchan

I cant do that

can you say how to use tryparse in here?

when I set initial value of lbl's = 1 the error solved but I want to handled basically

ok I improve the first one
could you help me

hi I edit my code as above but yet does not work:

the value of labels are not equal zero .the values of them loads from db by dropdownlist.selectedvalues.
please say what do i do?

what changes do i do in my code?the value of labels are values of database that load by dropdownlist selectedvalues

hi thanks for reply
how diplay record to gridview?

the error :
An expression of non-boolean type specified in a context where a condition is expected, near ','.

Is there any one to help?

thanks it work

thanks it work

???

I cant solved it I wrap column names in brackets
SqlCommand cmd = new SqlCommand("select * from shakhes where [month]=" + ddlEmpRecord.Text + " ", con);

oh yes

oh yes my english is bad

hwo do i use brackets for columns?
e.g (month)?

hi thanks for replay
there is no error at runtime
I dont know how to use a parameterized query rather than trying to use string concatenation to form your query.
I am a amateur
pleas help

this code does not work:
SqlCommand cmd = new SqlCommand("select * from shakhes where month=" + ddlEmpRecord.Text + " ", con);

but this work when change month with year:
SqlCommand cmd = new SqlCommand("select * from shakhes where year=" + ddlEmpRecord.Text + " ", con);

by the way when I replace "month" with "year" field this code work goodly why does not work when I use month in dropdownlist as text??!

I edit my code
I want when select text of dropdownlist ( a month) then the year and month and salary text display in labels and gridview

yse of cource

I need to solve this problem please help me.

Hi thanks for reply
I try this from ddlEmpRecord_SelectedIndexChanged and page_load but does not work

10. now I want do same thing for asp.net but my problem is that gridview dose not have same property e.g
i = ShakhesDataGridView.CurrentRow.Index
TextBoxX2.Text = ShakhesDataGridView.Item(2, i).Value


11.by the way i know about asp.net and c# a liitle and i am an amateur

very very very thanks! I learned from you ManasKumarM

when i click on edit button on gridview following error shown how to solve error?
'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

I can do by set property of checkbox (autopostBack)
Is this ok ?

I can do by set property of checkbox (autopostBack)
Is this ok ?

I can do by set property of checkbox (autopostBack)
Is this ok ?

I can do by set property of checkbox (autopostBack)
Is this ok ?

I solved by set auto post back true
is this correct? or may be create an erorr

in my windows app vb.net this code work successfully but in asp.net web form with vb.net not work why?

hi thanks but I use six check boxes in my web form and I want use chekbox for all to be same how can make two checkbox Mutually Exclusive

by the way in my pc when I stop sql express app work yet

excuse me ths is last question :
when I install app on another pc this error display :
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
I search on internet about this error and I found this error is related to stoping sql express on another pc
I install sql express on it but sql exoress is not runing and my tring for runinig it was not successful
what i do ?

is this connection work for any windows for example windows 8 or 7 or xp or ...?
and is this connection work for 64 bit and 32 bit ?
does it matter the type of sharing for example local or net or LAN or any thing else?

by the way i have code that write and read xml file to create dynamic connection string that replace txt.servername.text with myservername and so on

thanks

my database is sql server

mt database is sql server

it is solved

hi Afzaal Ahmad Zeeshan
i edit my code so and work successfully
Public Sub add_data()
cn.Open()
Dim dr As SqlDataReader
Dim cmd As SqlCommand
cmd = New SqlCommand("select * from shakhes where sal_tadieh='" & TextBoxX1.Text & "' and mah_tadieh='" & ComboBox1.SelectedItem & "'", cn)
dr = cmd.ExecuteReader
If dr.Read() Then
MessageBox.Show(" تاریخ مورد نظر تکراری است ", " خطا ", MessageBoxButtons.OK, MessageBoxIcon.Error)
cn.Close()
Else
dr.Close()
cmd = New SqlCommand("insert into shakhes(sal_tadieh,mah_tadieh,tadieh_shakhes) values ('" & TextBoxX1.Text & "','" & ComboBox1.SelectedItem & "','" & TextBoxX2.Text & "')", cn)
cmd.ExecuteNonQuery()
cn.Close()
display_data()
End If
display_data()
End Sub

really excuse me if you have not time i come tomarrow i feel you will reply

excuse me beacase you say i come here

ok my firend

thanks

but if you reply this question it will be last question

excuse me i forget that it is sunday beacuse in my country friday is HOLIDAY then I ask my question tomarrow

is there any one?

thanks

it's solved

so math thanks

is there any one to help me!

please help!

thanks solved

an missing (

please help !

Richard Deeming thanks

really thanks my friend you make me INDEBTED

very very very thanks

i change place of function but this error thrown
The ReadElementContentAsString method is not supported on node type None. Line 9, position 14.
thanks for reply
please help me my friend

I don't know how and where use MyDStr function

reader.ReadToFollowing(MyDStr("pwd"))
i think this statement is invalid

how solve that error

hi thanks for reply
i cant speak english very good
That's where it's caught; not where it's thrown.(what means this reply)

my deer PIEBALDconsult
thanks for reply my error is :
Invalid length for a Base-64 char array.

this line:
Catch ex As Exception
Throw ex
error is :
Invalid length for a Base-64 char array.

my friends!
pleas help me
i must propose my project tomarrow