|
divya.narayan wrote: Can I know the steps
Well, this is a decent approach. 
You have to put text boxes and required buttons. For inserting into database you need
1 - SQLConnection instance
2 - SQLCommand instance
Call ExecuteNonQuery() method to insert data into database. After inserting fetch the data from database and bind it to the grid. For edit link, use TemplateColumn and link to another page where these data's are shown for editing.
These kind of questions are very basic, why don't you buy a good book and learn it your self, and post the problems you got here.
|
|
|
|
|
i have webfarm mode and i have more then one server.
i have one fileupload control how it will upload the file on server in file structure.
|
|
|
|
|
Write code to get data from the database on OnSelectedIndexChanged Event of DropDownList and Pass the selected value of dropDownList into storeProcedure.
You will get dataset.Assign ds to DataSource of Gridview and call DataBind Method of Gridview.
divya.narayan wrote: to edit,update and delete the records
get it http://aspalliance.com/47
best regard
pathan
please don't forget to vote on the post that helped you.
|
|
|
|
|
<%@ page contentType="text/html;charset=windows-1252"%>
<%@ page import ="java.sql.*" %>
<%@ page import ="javax.sql.*" %>
<%@ page import ="javax.naming.InitialContext" %>
<%@ page import ="java.sql.PreparedStatement.*" %>
<%
try
{
int up1=Integer.parseInt(request.getParameter("num"));
String up2=request.getParameter("attach");
java.io.File f=new java.io.File("up2");
java.io.FileInputStream fis= new java.io.FileInputStream(f);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:balaji", "admin","qsg");
PreparedStatement pst=con.prepareStatement("insert into upload values(?,?)");
pst.setInt(1,up1);
pst.setBinaryStream(2,fis,(int)f.length());
pst.executeUpdate();
pst.close();
con.close();
%>
File Uploaded Successfull
<%
}
catch(Exception e)
{
%>
File Does not Uploaded
<%
}
%>
this source code is for saving an uploaded image into a database uaing java how we convert it into local sql database query
|
|
|
|
|
how to upload an image file into sql database using javascript
|
|
|
|
|
SreejithAchutan wrote: upload an image file into sql database
Do you want to store image or just image path?
SreejithAchutan wrote: using javascript
please be clear your question.
best regard
pathan
please don't forget to vote on the post that helped you.
|
|
|
|
|
I want to store the image into the database as binary value .but the uploading will be done using javascript
|
|
|
|
|
|
do one thing...
are u maintaining user rights in database? if yes
create one session(assume it as Session["permissions"]) for user permissions. At the time of login retreive the user rights from database & store in the Session["permissions"].
Now, for each page load check with the permissions & accordingly set the control Read/write or Enable or Disable properties.
hope this will give u a solution. 
Ramana
|
|
|
|
|
Hi Ramana!
thank you for reply.
Ramana. G.V wrote: create one session(assume it as Session["permissions"]) for user permissions. At the time of login retreive the user rights from database & store in the Session["permissions"].
I have totaly 25 different section with reports. so user can navigate to any section.In different section user have different permission of Read/Write. So How can I store so much session??? It will increase load........so plz adviced me another solution for this.......
Thank you again for your kind help.......
Keep Smiling
|
|
|
|
|
again do one thing...
retrieve all the Read/write permissions from the DB & maintain different key-value in NameValueCollection object, store this NameValueColleciton object in the session...
got it....? then proceed.
Ramana
|
|
|
|
|
Thank You for reply
Keep Smiling
|
|
|
|
|
Hi i like to store the following string in my table one of the field...,
This is that string:
Test <br>hi
So i given like this one string in my textbox...,
But its giving error as:
"A potentially dangerous Request.Form value was detected from the client (txtaddress="Test <br>hi"). "
How to solve this one...,
Pl help me to save my input like that format...,
Regards,
Magi
|
|
|
|
|
hi
try like
string st="test<br>hi";
txtaddress.text=Server.HtmlDecode(st);
Jintal Patel
|
|
|
|
|
Hi jintal,
Thanks for ur reply,
But i am getting same error,
I am using backend code as vb.net
Regards,
Magi
|
|
|
|
|
This is due to asp.net pre-processing the posted content to check for dubious content, such as html tags.
You can disable this validation by adding ValidateRequest="false" to your page tag, but should read up on the security implications of doing this before hand.
Cheers
Ben
|
|
|
|
|
I'm trying to implement a treeview without the expand/collapse +/- on the left of the nodes. When a parent node is clicked on, it displays the child nodes. The treeview must load from a web.sitemap. I couldn't find a solution with the built in asp:treeview options so I came up with this solution which works ok. The problem is the postbacks cause the whole page to be recreated everytime. I was wondering if someone could point me in the right direction in a way to implement this without postbacks. Appreciate it.
Here is my code in the aspx.
< asp:TreeView <br />
ID="TreeView"<br />
runat="server"<br />
OnSelectedNodeChanged="TreeView_SelectedNodeChanged"<br />
ShowExpandCollapse="false" ><br />
</asp:TreeView><br />
<asp:SiteMapDataSource ID="SiteMapDataSource" runat="server" ShowStartingNode="false" />
Here is my code in the aspx.cs.
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
TreeView.ExpandDepth = 0;<br />
TreeView.DataSource = SiteMapDataSource;<br />
TreeView.DataBind();<br />
SetTreeNodeSelectAction(TreeView.Nodes);<br />
}<br />
<br />
void SetTreeNodeSelectAction(TreeNodeCollection nodes)<br />
{<br />
foreach(TreeNode node in nodes)<br />
{<br />
node.SelectAction = TreeNodeSelectAction.Select;<br />
SetTreeNodeSelectAction(node.ChildNodes);<br />
}<br />
}<br />
<br />
protected void TreeView_SelectedNodeChanged(object sender, EventArgs e)<br />
{<br />
if (TreeView.SelectedNode == null) return;<br />
TreeView.CollapseAll();<br />
TreeView.SelectedNode.Expand();<br />
}
|
|
|
|
|
|
By default set the value of selectaction property of each node as none
Thanks,
Srikanth
|
|
|
|
|
no,can i get the answer of my question.please it is urgent
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: no,can i get the answer of my question.please it is urgent
Sorry, I am VC++ developer.. with very less or no knowledge of asp.net . your name remind me of someone.. so i asked you that question. sorry, if i had troubled/hurted you.
Sonia Gupta wrote: Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
don't put your email in public.. you could become victim of spam!
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
Support CRY- Child Relief and You
|
|
|
|
|
Using membership&role feature in asp.net 2.0 create an aspnet db,
can I use this db for my tables also?
|
|
|
|
|
Yes, as long as you don't change the created ones (unless you want to implement a custom provider).
Cheers
Ben
|
|
|
|
|
I am asking in that way when my web has other tables for ex. Customers or Clients ...
In this way, Can I store tables (Customers, Clients etc) in aspnetdb?
Thanks in advance
|
|
|
|
|
The answer is that you can, the bigger question is whether you should. I'd be inclined to separate out your business data from your security data.
Is there an issue with deploying a second database in the environment?
Ben
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
I have to make checking for per page(on page load) that login user has specific permission????.
.... I have lots of pages...please help me...