Comments by mit62 (Top 111 by date)

when I use a breakpoint on DataReceivedHandler , the portdata gets data and everything is ok but at the end when process back to this line "txbShowFile.Text = PortData.ToString();"
portdata is null

Ok. thank you all

so I had to apply enabling or disabling the button in every event that grid change.is it a good way?

I declare Tables in my question, My expecting output is @result.
if all input parameters be equal with Field of two table then @result=1

I just want to know how can I access to values inside childe1.
this code was wrong:
var ms = doc.Elements("main").Elements("child1").ToList();
fields = ms.Select(s => new Class_PersonelInfo()
{
prsnlCod = s.Element("a").Value;
}

thanks a lot.I didn't know about pivot tables. But I need a solution in c# and I found it.

Thanks

thanks but performance of which one is better?class or datatable?

thanks a lot

Thanks. I changed TextChanged Function.
public static void SpiltOnThird_TextChanged(object sender, EventArgs e)
{
TextBox txb = (TextBox)sender;
int caretIndex = txb.SelectionStart;
txb.Text=numberSpiltOnThird(txb.Text);
txb.Select(caretIndex, 0);
}

thanks for your reply.I have another question, how can I send this list of object to a Stored Procedure?

no error in "theFont" class.But just if I use this code
foreach (Control cx in this.Controls)
cx.Font = theFont.CargoPrivateFontCollection(9f, FontStyle.Regular);

in more than one of User controls this error happen.

(plus I have some problem on this foreach loop,because it dosn't select all controls in UserConrol)

I read these articles and changed my program.please tell me if it's correct.
bool statusFlag=true;
using (TransactionScope scope = new TransactionScope())
{
foreach (var loan in _loanlist)
{
if (!pda.InsertLoan(new Loan{
prsnlcd = prsncod,
LoanCode = loan.LoanCode,
LoanStatus = loan.LoanAmountRemain == 0 ? true : false}))
{
statusFlag=false;
break;
}
}
if(statusFlag=true)
scope.Complete();
}

Thanks for your reply.in my solution I embed font to resources too.

in Program.cs file on Application.run

don't know anyone?

I want Give this permission programatically.
(I changed my code for mdf ldf location)

no,I do debug and ListOfObject has two different item but result in report shows first of them.

Modify the comment. Deleted
I tried to handle tab key on last control inside tab1. but it doesn't work.
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
if (keyData == Keys.Enter)
{
if (this.ActiveControl.TabIndex == 2)//Control2 inside tab1
Control3.Focus();
}
return base.ProcessCmdKey(ref msg, keyData);
}

ok.thanks a lot

I will define this static class. then for example if there are two user control, If I change GlobalString in UC1 to "newvalue",does the value in US2 will be updated to "newvalue"?

Telerik dont reply soon.If I ask now they will reply next week.

OK thanks.

for example I enter "12:00" in cell1(every row every column)then immediately in cell2(every other row,every other column) I enter "12:00"the problem is DGV doesn't accept this value("12:00") but accept every other row in second cell.

ok,thanks.I changed the code.

Thanks a lot

tnx but,the functions in if clauses are different.

Thank you :)

I don't want declare variable s1 because I think declare a lot of variables will take place memory and hit performance.is there any way to avoid declaring s1 variable?

Ok,I do that :)

Ok,thanks for your help,you learn me a lot,thanks

sorry,for changing winform to UC is that a good way to change the form to inherit from UserControl instead of Form, then fix any compile errors?

you're right

Sorry,I have another question.If I put some controls on a tab page instead of form. then sometimes I must hide or show this tab for example if an event occured,how can i handle this?
using tab.hide() and tab.show() is enough? and something else,when main form will be loaded all embedded controls should be load too?doesn't make it a bad performance?

thanks SA, the Speed was very low too I'll change my design thanks

oh Thanks,but I'm beginner and I don't know about user controls ,I'll change my design.thanks again

but exceptions in my if clauses are not original exception like DivideByZeroException.
my exceptions are kinda custom exceptions. for example happen when a function has error

