.NET (Core and Framework) Discussion Boards

Re: Embedded XP supports .Net Framework ?

Jaime Olivares3-Aug-08 23:39

Jaime Olivares

3-Aug-08 23:39

Which specific features do you want to support?

Best regards,
Jaime.

How 2 return a string value from sql server in SP?

balaji.t3-Aug-08 20:03

balaji.t

3-Aug-08 20:03

hi folks,

A SP in sql server is not returning a string variable as output variable ..can any1 let me know how to return a string variable from SP in sql server?A function returns a string variable whereas a SP doesnt return.y?

for e.g I have created a SP

create procedure SP_abc(
@a INT
@b out VARCHAR(10)
)
as
begin
set @b = 'ABCD'
end

How to get the value of b in the front end?

T.Balaji

Re: How 2 return a string value from sql server in SP?

Jaime Olivares3-Aug-08 23:50

Jaime Olivares

3-Aug-08 23:50

If you fire the SP with SqlCommand.ExecuteNonQuery(), then you can retrieve the parameter with SqlCommand.Parameters collection as:

SqlCommand command = new SqlCommand("SP_abc");
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@a", SqlDbType.Int);
command.Parameters["@a"].Value = somevaluehere;
command.ExecuteNonQuery()
string b = (string)command.Parameters["@b"];

Best regards,
Jaime.

Re: How 2 return a string value from sql server in SP?

balaji.t4-Aug-08 0:41

balaji.t

4-Aug-08 0:41

hi,
But im getting a value as 1 and 0 and im not getting the value of though im usign LINQ.Can u tell me whether it is possible to return a string value as output in the front end using SP?

T.Balaji

Box and Whisker Plots

cb020613-Aug-08 16:38

cb02061

3-Aug-08 16:38

Hi,

Is it possiable to draw Box and Whisker Plots chart in .net????
refer

http://peltiertech.com/Excel/Charts/BoxWhisker.html[^]

regards,
usha

Re: Box and Whisker Plots

Thomas Stockwell4-Aug-08 4:14

Thomas Stockwell

4-Aug-08 4:14

Technically it is possible to emulate them with the graphic libraries, but their is no native support for graphing. You can either create your own custom controls or look into a third-party control that may have what you are looking for.

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my Blog

Question about Composite UI Application Block and Smart Client Software Factory

aspnet2.developer30-Jul-08 18:44

aspnet2.developer

30-Jul-08 18:44

Hi,

I am developing a demo application using Microsoft Composite UI Application Block and Smart Client Software Factory. I am using Access as the database & want to show the one of the tables in the DataGridView.

I have no clue as how I should do this. Can any one help in the same?

Thanks in advance,

Re: Question about Composite UI Application Block and Smart Client Software Factory

led mike31-Jul-08 4:51

led mike

31-Jul-08 4:51

There are several Database beginner level tutorial type articles here on CodeProject. I suggest you take a look at one or more of them.

See in the site menu bar CHAPTERS section and the subsection Database

led mike

Which one is better for voice response system in C#.NET? (kdtele , tapi , tapiex )

hd_banki30-Jul-08 11:53

hd_banki

30-Jul-08 11:53

I want to write a voice response system with C#.NET. But I don't know where I should start? Which component is better and easier to use (why?) and What is the difference between them? Also please say the differences between kdtele , tapi , tapiex?
Please help me.

Re: Which one is better for voice response system in C#.NET? (kdtele , tapi , tapiex )

Paul Conrad2-Aug-08 19:05

Paul Conrad

2-Aug-08 19:05

Not sure which is better. Have you researched the different components and weigh out the pro's and con's?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Image Button in Datagrid

cb0206129-Jul-08 23:07

cb02061

29-Jul-08 23:07

Hi,

I already added an image button in Edit Item Template.
I created calendar in Edit Item Template, i make it invisible.
How to show calendar whenever image button clicked in datagrid????

Thanks,
usha

Re: Image Button in Datagrid

ElSpinos30-Jul-08 4:21

ElSpinos

30-Jul-08 4:21

A possibility:

Investigate using AJAX and embed an UpdatePanel in the EditItemTemplate containing the calendar with it's visible property set to false. When the image click event is fired, set the calendar's visible property to true to show the calendar.

Good luck...

/F - .NET Developer

Re: Image Button in Datagrid

cb0206130-Jul-08 14:22

cb02061

30-Jul-08 14:22

Hi,

Thanks for ur reply...

Calendar drpDgTrType = (Calendar )Datagrid1.FindControl("drpDgTrType");
drpDgTrType.visible = true;

However, i got Object reference not set to an instance of an object error when
i run the codes.

Please help...

regards,
usha

Re: Image Button in Datagrid

Bardy855-Aug-08 4:03

Bardy85

5-Aug-08 4:03

