Comments by Elham.Deljooei (Top 45 by date)

Hi,
I'm so sorry. I've had to say update instead of delete.
Could you help me?
Thanks and regret

Hi my friend,
Thanks for your answer.
That works for deleting manually?

Thanks my friend,
I couldn't find it probably, Could you explain it a little more?

Thanks for your answer but it's not work truly.

Excuse me,
I've changed it like this:
if ((d.Year < 1990 || d.Year > DateTime.Today.Year) && (d.Month < 1 || d.Month > 12) && (d.Day < 1 || d.Day > 31))
But it don't work truly. :(

I've changed it like this:
public DateTime CheckDate(DateTime d)
{

if ((d.Year < 1990 && d.Year > DateTime.Today.Year) && (d.Month < 1 && d.Month > 12) && (d.Day < 1 && d.Day > 31))
{
Console.WriteLine("error");
d =DateTime.Parse("0-0-0000" );
return d;
}
else
{
return d;
}
}
But when i enter 1-1-1000 in console, it calculate birthdate and return answer.

Thanks,
Elham

Sorry,I couldn't understand.

Oh Yeah I wrote //birth = Convert.ToDateTime(record["BirthDate"]);
I forgot to remove these //.
Thx.

I used it but It doesn't work truly.
For example it have to return 02/02/2000 but it return 01/00/0001

Hi friend,
Why cell address can't fill from sql?

I could do it with second solution, Thanks a million my friend.

Sorry, I couldn't found, i saw this link put ???

Your mean, I write it in trigger?
How to do rollback? else clk_Id removed from table and it exists in another tables.

Hi Maciej Los,
I meant to say, if this clk_Id exists in another tables, don't remove it and do rollback.
'If exists (Select HokmeKargozini.clk_Id from HokmeKargozini )'
but it don't work.

Hi Friend,
I've done second solution but i give an error.

no, i didn't do.
I've studied it into Ditel's book.
I've looked for about it alot, but i can't underestand.
Could you help me?

Nobody couldn't help me?????????? :=(
I would like to solve this problem.

Start the SQL profiler and run this report and see what query you received in profiler.
I don't underestand, what's you mean?

I did your suggest but it doesn't show to me.
Could you tell me What i have to do step by step for report viewer and procedure. I think i don't did it properly?

Hi friends
I want to use sotred procedure with Report viewer.
but i don't know how can i do it?

I did this but i choose Exist store procedure. i have got an error.
I have to send Name, Family, MelliNo To sotre procedure then it get me information.
where can i define my Textboxes?
Could you help me Step by Step?

This link Use for Visual Basic? or Visual Studio?
Thx.

HiI don't understand what are you mean?
Thx

HiThx for your solution.

could you help me?

i did it but i get it error :-(

this my code:

SqlDataAdapter adp = new SqlDataAdapter("Report",con);
adp.SelectCommand = new SqlCommand();
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dtbl=new DataTable();
dtbl.TableName="DataTable1";

adp.SelectCommand.Parameters.AddWithValue("@clrk_Name", txtNameReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_Family",txtFamilyReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_MelliCode",txtMelliCodeReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@AzTarikh",txtMelliCodeReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@Ela", txtElaReport.Text);
adp.Fill(dtbl);
ReportDataSource source = new ReportDataSource("DataTable1",dtbl);
reportViewer1.LocalReport.DataSources.Add(source);
when i run my project, i get this eeror

Error 1 The tablix ‘Tablix2’ is in the report body but the report has no dataset. Data regions are not allowed in reports without datasets. D:\Project\evaluation\WindowsFormsApplication1\WindowsFormsApplication1\Report1.rdlc WindowsFormsApplication1

HiI saw your message 5 min ago.
Thx for your help.

HiThat code has this eeror "Sequence contains no elements"

In Try when debugger arrive this line. it jump to Catch part and don't show any error message.

oh yeah. but i haven't gotton my ansewr.
i think it's correct but don't run.

Thx for your help:)

confirmed your question is resolve by mark as answer. how to do this?

I'm a new programer. I like Programing very much but i don't know how to start to learn c#.
can you instruct me?

I'm really sorry. I didn't see your message properly:(

First i want to know Why 'false'?
i added Using System.Linq; but those lines don't run.When the bugger arrived this line it jump to Catch part.
Thn for your help.

I don't know What you mean exactly?
I'm a new programer. I like Programing very much but i don't know how to start to learn c#.
can you instruct me?

Of course, you're right. but i don't know how to use this.
Exactly i want to say when variable 'i=1' then choose lbl1 and 'i=2' then choose lbl2(in a For).

Excuse me. can i say me "cmd.Parameters.AddWithValue("@clrke_Percent", this.Controls.Find(string.Format("lbl{0}", i), false).First().Text);"
what does this do exactly? Because i Want variable value be part of textbox's name. for example i define lbl1 and in the code i want say lbl[i].Text. based on 'i' the code choose own lbl and send its text.
I have tried this but it isn't correct.
i'm sorry again. Thx for your help.