|
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
|
|
|
|
|
|
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
|
|
|
|
|
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,
HR
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Use the following code:
Dim Cal As Calendar = CType(Dtgrd.Items(Dtgrd.EditItemIndex).FindControl("CalndrName"), Calendar)
Cal.Visible = True
|
|
|
|
|
Hi,
Is it possible to set a collapse/expand functionality in a ListView filled with ListViewGroups ?
Thanks,
Lilia
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Qry = "delete from Tbl_Temp"
shouldn't be there some argument after delete ?
like: delete * from tbl_temp
|
|
|
|
|
So where do you get the error? That should gve some clue.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
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
HR
|
|
|
|
|
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.
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Hi
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.
|
|
|
|
|