On Row Create set the Command Arg to the row index.
On the Command event of the gridview, set the command name of the Image button to ImgClicked or any thing you like.
In the Method of the Command event.

if (e.CommandName == "ImgClicked")
{ 
    ((Calendar)GridView.Rows[e.CommandArgs].FindControl("drpDgTrType")).visible = true;
}

Well more or less.
Hope it helps.

Re: Image Button in Datagrid

SeaCrab23-Oct-09 4:04

SeaCrab

23-Oct-09 4:04

Use the following code:

Dim Cal As Calendar = CType(Dtgrd.Items(Dtgrd.EditItemIndex).FindControl("CalndrName"), Calendar)

Cal.Visible = True

Collapse/Expand functionality in a ListView with Groups

Lilia Drouot29-Jul-08 21:58

Lilia Drouot

29-Jul-08 21:58

Hi,
Is it possible to set a collapse/expand functionality in a ListView filled with ListViewGroups ?
Thanks,
Lilia

Re: Collapse/Expand functionality in a ListView with Groups

led mike30-Jul-08 5:24

led mike

30-Jul-08 5:24

Lilia Drouot wrote:
Is it possible to set a collapse/expand functionality in a ListView filled with ListViewGroups ?

Not that I am aware of. Have you considered using a PropertyGrid?

led mike

vb.NET programming error

kann.2729-Jul-08 21:51

kann.27

29-Jul-08 21:51

While i am executing the below query, i have "cann't find Table 0" ERROR.SO please rectify my errors.

Sub ReportInvoiceDetails(ByVal InvNo As String)
Try
Qry = "Select Invoice_Master.Im_InvNo,Invoice_Master.Im_InvDate, Invoice_Master.Im_JobCardno, Invoice_Master.Im_PartyName, Invoice_Master.Im_Address, Invoice_Master.Im_Reg, Invoice_Master.Im_Make, Invoice_Master.Im_Model, Invoice_Master.Im_Mileage, Invoice_Master.Im_Rono, Invoice_Master.Im_Payments,Invoice_Particulars.Ip_Sno,Invoice_Particulars.Ip_Desc,Invoice_Particulars.Ip_Qty,Invoice_Particulars.Ip_Rate,Invoice_Particulars.Ip_1amt,Invoice_Particulars.Ip_2amt,Invoice_Particulars.Ip_Labour,Invoice_Amount.Ia_Sub1, Invoice_Amount.Ia_Sub2, Invoice_Amount.Ia_Sub3, Invoice_Amount.Ia_Total, Invoice_Amount.Ia_Vatper, Invoice_Amount.Ia_VarAmt, Invoice_Amount.Ia_Gtotal FROM (Invoice_Master INNER JOIN Invoice_Particulars ON Invoice_Master.Im_InvNo = Invoice_Particulars.Ip_InvNo) INNER JOIN Invoice_Amount ON Invoice_Master.Im_InvNo = Invoice_Amount.Ia_InvNo WHERE Invoice_Master.Im_InvNo='" & InvNo & "' ORDER BY Invoice_Particulars.Ip_Sno "

'Qry = "select Invoice_Master.Im_InvNo,Invoice_Master.Im_JobCardno,Invoice_Master.Im_PartyName,Invoice_Master.Im_Address,Invoice_Master.Im_Address,Invoice_Master.Im_Reg,Invoice_Master.Im_Make,Invoice_Master.Im_Model,Invoice_Master.Im_Mileage,Invoice_Master.Im_Rono from Invoice_Master WHERE Invoice_Master.Im_InvNo='" & InvNo & "' "
'MessageBox.Show(Qry)
DsInvoice = objdal.returnDataset(Qry)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Try
Qry = "delete from Tbl_Temp"
objdal.ExeQuery(Qry)
Dim dsrowcount, col, i, j As Integer
dsrowcount = DsInvoice.Tables(0).Rows.Count
For i = 0 To dsrowcount - 1
Qry = "insert into Tbl_Temp(Im_InvNo,Im_InvDate,Im_JobCardno,Im_PartyName,Im_Address,Im_Reg,Im_Make,Im_Model,Im_Mileage,Im_Rono,Im_Payments,Ip_Sno,Ip_Desc,Ip_Qty,Ip_Rate,Ip_1amt,Ip_2amt,Ip_Labour,Ia_Sub1,Ia_Sub2,Ia_Sub3,Ia_Total,Ia_Vatper,Ia_VarAmt,Ia_Gtotal)values( LTRIM('" & DsInvoice.Tables(0).Rows(i)(0) & "'),LTRIM('" & DsInvoice.Tables(0).Rows(i)(1) & "'),'" & DsInvoice.Tables(0).Rows(i)(2) & "','" & DsInvoice.Tables(0).Rows(i)(3) & "','" & DsInvoice.Tables(0).Rows(i)(4) & "','" & DsInvoice.Tables(0).Rows(i)(5) & "','" & DsInvoice.Tables(0).Rows(i)(6) & "','" & DsInvoice.Tables(0).Rows(i)(7) & "','" & DsInvoice.Tables(0).Rows(i)(8) & "','" & DsInvoice.Tables(0).Rows(i)(9) & "','" & DsInvoice.Tables(0).Rows(i)(10) & "','" & DsInvoice.Tables(0).Rows(i)(11) & "','" & DsInvoice.Tables(0).Rows(i)(12) & "'," & DsInvoice.Tables(0).Rows(i)(13) & "," & DsInvoice.Tables(0).Rows(i)(14) & "," & DsInvoice.Tables(0).Rows(i)(15) & "," & DsInvoice.Tables(0).Rows(i)(16) & "," & DsInvoice.Tables(0).Rows(i)(17) & "," & DsInvoice.Tables(0).Rows(i)(18) & "," & DsInvoice.Tables(0).Rows(i)(19) & "," & DsInvoice.Tables(0).Rows(i)(20) & "," & DsInvoice.Tables(0).Rows(i)(21) & "," & DsInvoice.Tables(0).Rows(i)(22) & "," & DsInvoice.Tables(0).Rows(i)(23) & " )"

