|
i made a stored procedure.there i wrote the select query and then i code behind file , i wrote the following code.
SqlConnection con;
con = new SqlConnection("connectionstring");
con.Open();
DataSet ds;
ds = new DataSet();
SqlDataAdapter ad;
ad = new SqlDataAdapter("waste");
ad.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
then i added the indert query in the same procedure with the select statement .
problem is in the same function i have to implement the insert query as well as the select query.
using the sqlcommand i passed the parameters.
but how to show the exsiting records
Soniagupta1@yahoo.co.in
|
|
|
|
|
Hello friends..I got following error in as site..
The type or namespace name 'Dbprocess' could not be found (are you missing a using directive or an assembly reference?)
What is the procedure to add reference to your project..Is it necessary to upload dbprocess file in bin folder
|
|
|
|
|
This 'Dbprocess' class file is a part of your webproject or it is in seperate class library project?
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
|
|
|
|
|
The Dbprocess class file is put in DBLibrary.dll file and the reference is added to my project. Everything runs fine on local but gives error on server...What is the solution for this..
|
|
|
|
|
Ok I suppose that DBLibrary.dll is Compiled without including the DBProcess class file. To verify this --
Go to Visual Studio .NET command prompt and
Run this Command -- ILDASM
this will open the Intermediate Language Disassembler where you can see all the list of class files included in your DBLibrary.dll. In the list just check DBProcess class file is available or not. If not available then you will have open the DBLibrary class library project and Include the DBProcess class file, compile it, then put the latest build in your BIN folder and reference it.
Regards
J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
Yes Sir You are right ..In The MSIL Disassembler no class file is found..But the class file is present in the DBLibrary project..Is it necessary to include class file in app_code folder...?
|
|
|
|
|
Amit.Jagtap wrote: But the class file is present in the DBLibrary project
Amit.Jagtap wrote: Is it necessary to include class file in app_code folder...?
IF DBLibrary is a seperate class library project and Your DBProcess is a class file part of your DBLibrary then there is no need to include class file in app_code folder.
Amit.Jagtap wrote: Yes Sir You are right ..In The MSIL Disassembler no class file is found..
Did you Do this?
J O N wrote: If not available then you will have to open the DBLibrary class library project and Include the DBProcess class file, compile it, then put the latest build in your BIN folder and reference it.
Also check in the ILDASM by opening the .dll file...
Make sure that class is available...
Regards
J O H N ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
"Even eagles need a push." David McNally
|
|
|
|
|
Is it necessary to publish a web site before uploading?
|
|
|
|
|
Amit.Jagtap wrote: Is it necessary to publish a web site before uploading?
This question seems to be bit confusing...
As far as I know -- Uploading a site to a server is Publishing a website in a webserver.
Uploading (Publishing)
Regards
J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
A file can be physical present in the location but may not be actually Included in the project. It has to be explicitly Included in you project (By anychance if it is excluded from the Project for any reason)
Regards
J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
Is it necessary to publish and/or deploy a site before uploading?
|
|
|
|
|
I have a data view and need to get the index of a search value in one of its column .
How can i do it without using for loop ....
Is there some way IndexOf() can be used on a column .....
|
|
|
|
|
Iam having a Employee Form which contains Employee Details and Employee Photo which should be stored in the Oracle table with the Employee Information and while modifying the Data it should be retrieved to the Employee's form
Main things are
All the Photos will be stored in a folder which should be retrieved by the Employee Number.
and how to store the information as well as image into Oracle database.
Next retrieving that info info and image to ASP.Net2.0
thank u in advance
Priya
|
|
|
|
|
Hi priya actuly I don't know it for oracle but i had done it in sql server ok. If u can convert then try to it into oracle. ok
I am explaining step by step.
1. just set datatype as a binary (or somewhat like which support binary data into oracle)of photo field in database.
2. Now convert your employees image into binary using below code.
//For Image storing into database after converting into binary.
// This code is writen in C#.NET.
byte[] binary = null;
if (FileUpload1.HasFile)
{
binary = new byte[FileUpload1.PostedFile.ContentLength];
binary = FileUpload1.FileBytes;
}
// Below line is command parameter it will used while u are inserting data using stored procedure
Cmd.Parameters.AddWithValue("@U_Photo", binary);//Photo
3. The above code will convert into binary and stored it into database.
4. Now retriving it back from database
//For retriving image from database and place into image control
//Below code is function named RetrievedImage()
// put this code into differnt page and set this page as a Image1.ImageUrl(thispage.aspx? pid='pid')
// and Image1 will place on your edit employee page. Ok
private System.Drawing.Image RetrieveImage(int pid)
{
System.Drawing.Image image = null;
try
{
strcon = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
Con = new SqlConnection(strcon);
Con.Open();
Cmd = new SqlCommand("SELECT Photo_Field FROM table_Name where phot_Id='" + pid + "'", Con);
Cmd.CommandType = CommandType.Text;
SqlDataReader Dr = Cmd.ExecuteReader();
if (Dr.Read())
{
byte[] imageData = (byte[])Dr["U_Photo"];
MemoryStream memStream = new MemoryStream(imageData);
image = System.Drawing.Image.FromStream(memStream);
}
}
catch (Exception ex)
{
Session["Error"] = ex.Message.ToString();
}
return image;
}
I hope it will work fine. All the best.
|
|
|
|
|
How can we write textbox keypress event in Asp.net
thanx in advance
prabumj@gmail.com
|
|
|
|
|
DO you want it in javascript or server side
in javacsript Register the client script
TextBoxId.Attributes.Add("OnClick", "javascript:yourfunctionName");
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
can u help me in how to include Javascript Function of keypress in asp.net.
Thanx
prabumj@gmail.com
-- modified at 2:20 Monday 24th September, 2007
|
|
|
|
|
prabumjkaran wrote: how to include Javascript Function of keypress in asp.net
write this on the server-side to bind the javascript function to the OnKeypress event of the textBox.
txtBox.Attributes.Add("onKeyPress", "Myfunction();")
here is a sample client-side javascript function to include in .js file or you can include in the HTML part of the aspx page within the block...
<code>function Myfunction(){
if(event.keyCode == somevalue)
//put your code
}</code>
<div class="ForumSig"><FONT face=verdana color=brown size=2>Regards<BR><FONT face=verdana color=brown size=1><b>J O H N ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif) </b><BR>
"Even eagles need a push." <b>David McNally </b><HR size=1></div>
|
|
|
|
|
prabumjkaran wrote: How can we write textbox keypress event in Asp.net
Sandeep Akhare wrote: TextBoxId.Attributes.Add("OnClick", "javascript:yourfunctionName");
just to set the record straight...
TextBoxId.Attributes.Add("OnKeyPress", "javascript:yourfunctionName");
Regards
J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
OOPs i interpret as mouse click :->:->
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
|
You can try with Sql Server Agent and the extended stored procedure xp_sendmail.
Set up a job through Sql Server agent that wakes up and check's at proper intervals whether any job to be served ( any notification mails to be sent).
Regards
J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
|
hai i m new to asp.net, which ctrl is best to use Html / Server
eg i want to add text box ,for that HTML is best or Server ctrl is best
thanx
prabumj@gmail.com
|
|
|
|
|
If one was better than the other in all cases, we wouldn't have them both.
server controls are useful where you want the framework to remember the value of a control when a postback occurs ( as in, when someone clicks a button, etc )
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 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
