|
hi
pls help me urgently
Gayatri
|
|
|
|
|
it seems something sort of byte[] (like an image field).
so my suggestion is convert it first into byte[]
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
give me a convert syntax like this UserCode.
(" + Convert.ToInt32(txtUserCode.Text) + " ,
" + " ' " + txtPassword.Text + " ' " + ")
Gayatri
|
|
|
|
|
Hi,
you can do from this way..
string myByte = "Stingtest";<br />
System.Text.ASCIIEncoding encoding=new System.Text.ASCIIEncoding();<br />
Byte[] bytes = encoding.GetBytes(myByte);<br />
<br />
myByte = "";<br />
myByte = encoding.GetString(bytes);
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
hi
i am using asp.net 2.0 with c#.
and my database is MSSQL server in that i have tuser table in that
i have password feild which datatype is Binary.
i have following code
strSqlCmdText = "insert into tUser values( " + Convert.ToInt32(txtUserCode.Text) + " , "+
" " + " ' " + txtUserID.Text + " ' " + "," + " ' " + txtFirstName.Text + " ' " + ", "+
" " + " '" + txtLastName.Text + "'" + "," + " ' " + txtPassword.Text + " ' " + ", "+
" " + "'" + txtUserType.Text + "'" + ", "+
" " + "'" + dtpWarningDate.SelectedDate + "'" + " , "+
" " + "'" + dtpExpireDate.SelectedDate + "'" + ", "+
" " + "'" + drpdwnStatus.SelectedItem.Text + "'" + ", "+
" " + "'" + Session["LoginName"].ToString() + "'" + ", "+
" " + "'" + dtpCreateDate.SelectedDate.ToString() + "'" + ", "+
" " + "'" + txtUpDatedBy.Text + "'" + ", "+
" " + "'" + dtpUpdateDate.SelectedDate.ToString() + "'" + ")";
objClsDllSql.funSqlCmd(strSqlCmdText);
when it run that time following error is comming===========
Disallowed implicit conversion from data type varchar to data type binary, table 'eSRS.gayatri.tUser', column 'Password'. Use the CONVERT function to run this query.
pls help me.
Gayatri
|
|
|
|
|
Hi,
I think you didnt see whatever I wrote....
niki_nilu wrote: strSqlCmdText = "insert into tUser values( " + Convert.ToInt32(txtUserCode.Text) + " , "+
" " + " ' " + txtUserID.Text + " ' " + "," + " ' " + txtFirstName.Text + " ' " + ", "+
" " + " '" + txtLastName.Text + "'" + "," + " ' " + txtPassword.Text + " ' " + ", "+
" " + "'" + txtUserType.Text + "'" + ", "+
" " + "'" + dtpWarningDate.SelectedDate + "'" + " , "+
" " + "'" + dtpExpireDate.SelectedDate + "'" + ", "+
" " + "'" + drpdwnStatus.SelectedItem.Text + "'" + ", "+
" " + "'" + Session["LoginName"].ToString() + "'" + ", "+
" " + "'" + dtpCreateDate.SelectedDate.ToString() + "'" + ", "+
" " + "'" + txtUpDatedBy.Text + "'" + ", "+
" " + "'" + dtpUpdateDate.SelectedDate.ToString() + "'" + ")";
change it..
strSqlCmdText = "insert into tUser values( " + Convert.ToInt32(txtUserCode.Text) + " , "+ <br />
" " + " ' " + txtUserID.Text + " ' " + "," + " ' " + txtFirstName.Text + " ' " + ", "+<br />
" " + " '" + txtLastName.Text + "'" + "," + " ' " + Convert string into binary here.. + " ' " + ", "+ <br />
" " + "'" + txtUserType.Text + "'" + ", "+ <br />
" " + "'" + dtpWarningDate.SelectedDate + "'" + " , "+ <br />
" " + "'" + dtpExpireDate.SelectedDate + "'" + ", "+<br />
" " + "'" + drpdwnStatus.SelectedItem.Text + "'" + ", "+<br />
" " + "'" + Session["LoginName"].ToString() + "'" + ", "+<br />
" " + "'" + dtpCreateDate.SelectedDate.ToString() + "'" + ", "+<br />
" " + "'" + txtUpDatedBy.Text + "'" + ", "+<br />
" " + "'" + dtpUpdateDate.SelectedDate.ToString() + "'" + ")"; <br />
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
thanku
yes it is .
but give me a syntax in asp.net 2.0 with c#
Convert string into binary here.. i want syntax.
pls give me it
thanku
Gayatri
|
|
|
|
|
sir
pls give me a syntax in asp.net 2.0 with c#
Convert string into binary here.. i want syntax.
pls give me it
thanku
Gayatri
|
|
|
|
|
niki_nilu wrote: strSqlCmdText = "insert into tUser values( " + Convert.ToInt32(txtUserCode.Text) + " , "+
" " + " ' " + txtUserID.Text + " ' " + "," + " ' " + txtFirstName.Text + " ' " + ", "+
" " + " '" + txtLastName.Text + "'" + "," + " ' " + txtPassword.Text + " ' " + ", "+
" " + "'" + txtUserType.Text + "'" + ", "+
" " + "'" + dtpWarningDate.SelectedDate + "'" + " , "+
" " + "'" + dtpExpireDate.SelectedDate + "'" + ", "+
" " + "'" + drpdwnStatus.SelectedItem.Text + "'" + ", "+
" " + "'" + Session["LoginName"].ToString() + "'" + ", "+
" " + "'" + dtpCreateDate.SelectedDate.ToString() + "'" + ", "+
" " + "'" + txtUpDatedBy.Text + "'" + ", "+
" " + "'" + dtpUpdateDate.SelectedDate.ToString() + "'" + ")";
Ohhhh SQL Injection attack[^]. Check this and try to change your code
|
|
|
|
|
Try it like this :
string myByte = "Stingtest";
System.Text.ASCIIEncoding encoding=new System.Text.ASCIIEncoding();
Byte[] bytes = encoding.GetBytes(myByte);
myByte = "";
myByte = encoding.GetString(bytes);
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
is there is any code to change the tool tip styles
|
|
|
|
|
jagadeeshkumar2106 wrote: Is there any code to change the tool tip styles
I think you probably need to use the custom tooltip control or DIV with javascript.
|
|
|
|
|
sir will u help wiht code in this regard
|
|
|
|
|
You can google with those keywords "Javascript tooltip" or "asp.net ajax tooltip"
|
|
|
|
|
|
Hi all,
I have developed an application comprising classic ASP and ASP.NET 2.0. I have used frames in asp to call .NET pages. Its working fine on my local macine but when i uploaded it to the server it gives me yhe foll error
"Unrecognized configuration section 'connectionStrings'"
I also checked the ASP.NET tab in IIS and its alraedy set to 2.0. What can be the problem???? I have also restarted the server but no gain. Pls help!!!!!
When you fail to plan, you are planning to fail.
|
|
|
|
|
www.Developerof.NET wrote: "Unrecognized configuration section 'connectionStrings'"
I would like to suggest you to do some possibilities.
1. Please check the ASP.NET version both "Default Website" and "Individual Virtual Directory"
2. Instead of uploading your project, you should create very sample project and upload it on the server. And see whether it is working or not.
3. Find the differences between the global web.config or machine.config of your server and the machine that you said it works.
|
|
|
|
|
following is the regular expression which i a using for the whole numbers and fractionl numbers(1 , 2 , 9999 , 3.9 , .8 , .09)
[0-9]*.[0-9]*
when i tested for the 1s it did not occur any error
Please help
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
modified on Thursday, December 27, 2007 11:55:07 PM
|
|
|
|
|
Hi..
Try this
[0-9]*[.][0-9]*
Aswini
|
|
|
|
|
ThanQ.
I wanted that textbox can accept both whole numbers as well as te fractional numbers
The expression , which u provided , excepts only fractional values
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
here is ur solution,
"^[1-9]+[0-9]*(\.{1}[0-9]+)?"
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
sulabh2020 wrote: ^[1-9]+[0-9]*(\.{1}[0-9]+)?
This is incorrect for the expected problem. This will fail to match 0.25 , 25.2255255555555555s. If any text characters appeared in between the number, this expression will match the number part. If won't fail when character appears in between.
|
|
|
|
|
Sonia Gupta wrote: I wanted that textbox can accept both whole numbers as well as te fractional numbers
\b[\d]+$|\A([\d]+[\.]{1}[\d]+$|[\.]{1}[\d]+$) This accepts the following patterns
17.12
.12
0.25
etc..
|
|
|
|
|
Navaneeth , i want the basic book for regular expressions.Can u please refer me any one , a very basic especially for regular expressions.U know the expression u gave, i am not being able to understand it.
If u can make me understand this term .
ThanQ
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Sonia Gupta wrote: Navaneeth , i want the basic book for regular expressions.Can u please refer me any one
I don't know any good books for regular expression. You can try RegExBuddy. It's good program which helps to write regular expressions.
Sonia Gupta wrote: If u can make me understand this term .
I will try. Following is the explanation for above regular expression. I will split the above expression into small expressions, that is easy to understand.
\b[\d]+$ : This matches any digit in between 0-9 unlimited times. So matches all 12 , 1234 , 12345 etc. This won't match 125s or s584. So real number part is done. Now we need expression for fractional numbers. Bear it in mind, fractional numbers could be written in two ways, 12.32 and .32. Below is the expression which matches fractional numbers.
\A([\d]+[\.]{1}[\d]+$|[\.]{1}[\d]+$) : This contains two nested expressions for two types of fractional numbers. First one is ([\d]+[\.]{1}[\d]+$ : which matches 0.25 , 12.25 etc. This fails to match .25 , 0..25.
[\.]{1}[\d]+$) this is the second nested expression which matches any number starts with . symbol (.123,.87). These two expressions are combined using or(|) operator. SO if first one fails, regex engine will look for a match with second one.
In the same way these two expressions are combined with the first expression using another or operator. So regex engine will look for a real number without any decimal points first. If that one fails, it will enter into the second expression. Second expression is nested, so it will look for match with the first regex, and when it fails it will move to second. If all these fails, entire expression will be failed.
\A Asserts position at the beginning
$ Asserts position at the end
Hope it helps
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
