|
i have a table named emp.
where one coloumn named "status",
which doesnot take any value from the front end.i am storing its default valus as"ON" in the emp table which is set in its cloumn property .
and another table emp_detail where one column named "eligible".( both tables are related with each other by "emp_id" coloumn)where it takes the value from the frontend either "Y" or "N".now i want if the value for "eligible" is stored as "Y".then the corresponding record of that in the "emp"table should be updated that is only the "status " column set to be OFF.
where it takes the value from the frontend either "Y" or "N".
now i want if the value for "eligible" is stored as "Y".then the corresponding record of that in the "emp"table should be updated that is only the "status " column set to be OFF.
|
|
|
|
|
you can change the status while inseting the data in emp_detail table. Or you can create a triger on emp_detail table on insert and check the eligible column and update emp table as per value
Hardik Panchal
|
|
|
|
|
i dont know how to write trigger.but know the storeprocedure,so can let me know howto write the trigger for that
|
|
|
|
|
how cani change the status of the table. can you be little elaborate it. or if possible do write the code ..
or the trigger
|
|
|
|
|
i have a table named emp.
where one coloumn named "status",
which doesnot take any value from the front end.i am storing its default valus as"ON" in the emp table in the table .
and another table emp_detail where one column named "eligible".
( both tables are related with each other by "emp_id" coloumn)
where it takes the value from the frontend either "Y" or "N".
now i want if the value for "eligible" is stored as "Y".then the corresponding record of that in the "emp"table should be updated that is only the "status " column set to be OFF.
|
|
|
|
|
hi
i am designing a desktop application and a website. i have write the following code in desktop application but facing difficulty to do the same task in website.i am using grid to display data. in desktop application the Event "GridView1_CellClick" exist but in website i dont find it, can anyone tell me what changes to do with the follwing code to apply it in website
searchgrid.CurrentRow.Cells[0].Value;
Image1.Image = Image.FromFile(path);
protected void Page_Load(object sender, EventArgs e)
{
String strConnection;
strConnection = "server=localhost;User ID=sa;Password=sasa;database=rescue15";
SqlConnection conn = new SqlConnection(strConnection);
conn.Open();
string s = " SELECT cr_pic FROM criminal WHERE cr_id = " + searchgrid.CurrentRow.Cells[0].Value;
SqlCommand com1 = new SqlCommand(s, conn);
SqlDataReader dr1 = com1.ExecuteReader();
if (dr1.Read())
{
string path = dr1.GetValue(0).ToString();
Image1.Image = Image.FromFile(path);
}
dr1.Close();
}
}
i am using ASP.Net with C# and SQL Server2005
|
|
|
|
|
mavii wrote: Image1.Image = Image.FromFile(path);
This is a waste of time, it creates an image on the server. Generate an img tag which has a src attribute with the server path ( so not the file path, but the path as a URL that a browser can see )
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 )
|
|
|
|
|
actually i want to display the image of person according to his ID in the table, so in table i have saved the url, as i have used grid, when one clicks on the Grid, the ID in the first column of the grid is picked and image URL of that ID is taken from table which is diplayed in the picturebox.and i hv not any clear idea of server path, will u plz explain it?
|
|
|
|
|
If your ASP.NET app can see the file, then it must be within the web application. Sending c:\inetpub\MyApp\images\cgraus.jpg means nothing to the client. \images\cgraus/jpg will work fine, it's a path from the web root.
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 )
|
|
|
|
|
Hi,
I was wondering is there a way to create groups in session. so that if I needed to clear down session variables pertaining to a particualr section of our application, I could call Sesswion.Clear on that group, but leave all others intact?
Regards
Paul Custance
|
|
|
|
|
oceanexplorer wrote: is there a way to create groups in session
Upto my knowledge NO.
oceanexplorer wrote: so that if I needed to clear down session variables pertaining to a particualr section of our application, I could call Sesswion.Clear on that group,
You can do this using Arraylist or any other memory storage. So each of your section values are filled into ArrayList and store arraylist object to session. To remove a particular section data, simply do Session.Remove(your section name). So arraylist object contained in the specified location will be removed and others will still exist in the session.
|
|
|
|
|
Thanks for your help, much appreciated. I have decided to implement a Dictionary in order to create groups in session.
Regards
Paul
|
|
|
|
|
I show error messages via pop up windows.
at first there is no striction for blocking pop up windows.
after 3rd debugging, pop up blocker was automaticaly activated.
i deactived that, but i cant still see my pop ups
whyyy ?
|
|
|
|
|
Are you calling popup window in ASPX page or are you writing popup script to response from code behind ?
|
|
|
|
|
i use this code
Response.Write(<script language = ""Javascript"">var win=window.open('Message.aspx',null,'width=510,height=255,top=250,left=250','true');win.moveTo(0,0);</script>)
or
this one
Response.Write(<script language = ""Javascript"">var win=window.open('Message.aspx',null,'width=510,height=255,top=250,left=250','true');win.moveTo(0,0);</script>)<br />
response.redirect ("hi.aspx")
but both of them not run.
|
|
|
|
|
try executng this in your page,, this code will detect the pop blocker status
function detectPopupBlocker() {
var test = window.open(null,"","width=100,height=100");
try {
test.close();
alert("Pop-ups not blocked.");
} catch (e) {
alert("Pop-ups blocked.");
}
}
// Created by: Simon Willison
// http://simon.incutio.com/archive/2004/05/26/addLoadEvent
function addLoadEvent(func) {
var oldonload = window.onload;
if (typeof window.onload != 'function') {
window.onload = func;
} else {
window.onload = function() {
if (oldonload) {
oldonload();
}
func();
}
}
}
addLoadEvent(detectPopupBlocker);
winnie
|
|
|
|
|
Hi,
How can I use SSL in my ASP.NET eCommerce application? SSL is already installed in Web Server.
Please help me
Thanks
Regards
Nazeem
-- modified at 9:00 Thursday 23rd August, 2007
Mohamed Nazeem
Software Engineer
Bangalore
|
|
|
|
|
If IIS is set up, you need to just use HTTPS in your URL. Make sure all links away from the secure pages are absolute, otherwise people will keep using HTTPS on your site, which consumes more bandwidth, if nothing else.
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 )
|
|
|
|
|
Hi friends
I am working on Internal Search engine App.
I want to Highlight to Search keywords in the resulting text.
Thanks In advance
Pathan
---------------------------------------------------
|
|
|
|
|
You need to use CSS for this, each highlighted word needs to be in a div which is styled to have a different background color.
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 )
|
|
|
|
|
Thanks Christian for ur reply
i have done it using replace method of string.
Pathan
---------------------------------------------------
|
|
|
|
|
hi all,
there is a java application that uploads, manages and converts docs to other formats
in this application when a conversion is required a .net web service is consumed and completes the conversion process.
Now, for some reasons the web service needs to be changed so we have developed a new webservice using .net 1.1 and c# and workd fine when tested using a .net client.
We have changed the name of the webservice to the new one in the existing application but for some reasons the communication between the application and web service is not happening!
Is there something that we missed? I mean any steps to be followed while developing a webservice which should be used by java client?
Thanks,
gauthee
|
|
|
|
|
Did you change the web service definition (wsdl) at all?
|
|
|
|
|
Paddy,
I have not done any changes to WSDL!
gauthee
|
|
|
|
|
Hi All
I have one aspx page in which i am using one usercontrol 2 times Now the Problem is Even i am making one of 2 usercontrol Visible false then also its Page load event is calling
Can anyone please help me What i want is pretty simple if i don't want usercontrol in my page then its pageload method should not be called, I tried by making that user control visible false in page Oninit method but no use
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... "
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