ok thanks but this part is not clear for me.
try
{
// statements that can cause exception.
}

and how I call Catch when code in Try is wrong?

would you please tell me how write throws?

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

it doesn't work

well my databas is not on local server "Server=.".

plus,application run without error when I set this connection string inside my program.

public SqlConnection Sqlc = new SqlConnection("Data Source=MyServerName;
Initial Catalog=myDataBase;Integrated Security=True");

Milfje,thanks for your help. My solution is correct. the problem caused something else.sorry

I did it with regular binding datatable to DGV way and the result was ok.but now I want change my columns to custom maskColumns type.I defined columns and add them to grid then I bind datatable to grid's datasource. but the result is wrong.

thanks Bill. I change my idea. I'm using TabControl.

but I need DataGridView :(

no ToString overload. Ok,I'll improve them.thanks a lotttt Bill

error is on this lines on .Resources:
this.MnuPrvndPrslInfo.Image = global::Salary.Properties.Resources.image;
where should I check if Resources class is availible?

no,no

cells are strings in time format:"12:22:00", I change this string to timespan for every cell

yes,Telerik on winform

you know some parts of code are repeated and I think if I can use another for loop or sth similar it will be cleaner. also if I want use for example some buttonColumns I should change cell indexes again.

sorry i don't got. which part of code do you need?this is just an object initilizer and I showed codes inside of that.
RowsList.Add(new PersonelCardClass() { ...I showed the code.inside here in my questtion.... });

Yes this is work good.it hasn't any constructor

ok

thank you very much

Ok,I found the problem.
SELECT @empID=empID FROM EmploymentInfo WHERE FK_pID =(SELECT pID FROM PersonelInfo WHERE PersonelCode=@personelcode)

and second insert should be done first, because it is parent:
insert into ICardDate(FK_empID,Imonth,Iyear)
Values(@empID,@fk_month,@fk_year)

nsert into PersonelCard(FK_empID,FK_month,FK_year,VacationHours)
Values(@empID,@fk_month,@fk_year,@vacationhours)

CREATE PROCEDURE [dbo].[InsertRowInPersonelCard]
(@personelcode varchar (50),
@fk_month int,
@fk_year bigint,
@vacationhours time(7))
as
DECALRE @empID INT

SELECT @empID=empID FROM EmploymentInfo WHERE FK_pID =(SELECT pID FROM PersonelInfo WHERE FK_pID=@personelcode)

insert into PersonelCard(FK_empID,FK_month,FK_year,VacationHours)
Values(@empID,@fk_month,@fk_year,@vacationhours)

--the same value of @empID,@fk_month,@fk_year should insert in this table too
insert into ICardDate(FK_empID,Imonth,Iyear)
Values(@empID,@fk_month,@fk_year)

GO

this is not my code. this code is generated when I execute StoredProcedure

query returns a minus value
DECLARE @return_value int

EXEC @return_value = [dbo].[InsertCa]
@personelcode = N'21',
@fk_month = 1,
@fk_year = 1395,
@vacationhours = '06:05:50'

SELECT 'Return Value' = @return_value

GO
Return Value:-6

isn't question clear?

oh thanks a lot, you helped me.

o yes TimeSpan

No I mean origin TimeStamp. you know in this application the users store times to a monthly table in entry and exit columns for each day and just in this format hh:mm

I defined a field in which represent entrance time of people to company.I want save this time in a short style "hh:mm:ss" to my sql Database.so I choosed Time(7) Data type in sql and TimeStamp Type in C# class.now I need to know How Convert time from TimeStamp to Time(7) in sql and vice versa.

thnaks, but how should I Convert sql Time(7) type Data to TimeStamp?
I want Save sqldatareader["TimeDatatype"] to a TimeStamp C#Type, in this format:{"hh:mm:ss}

Oh,yes.it was Careless

I improved question

thanks.in this way timecolumn in sql is TimeSpan DataType or Time(7)?

I improve question

AcceptReturn Multiline SuppressPress Result
False False False beep
False False True nobeep
False True False nobeep
False true True nobeep
True False False beep
True False True nobeep
True True False nobeep
True True True nobeep

I set MultiLine=true and it works without SuppressKeyPress = true;
I set MultiLine=false and it works again with SuppressKeyPress = true;

thanks.

thanks your suggestion.

if you think there is no problem so I accept.thanks

oh wonderful answer. thanks a lot, you learn me a lot.
I have a plus question.If this application be installed on server and be multi user, does static variable make problem or not?

thanks a lot. it works. but if i set my Securemethod Internal, I think its less secure because as you said other classes in assembly can access. is there a way that LoginForm inherit Mainform?(so securMethode will be protected and I think more secure than Internal)

Ok. thanks

thanks a lot. but I'm beginner in c#. I got the code and I understand why we should use SqlParameterCollection. but I just didn't get this line "objParamColl = objCommand.Parameters;" you know, I translate this line in my brain something like this" objCommand.Parameters=objParamColl;"

I have another problem with this class:
PersonelInfoAndEmploymentInfo person = new PersonelInfoAndEmploymentInfo();
person._empinfo.jobLocation = "asdasd";

now error is: Object reference not set to an instance of an object"

oh,sorry public had been removed from "employmentInfo" class. thanks

thanks.

I remove jquery1.5.2 in Magicline part and it works with jquery1.7.2 in slider part. then I remove jquery1.1.2 from Dockmenu part but that dosnt work. now I have this:

<!-- jQuery KenBurn Slider-----------jquery1.7.2--jQuery UI 1.8.5---->
<script src="SliderRevolution/rs-plugin/js/jquery-ui.js"></script>
<script src="SliderRevolution/rs-plugin/js/jquery.js"></script>
<script src="SliderRevolution/rs-plugin/js/jquery.themepunch.plugins.min.js"></script>
<script src="SliderRevolution/rs-plugin/js/jquery.themepunch.revolution.min.js"></script>
<script src="SliderRevolution/rs-plugin/js/Slider.js"></script>
<link href="SliderRevolution/rs-plugin/css/captions.css" rel="stylesheet" />
<link href="SliderRevolution/rs-plugin/css/settings.css" rel="stylesheet" />
<link href="SliderRevolution/style.css" rel="stylesheet" />
<%------------Magicline ------------jQuery 1.5.2--------------------%>
<script src="MagicLine/js/example.js"></script>
<!-------------Dockmenu------jQuery 1.1.2---------------------------->
<script type="text/javascript" src="./dock/js/interface.js"></script>
<link href="./dock/css/style.css" rel="stylesheet" type="text/css" />

maybe I must use some code in interface.js to avoid conflicting.but I dont now how


eval(function (p, a, c, k, e, d) { e = function (c) { return (c < a ? '' : e(parseInt(c / a)))......split('|'), 0, {}))

I removed lower versions but didn't work

tnx

thanks. i should use linked algorithm(http://www.queness.com/code-snippet/6523/generate-md5-hash-with-javascript ). I don't want get original input on serverside but i want use the hash value and compare it with the value in database.i dont know how hash password before send it to serverside

thanks for lighten my way

it works.thanks a lot.

private void button1_Click(object sender, EventArgs e)
{
int k=0;
string s = Clipboard.GetText();
string[] lines = s.Split('\n');
foreach (string line in lines)
{
if (k < list.Count)
{
list[k++].Text = line;
}
else
break;
}
}

thanks Mohammad but it has this error:

"'openweb.info' does not contain a definition for 'Select' and no extension method 'Select' accepting a first argument of type 'openweb.info' could be found"

"openweb" is my namespace and in my sample code info is a class:

class info
{
private string _name;
public string Name { set { _name = value; } get { return _name; } }
private string _adrs;
public string Address { set { _adrs = value; } get { return _adrs; } }

}

yes there is other buttonCulomns.
this line has error //btncol.Text = lst.Select(c => c.Name);????????
Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<string>' to 'string'

thanks a lot