vb.NET programming error - .NET (Core and Framework) Discussion Boards

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.

Re: Encrypting Passwords in .NET application [modified]

Yajnesh Narayan Behera30-Jul-08 20:19

Yajnesh Narayan Behera

30-Jul-08 20:19

In my project requirement was same as of your. There is two approach two encrypt as the code level & database level, but I took the code level approach. Although I am not an expert in this area would like to know whether my approach was correct or not also it may answer your query.

I used some class provided by .NET framework.

private static string Encrypt(string originalString)
{

 DESCryptoServiceProvider cryptoProvider = new DESCryptoServiceProvider();
 MemoryStream memoryStream = new MemoryStream();

 CryptoStream cryptoStream = new CryptoStream(memoryStream,  cryptoProvider.CreateEncryptor(bytes, bytes), CryptoStreamMode.Write);

 StreamWriter writer = new StreamWriter(cryptoStream);
 writer.Write(originalString);
 writer.Flush();
 cryptoStream.FlushFinalBlock();
 writer.Flush();

 return Convert.ToBase64String(memoryStream.GetBuffer(), 0, (int) memoryStream.Length);

}

Now the returned string is in encrypted format & can be inserted in the database.

modified on Thursday, July 31, 2008 2:33 AM

Re: Encrypting Passwords in .NET application

Mark Churchill30-Jul-08 20:54

Mark Churchill

30-Jul-08 20:54

What kind of timeframe do you need to hang on to the cleartext? Can you just hold it in memory for the duration of the session with the "less secure" server - handing it out to the serial box when necessary?

Otherwise if you have to persist it at all, then I agree with the obscurity approach - use some trivial encryption as a deterrant to someone who's ended up with a database backup tape but somehow not the whole app. Not that it should make you feel comfortable - obviously if the server is capable of retrieving the cleartext then it may as well be cleartext Wink | ;)

Create database from DBML file

Manuel Then28-Jul-08 5:47

Manuel Then

28-Jul-08 5:47

Some time ago I created a Linq2Sql DBML file. Now I want to create the same database on a test server without having access to the original DB. Is there any way to create the database from this file without doing it manually?

Thanks in advance.

Greetz!
M.T.

Re: Create database from DBML file

Sam Xavier31-Jul-08 18:48

Sam Xavier

31-Jul-08 18:48

Unfortunately, there is no way to create a database file from a DBML file.

Best Regards,
Sam Xavier
www.componentone.com

Re: Create database from DBML file

Manuel Then31-Jul-08 21:23

Manuel Then

31-Jul-08 21:23

Okay. Thanks Smile | :)

By now I already did it manually Wink | ;)

Greetz!
M.T.

Re: Create database from DBML file

MisterX4424-Mar-09 10:49

MisterX44

24-Mar-09 10:49

The generated ModelNameDataContext class has a CreateDatabase Method. This creates the database with the tables in the model.

Best regards,
MisterX44.

SqlServerCE and ASP.NET Configuration

hammerstein0528-Jul-08 3:51

hammerstein05

28-Jul-08 3:51

I can't quite decide where this belongs, because of what I'm trying to do. I'm not actually creating a website / webpage etc. so I'm not sure it belongs in ASP.NET forum, and I'm not actually trying to do anything (yet) with the database, so not SqlServer forum.

What I am trying to do is.... pass an ASP.NET webpage an XML message for it to then call a dll and create / populate / return and SqlServerCE datafile.

So far, I have the flag set to allow ASP.NET to work with Mobile databases, I've got that far. I've installed the .NET Framework 3.5 on the server, but when I try to make a call to an SqlCeConnection object, I get an error about not being able to find the assembly System.Data.SqlServerCe 3.5.0.0. What am I missing to be able to communicate?

Re: SqlServerCE and ASP.NET Configuration

led mike28-Jul-08 9:59

led mike

28-Jul-08 9:59

hammerstein05 wrote:
I get an error about not being able to find the assembly System.Data.SqlServerCe 3.5.0.0. What am I missing to be able to communicate?

The obvious answer based on your post is "the assembly". So either you don't have the correct version installed or your runtime environment isn't looking where you installed it. So I imagine some reading of the different parts of your runtime environment and how they locate assemblies. Keep security issues in mind as they can play into locating assemblies when it comes to things like using the GAC.

Also it's always a good idea to post the exact error message rather than your interpretation of it.

led mike

Re: SqlServerCE and ASP.NET Configuration

hammerstein0528-Jul-08 13:05

hammerstein05

28-Jul-08 13:05

The most obvious answer was indeed the answer. My understanding of the .NET framework grew a little today. In order to have the SqlServerCe assembly available, I didn't need to have the .NET Framework 3.5 installed, I need to have Sql Server Mobile 3.5 installed. With that installed, and the flag set in the ASP.NET script I'm now happily manipulating mobile databases. Just for the record though, I'm not trying to write ASP.NET websites using mobile databases, I understand the limitations. I'm using the pages to call from a mobile application.

problem writing a file on my desktop

unknown78928-Jul-08 2:48

unknown789

28-Jul-08 2:48

Hi,

I'm having a problem with writing a file on my desktop using VB.NET ...
I'm in a domain and the problem can be solved by running the program locally.
But I want it to run when I log on to my domain ...

It has something to do with the assemblies !!!

anybody who can help me to fix this problem ?
here is the link to the screenshot

http://www.plaatjesupload.nl/bekijk/2008/07/28/1217248063-140.jpg[^]

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