|
public void Execute(string procName, List<SqlParameter> paramerters)
{
using(SqlConnection conn = new SqlConnection(...))
using(SqlCommand cmd = new SqlCommand(procName, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddRange(paramerters.ToArray());
cmd.ExecuteNonQuery();
}
}
You could also use libraries such as Enterprise Library Data Access Application Block[^]
Also, note how the code snippet above was formatted. Next time you try it.
Failure is not an option; it's the default selection.
|
|
|
|
|
Here is what I come up with however I have isssue with adding AddRange. Could you tell me what I am doing incorrect? Where would I list my params DB type?
Public Function GetData(ByVal SQLProcedure As String, Optional ByVal SQLParams As List(Of Parameter) = Nothing) As DataTable
Dim db As Database
Try
db = New SqlDatabase(ConfigurationManager.ConnectionStrings("myConnection").ToString)
Using dbCommand As DbCommand = db.GetStoredProcCommand(SQLProcedure)
If Not SQLParams Is Nothing Then
db.AddInParameter(dbCommand.addRange, SQLParams.ToArray())
End If
Using myDataSet As DataSet = db.ExecuteDataSet(dbCommand)
DataSet.Tables(0).Copy
End Using
End Using
Catch ex As Exception
Throw (ex)
End Try
End Function
|
|
|
|
|
Please format your code snippets. This was pointed before and you were given an example. If you can't follow the guidelines here why should we answer your question?
Failure is not an option; it's the default selection.
|
|
|
|
|
Pretty much how I have done it.
I wasn't, now I am, then I won't be anymore.
|
|
|
|
|
the issue I have is when I try to use addRange. it won't recognized it.
And also how do I pass params types?
|
|
|
|
|
Look Sir;
The following pre tag
<pre lang="VB.NET">Try
db = New SqlDatabase(ConfigurationManager.ConnectionStrings("myConnection").ToString)
Using dbCommand As DbCommand = db.GetStoredProcCommand(SQLProcedure)
If Not SQLParams Is Nothing Then
db.AddInParameter(dbCommand.addRange, SQLParams.ToArray())
End If
Using myDataSet As DataSet = db.ExecuteDataSet(dbCommand)
DataSet.Tables(0).Copy
End Using
End Using
Catch ex As Exception
Throw (ex)
End Try</pre>
draws a code block like this :
Try
db = New SqlDatabase(ConfigurationManager.ConnectionStrings("myConnection").ToString)
Using dbCommand As DbCommand = db.GetStoredProcCommand(SQLProcedure)
If Not SQLParams Is Nothing Then
db.AddInParameter(dbCommand.addRange, SQLParams.ToArray())
End If
Using myDataSet As DataSet = db.ExecuteDataSet(dbCommand)
DataSet.Tables(0).Copy
End Using
End Using
Catch ex As Exception
Throw (ex)
End Try
Help people,so poeple can help you.
|
|
|
|
|
You should ensure that you hit reply on the correct message. I believe you intended this response to the OP on the original post.
I wasn't, now I am, then I won't be anymore.
|
|
|
|
|
Hello,
Please tell me how to integrate or use Sensex, nifty and Gold service in my ASP.NET with C# web application. Please reply me ASAP if any one know the solutions.
Thanks & Regards
Vijay
|
|
|
|
|
That is a very vague question; you should always try Google[^] first.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
I think its possible using Google finance API
============================================
The grass is always greener on the other side of the fence
|
|
|
|
|
Hi,
Is there anything called Vertical Method available in .Net. If yes then what is that?
Any link or any guidance helps me a lot. I am not finding anything related to it in .Net on the internet.
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
It would be on the up-and-up.
Need more context: what should be vertical? Text? Code? A bar of chocolate?
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
|
Hi,
+ RETRO
|
|
|UNAMED FOLDER CREATED
|
| ALL CANCER FOLDER
|
|___BONE AND MARROW
|
|___CANCER AND ALL
I need to add the empty folder to RETRO folder.
I need to add UNAMED FOLDER to RETRO FOLDERHow to add it.
Here initScript is the script for javascript.
Thanks
S.GuhananthTh
|
|
|
|
|
I have tried to understand the code in your other post without success and I'm normaly only used to programm none-web-applications. But why dont't you use the TreeView-Control togehter with DataBinding?
|
|
|
|
|
WE are handling some more UI CHANGES IN TREEVIEW.
|
|
|
|
|
Do not repost the same question. You should edit the exiting one.
Failure is not an option; it's the default selection.
|
|
|
|
|
Hi,
I had created treeview using Arraylist as per the below code.
As seen below is the screenshot
+ RETRO
|
|
|UNAMED FOLDER CREATED
|
|ALL CANCER FOLDER
|
|___BONE AND MARROW
|
|___CANCER AND ALL
I need to add the empty folder to RETRO folder.
I need to add UNAMED FOLDER to RETRO FOLDERHow to add it.
Here initScript is the script for javascript.
namespace IHCISCore.Core.Controls
{
public class TreeView : LiteralControl
{
private ArrayList Checked;
private ArrayList TreeList = null;
public TreeView()
{
Checked = new ArrayList();
}
public TreeView(string id)
: this()
{
ID = id;
}
public TreeView(string id, ArrayList treeList)
: this(id)
{
TreeList = treeList;
}
foreach (Node folder in tree)
{
initScript += ID + ".AddFolder('" + "RETRO" + "',"
+ (folder.isSystem ? "false" : "true") + ")\n";
foreach (Node node in folder.Children)
{
if (node.Children.Count >= 1 && !node.HideChildren)
{
if (ID.Substring(0, 3) == "Lab")
initScript += ID + ".AddLabTestFolder('" + node.Title
+ "', '" + node.LOINCID + "', '"
+ LabResults(node.LOINCID.ToString())
+ "','" + ((Node)node.Children[0]).Title + "')\n";
string tabName = ID.Substring(0, 3);
if (tabName == "Cln" || tabName == "Hra")
{
initScript += ID + ".AddFolder('" + node.CategoryName + "',"
+ (folder.isSystem ? "false" : "true") + ")\n";
initScript += ID + ".AddLevel2Folder('" + node.Title + "')\n";
foreach (Node level3 in node.Children)
initScript += ID + ".AddNodeL3('" + level3.Title
+ "', '" + level3.ID + "', "
+ Checked.Contains(level3.ID.ToString()).ToString().ToLower()
+ ")\n";
}
if (tabName == "Qua")
{
initScript += ID + ".AddLevel2Folder('" + node.Title + "')\n";
foreach (Node level3 in node.Children)
initScript += ID + ".AddNodeL3('" + level3.Title
+ "', '" + level3.CONDITIONID + "', "
+ Checked.Contains(level3.CONDITIONID.ToString()).ToString().ToLower()
+ ")\n";
}
}
else
initScript += ID + ".AddNode('" + node.Title
+ "', '" + node.ID + "', "
+ Checked.Contains(node.ID.ToString()).ToString().ToLower()
+ ")\n";
}
}
}
initScript += "ShowTree(" + ID + ")\n</script>";
Page.ClientScript.RegisterStartupScript(typeof(Page), ID, initScript);
}
private string LabResults(string LabID)
{
string result = "";
foreach (string id in Checked)
if (id.StartsWith(LabID + ":") || id.StartsWith(LabID + "|"))
result += id.Substring(LabID.Length) + ",";
if (result.Length > 0)
result = "," + result;
return result;
}
}
|
|
|
|
|
Don't continue to repost the same question.
Failure is not an option; it's the default selection.
|
|
|
|
|
Hi,
I had created treeview using Arraylist as per the below code.
using System;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.ComponentModel;
using System.Collections;
using IHCISCore.Core.Entities;
using IHCISCore.Core.Pages;
using IHCIS.Common.Entities;
using System.Web.SessionState;
using System.Data;
using System.Web;
using IHCISCore.Core.Controls;
using IHCISCore.Core;
namespace IHCISCore.Core.Controls
{
public class TreeView : LiteralControl
{
private ArrayList Checked;
private ArrayList TreeList = null;
public ArrayList txtval;
public ArrayList txtchildval;
public ArrayList hiddenTreeNamesA;
public ArrayList hiddenTreeExPA;
public ArrayList hiddenTreeExCA;
public ArrayList hiddenTreeExAdvPA;
public ArrayList hiddenTreeExAdvCA;
public ArrayList hiddenTreeInAdvPA;
public ArrayList hiddenTreeInAdvCA;
public ArrayList hiddenTreeInPMinA;
public ArrayList hiddenTreeInCMinA;
public ArrayList hiddenTreeExPMinA;
public ArrayList hiddenTreeExCMinA;
public ArrayList hiddenTreeInAdvPMinA;
public ArrayList hiddenTreeInAdvCMinA;
public ArrayList hiddenTreeExAdvPMinA;
public ArrayList hiddenTreeExAdvCMinA;
public TreeView()
{
Checked = new ArrayList();
}
public TreeView(string id)
: this()
{
ID = id;
}
public TreeView(string id, ArrayList treeList)
: this(id)
{
TreeList = treeList;
}
foreach (Node folder in tree)
{
initScript += ID + ".AddFolder('" + "RETRO" + "',"
+ (folder.isSystem ? "false" : "true") + ")\n";
foreach (Node node in folder.Children)
{
if (node.Children.Count >= 1 && !node.HideChildren)
{
if (ID.Substring(0, 3) == "Lab")
initScript += ID + ".AddLabTestFolder('" + node.Title
+ "', '" + node.LOINCID + "', '"
+ LabResults(node.LOINCID.ToString())
+ "','" + ((Node)node.Children[0]).Title + "')\n";
string tabName = ID.Substring(0, 3);
if (tabName == "Cln" || tabName == "Hra")
{
initScript += ID + ".AddFolder('" + node.CategoryName + "',"
+ (folder.isSystem ? "false" : "true") + ")\n";
initScript += ID + ".AddLevel2Folder('" + node.Title + "')\n";
foreach (Node level3 in node.Children)
initScript += ID + ".AddNodeL3('" + level3.Title
+ "', '" + level3.ID + "', "
+ Checked.Contains(level3.ID.ToString()).ToString().ToLower()
+ ")\n";
}
if (tabName == "Qua")
{
initScript += ID + ".AddLevel2Folder('" + node.Title + "')\n";
foreach (Node level3 in node.Children)
initScript += ID + ".AddNodeL3('" + level3.Title
+ "', '" + level3.CONDITIONID + "', "
+ Checked.Contains(level3.CONDITIONID.ToString()).ToString().ToLower()
+ ")\n";
}
}
else
initScript += ID + ".AddNode('" + node.Title
+ "', '" + node.ID + "', "
+ Checked.Contains(node.ID.ToString()).ToString().ToLower()
+ ")\n";
}
}
}
initScript += "ShowTree(" + ID + ")\n</script>";
Page.ClientScript.RegisterStartupScript(typeof(Page), ID, initScript);
}
private string LabResults(string LabID)
{
string result = "";
foreach (string id in Checked)
if (id.StartsWith(LabID + ":") || id.StartsWith(LabID + "|"))
result += id.Substring(LabID.Length) + ",";
if (result.Length > 0)
result = "," + result;
return result;
}
}
As seen below is the screenshot
+ RETRO
|
|
|UNAMED FOLDER CREATED
|
|ALL CANCER FOLDER
|
|___BONE AND MARROW
|
|___CANCER AND ALL
I need to add the empty folder to RETRO folder.
I need to add UNAMED FOLDER to RETRO FOLDERHow to add it.
Here initScript is the script for javascript.
Thanks
S.GuhananthTO
modified 29-Feb-12 7:39am.
|
|
|
|
|
Far too much code. Edit your post and only include what necessary to clarify your question, not all of it.
Failure is not an option; it's the default selection.
|
|
|
|
|
i had removed huge codes now.plz help on the issue.
|
|
|
|
|
No, there is still far too much useless code clouding everything up. Your question is how to create a treeview from an array list. Show the arraylist and the expected output. The for loop and all the if statements are just useless distracting drivel.
Failure is not an option; it's the default selection.
|
|
|
|
|
i had posted freshly.please answer.
|
|
|
|
|
Read my previous response. We can keep this going for a long time. If you want an answer than provide the necessary information, without the unnecessary distracting extraneous drivel
Failure is not an option; it's the default selection.
|
|
|
|