' MessageBox.Show(Qry)
objdal.ExeQuery(Qry)
Next

Qry = "Select * from Invoice_Master"
DsInvoiceNew = objdal.returnDataset(Qry)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub

Re: vb.NET programming error

unknown78930-Jul-08 0:33

unknown789

30-Jul-08 0:33

Qry = "delete from Tbl_Temp"

shouldn't be there some argument after delete ?
like: delete * from tbl_temp

Re: vb.NET programming error

Ashfield31-Jul-08 9:17

Ashfield

31-Jul-08 9:17

So where do you get the error? That should gve some clue.

Bob
Ashfield Consultants Ltd

Encrypting Passwords in .NET application

aspnet2.developer28-Jul-08 20:59

aspnet2.developer

28-Jul-08 20:59

Hi,

I am developing a Windows application which has login form where user can enter userid & password. The same will be checked against the database for verification.

I want to know how the password should be stored in database in Encrypted format? Also, how to retrive such encrypted data in WinForm?

I am currently using SQL 2005 as database. Later the database may changed to Oracle 10g. Will the database change affect the coding at UI level?

If anyone can give me any suggestions on the same, that would be great.

Thanks in advance

Re: Encrypting Passwords in .NET application

Rob Philpott28-Jul-08 22:41

Rob Philpott

28-Jul-08 22:41

A common way of doing this is by using a one-way hash on the password before storing in the database. You can use this:

FormsAuthentication.HashPasswordForStoringInConfigFile

to do that. When the user enters a password, its hashed again and the hashes are compared. Using this approach though, you can never get back to plain text password. If a user forgets it, a new one must be created.

Regards,
Rob Philpott.

Re: Encrypting Passwords in .NET application

supercat929-Jul-08 19:48

supercat9

29-Jul-08 19:48

What's the best way for an application to store credentials if they need to be recoverable (for transmission elsewhere)? One-way hashes are great if all the application has to do is validate credentials when they are re-entered. But what about when some other device will need the real credentials?

Re: Encrypting Passwords in .NET application

Mark Churchill30-Jul-08 17:12

Mark Churchill

30-Jul-08 17:12

You could use an encryption algorithm one-way on the "less secure" server, treating the result like you would a hash. Your "more secure" server could then decrypt a token from the "less secure" server to retrieve the password.

This lets you keep only the public half of the key on the "less secure" server. Presumably you'd also be salting the password, which the "more secure" server could ignore.

Mark Churchill
Director, Dunn & Churchill Pty Ltd
Free Download: Diamond Binding: The simple, powerful, reliable, and effective data layer toolkit for Visual Studio.

Alpha release: Entanglar: Transparant multiplayer framework for .Net games.

Re: Encrypting Passwords in .NET application

supercat930-Jul-08 18:22

supercat9

30-Jul-08 18:22

You could use an encryption algorithm one-way on the "less secure" server, treating the result like you would a hash. Your "more secure" server could then decrypt a token from the "less secure" server to retrieve the password.

You're suggesting using a public key cryptosystem, where the intended recipient of the key knows half of the key and the entity storing the key knows the other? That would be a nice approach if the recipient of the key could handle the public key cryptography. Unfortunately, the recipient has no such facilities. It needs the credentials (sent via serial port, not Internet) in clear form.

Security by Obscurity may be the only workable approach (the machine that will legitimately communicate with the recipient must have all the information an impostor would need) but there's still a huge gap between approaches that can be undone in five minutes with a disassembler and those that would take much longer. My guess is that any approach that would be hard to break would take impractically long to implement, but perhaps there are some good methods I don't know about.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.