|
Hai frinedz,i want to populate data from Database in hirachary manner.
i have done up to 2level. but i dont know how to add one subchild in
the child node...can u plz do this with my existing code...
or tell me where should i add the code to a sub child under the child node.
here the parent node is -modulename
child node - componentname
& subchild node- function name.
in the sqlcommand you can put any sql....for ur conviennet .later on iwill change it according to my requirment.
plz do this favour on me.
i am using asp.net along with c# 2005 as front end and backend as sqlserver2005 as db
below i am giving u my code also..
======================================
<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
if (!IsPostBack)<br />
{<br />
PopulateRootLevel();<br />
}<br />
}<br />
<br />
void PopulateRootLevel()<br />
{<br />
<br />
SqlConnection SqlCon = new SqlConnection("Data<br />
Source=biswa;Initial Catalog=rwsNew;User ID=sa;Password=biswa007");<br />
Source=;Initial Catalog=rwsNew;User ID=;Password=");<br />
SqlCon.Open();<br />
SqlCommand SqlCmd = new SqlCommand("SELECT modulename,moduleid<br />
FROM module_master WHERE delflag='ACTIVE' ORDER BY modulename ",<br />
SqlCon);<br />
SqlDataReader Sdr = SqlCmd.ExecuteReader();<br />
SqlCmd.Dispose();<br />
string[,] ParentNode = new string[100, 2];<br />
int count = 0;<br />
while (Sdr.Read())<br />
{<br />
ParentNode[count, 0] =<br />
Sdr.GetValue(Sdr.GetOrdinal("moduleid")).ToString();<br />
ParentNode[count++, 1] =<br />
Sdr.GetValue(Sdr.GetOrdinal("modulename")).ToString();<br />
}<br />
Sdr.Close();<br />
for (int loop = 0; loop < count; loop++)<br />
{<br />
TreeNode root = new TreeNode();<br />
root.Text = ParentNode[loop, 1];<br />
root.Target = "_blank";<br />
//root.NavigateUrl = "Default.aspx";<br />
SqlCommand Module_SqlCmd = new SqlCommand("SELECT<br />
compid,componentname FROM module_component WHERE (moduleid = '" +<br />
ParentNode[loop, 0] + "') ", SqlCon);<br />
SqlDataReader Module_Sdr = Module_SqlCmd.ExecuteReader();<br />
while (Module_Sdr.Read())<br />
{<br />
TreeNode child = new TreeNode();<br />
child.Text =<br />
Module_Sdr.GetValue(Module_Sdr.GetOrdinal("componentname")).ToString();<br />
child.Target = "_blank";<br />
//child.NavigateUrl = "Default.aspx";<br />
root.ChildNodes.Add(child);<br />
}<br />
Module_Sdr.Close();<br />
TvMenu.Nodes.Add(root);<br />
}<br />
<br />
TvMenu.CollapseAll();<br />
SqlCon.Close();<br />
}<br />
thanks in advance 
|
|
|
|
|
We can have two Web.config in a project.
In the first Web.config; in appSetting u have one connection and in the second Web.config u have different connection. Which connection does the project work.
Regards,
LEE
|
|
|
|
|
1) First thing how can you put two files with the same name in a web root ?
2) Second. Why are you opting for such a method of putting connection string in two different files as you can always put any number of connection string in same file and refer then uniquely using the name.
Thanks
Laddie
Kindly rate if the answer was helpful
|
|
|
|
|
I am not using the web.config file in the same root. First web.config will be accessessed by the login and the second web.cofig in a specified folder where the connection is for that specified folder.
Regards,
LEE
|
|
|
|
|
I assume it will take only the one in the root. And when you run the application which one did it take ? 
Thanks
Laddie
Kindly rate if the answer was helpful
|
|
|
|
|
if u have web config in different folders then web config of particular folder override the root folder web config file
|
|
|
|
|
Hi
Does anyone know of a control that is a texbox that contains a
dropdownlist.
I need to be able to type into the textbox, if there are any matches
in the contained dropdownlist (matching on starting characters of the
list items) they are displayed in the popped out dropdownlist and the
user can select one. If there are no matches the list won't be
displayed and the control will just capture the users typed text (to
be written to a database).
Does anyone have/know of a control like this that I can use?
Thanks
|
|
|
|
|
There may be an ajax control in the ASP.NET library that does this.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi Christian,
Do you know any link?
Is it possible to implement this ajax concept in middle of the application development?
|
|
|
|
|
The ASP.NET AJAX library is easily found and downloaded if you look here[^].
Yes, you can add it any time you like.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
|
how to determine if a datagrid has any data using a custom validator?
|
|
|
|
|
Well, why would you use a validator, when you'll know before you render the page that there's no data. What are you trying to do ? A validator runs on input.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
can you be a bit elaborate your problem.
OK. I am giving a solution based on my previous problem if it fits ok.
function validateGridViewData()
{
rowCount = document.getElementById("gvProducts").rows.length;
if (rowCount >1)
return true;
return false;
}
And pass this function to the CustomValidator. Let me know does this solve your problem.
Intelligence is measured by common sense not by how many scholarly books you read.
|
|
|
|
|
I am using a GricView control which performs some operations on teh click of button or on clicking of a link button.
Now I have added an Update Panel but its not working, I mean I have putted the button in Update Panel.
Are some trigger is needed for the gridView? 
|
|
|
|
|
Hi
No did u enable partial rendering to true in scriptmanager?
thanks
|
|
|
|
|
yes, it is enabled by default.
Tell em one thing, am i doing a right way
I have putted one script manager
and putted the gridview into the update panel and in page load i have putted
this.ScriptManager1.RegisterAsyncPostBackControl(this.Button1);
code....
is it a ryt way?
|
|
|
|
|
Can
y this?
this.ScriptManager1.RegisterAsyncPostBackControl(this.Button1)
??
|
|
|
|
|
Since I have some events related to GridView like on the click of that button I am going to fill the Grid i.e. the events are related to the GridView on the button click
so i have to give this syntax....
I had read this somewhere
|
|
|
|
|
OK
I can prefer to u, when u have fill gridview with data ,please write a method for that and call with in the pre_render event.
And remove that button set to scriptmanager as Async mode button .
after that see.
thanks
|
|
|
|
|
|
I can prefer to u, when u have fill data to gridview ,please write a method for that and call that method within the pre_render event.
After that
And remove that button set line of code (already u written in the previous post)to scriptmanager as Async mode button.
thanks
|
|
|
|
|
yes i had a separate method say "FillGrid()" which I call at the button_click event...
but on prerender it will fill grid before rendering where does AJAX work?
I do not want to refresh teh page when i click the button and it fills the grid
|
|
|
|
|
I have written the following code in aspx page
<asp:scriptmanager id="ScriptManager1" runat="server">
<asp:updatepanel id="UpdatePanel1" runat="server" updatemode="Conditional">
<triggers> <asp:postbacktrigger controlid="Button1">
<%--<asp:asyncpostbacktrigger controlid="Button2" eventname="Click"> --%>
<contenttemplate>
<asp:gridview id="GridView1" runat="server" autogeneratecolumns="False" datakeynames="ID" datasourceid="SqlDataSource1">
<columns>--------------
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ------">
<asp:button id="Button1" runat="server" text="Button" onclick="Button1_Click">
and this is teh code on button click is used to perform some operations say fill grid
Now waht is the error in my code?
I m not getting what i m doing wrong?
|
|
|
|
|
salon wrote: I am using a GricView control which performs some operations on teh click of button or on clicking of a link button.
Take both control,Gridview and Button,in update panel,set Updatemode as conditional.
Do not need to register button so remove this line ...............RegisterAsyncPostBackControl(this.Button1);
OR.
take gridview in update panel and button is out of update panel,set Updatemode as conditional.
set trigger of button click event in update panel.
please don't forget to vote on the post that helped you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
