|
i know the cursors and triggers . but can u tell me the real life situation when i can implement these things in asp.net. I mean so far i implemented tables , views , stored procedure , functions in languages
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: i know the cursors and triggers . but can u tell me the real life situation when i can implement these things in asp.net. I mean so far i implemented tables , views , stored procedure , functions in languages
It can't be Implemented in asp.net...
Regards
J O H N ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
"Even eagles need a push." David McNally
|
|
|
|
|
well cool answers.... Thanks.
if u change the point of view to some technical aspects (I mean cursors and triggers interaction with languages)
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: but can u tell me the real life situation when i can implement these things in asp.net.
Never. cursors, triggers, tables, views and stored procs have nothing to do with ASP.NET, they relate to SQL.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
can i use the reference parameteres in the sql user defined functions.
actuallty i wanted to retrieve two values from the function.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
This is a SQL question, you should ask it in the SQL forum.
Did you buy that book yet ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I have the following code (works fine in .NET 1.x) which I believe expects to get the connectionstring from the key-value pair within <appSettings>...</appSettings> block in my web.config file. But I'm using .NET 2.0 now and all of my connection strings are within <connectionstrings>...</connectionstrings> block. How can I convert this line:
string strConnexn = SecureConnection.GetCnxString("cnxNWSecure");
to read my connectionstring from <connectionstrings>...</connectionstrings> block and not from <appsettings>...</appsettings>.
I'm familiar with the following in .NET 2.0 which doesn't involve string encryption & decryption:
string strConnexn = ConfigurationManager.ConnectionStrings["cnxNonSecure"].ToString()
What I'm looking for is something that works for secure connection.
Here's a chunk of code from a function for your review:
...
try
{
// Grab the encrypted connection string and decrypt it
string strConnexn = SecureConnection.GetCnxString("cnxNWSecure");
// Establish DB connection
using(SqlConnection cnxString = new SqlConnection(strConnexn))
{
cnxString.Open();
// Perform operation
...
}
...
Thank you in advance for your advice and support.
Anjani K Shiwakoti
Computer programs and social cultures are the same.
-- modified at 4:48 Saturday 6th October, 2007
|
|
|
|
|
i was using stored procedures in the asp.net and in the stored procedure i am using functions there in the stored procedure i wrote the following line to call he function
@itemid int,
@subitemid int,
@SSubItemId int,
@typeMasterid int,
@subtypeMasterid int
declare @lifeid int
set @lifeid = 0
@lifeid = FLifeId(@itemid,@subitemid,@SSubItemId,@typeMasterid,@subtypeMasterid)
and error occured
incorrect systax near @lifeid
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: set @lifeid = 0
@lifeid = FLifeId(@itemid,@subitemid,@SSubItemId,@typeMasterid,@subtypeMasterid)
set @lifeid = FLifeId(@itemid,@subitemid,@SSubItemId,@typeMasterid,@subtypeMasterid)
bEST rEGARD
pATHAN
please don't forget to vote on the post that helped you.
|
|
|
|
|
now the error is flifeid is not the recognized function name , but it exist in the database, i created a user defined function name
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
it was dbo which was needed to be appended with ehe table name.
well Thanks , the problem is solved.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
It depresses me how few people who use these forums have any idea what ASP.NET is, and is not.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Christian Graus wrote: It depresses me how few people who use these forums have any idea what ASP.NET is, and is not.
Sad but true.
But it could be worse: imagine that these people (with the same knowledge about their occupation) would work on a field that could harm people 
-^-^-^-^-^-
no risk no funk ................... please vote ------>
|
|
|
|
|
Hello Everyone,
I've stored images in the database and now i want to display them in the grid...
Can anybody tell me how it is done in ASP.NET1.1 .......
|
|
|
|
|
Have you stored path of Images in the database?
bEST rEGARD
pATHAN
please don't forget to vote on the post that helped you.
|
|
|
|
|
No actually i'm storing the images directly in the database
and now i want to fetch all the images stored in the database into the datagrid........
|
|
|
|
|
Get it aspalliance.com
bEST rEGARD
pATHAN
please don't forget to vote on the post that helped you.
|
|
|
|
|
|
Friend,
I've stored the path of the images in my database but i'm not getting how to show the images in the datagrid. And further i've also taken template to show the images in the grid......
Plz letme know how to do it......
|
|
|
|
|
Add a image filed from Editcolum section
provide in Data Section : DataImageUrlFiled= <database filed name>
This is sample code !!!!
-------- This section inside grid view ----------
here pic_name is the filed name of ur database image path
<asp:ImageField DataImageUrlField="pic_name" HeaderText="Image" ReadOnly="True" >
<asp:SqlDataSource ID="SqlDataSource1" runat="server" SelectCommand="SELECT * FROM [Page_table] WHERE [page_id] = @page_id"
</asp:SqlDataSource>
---------------------------------------------------
Hope now u can understand .... if u have still any problem let me know !!!!
Happy Programming
-----
Abhijit
|
|
|
|
|
|
1 file.SaveAs("F://images/" + file.GetName(), true);
this was successfully stored in folder
but
2 SqlCommand sqlcmd = new SqlCommand("insert into tblCategories (CatImage) values (@CatImage)", sqlcon);
sqlcmd.Parameters.Add("@CatImage", file.GetName ());
sqlcmd.ExecuteNonQuery();
here
error:nvarchar is incompatible with image
I gave datatype for CatImage is image.
so wat i have to do.
regards
kishore
|
|
|
|
|
I wrote a longer answer but the forums crashed and IE lost it.
the error means what it says. Try reading a book on SQL instead of making a wild guess. You're passing a string into a field and instead of a string (nvarchar), it's an image (binary data). Fix your data types, in accordance with your error message, and it will be fine.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I want to do write protect a drive to all system users using Vb dot net. For that i am using the below code. But I am getting Deny permission for the "special Permission" of the selected Drive. Not for the write permission.
Please see the below code.
======================================================
Dim folderLocation As String = "F:"
Dim mydir As New DirectoryInfo(folderlocation)
Dim dirsecurity As DirectorySecurity = mydir.GetAccessControl
Dim fsec As FileSecurity
Dim domain As String = LCase(Environment.UserDomainName)
Dim username As String = Environment.UserName
Dim Drive As String = "F:"
fsec = File.GetAccessControl(Drive)
For Each rule As FileSystemAccessRule In dirsecurity.GetAccessRules(True, True, GetType(NTAccount))
username = rule.IdentityReference.ToString()
MsgBox(".[" + username + "]")
fsec.SetAccessRule(New FileSystemAccessRule(username, FileSystemRights.WriteData, AccessControlType.Deny))
File.SetAccessControl(Drive, fsec)
Next
==================================================
I want to that am i doing proper method or not. if not please suggest the correct way to me for doing the write protect a single drive .
Gopi Ramanathan,
Life will never be the SAME
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)