Click here to Skip to main content
16,017,261 members
Home / Discussions / C#
   

C#

 
QuestionTab key functionality in editor user control Pin
Nouman Bhatti30-Apr-08 9:53
Nouman Bhatti30-Apr-08 9:53 
AnswerRe: Tab key functionality in editor user control Pin
Big Daddy Farang30-Apr-08 10:48
Big Daddy Farang30-Apr-08 10:48 
GeneralRe: Tab key functionality in editor user control Pin
Nouman Bhatti1-May-08 19:30
Nouman Bhatti1-May-08 19:30 
GeneralRe: Tab key functionality in editor user control Pin
Big Daddy Farang2-May-08 5:29
Big Daddy Farang2-May-08 5:29 
QuestionHow to get stored procedure parameters with SQLDMO ? Pin
hdv21230-Apr-08 7:17
hdv21230-Apr-08 7:17 
AnswerRe: How to get stored procedure parameters with SQLDMO ? Pin
Rob Graham30-Apr-08 11:56
Rob Graham30-Apr-08 11:56 
GeneralRe: How to get stored procedure parameters with SQLDMO ? Pin
hdv21230-Apr-08 20:34
hdv21230-Apr-08 20:34 
GeneralRe: How to get stored procedure parameters with SQLDMO ? Pin
goodideadave1-May-08 6:28
goodideadave1-May-08 6:28 
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ProFeeRevenueUser"].ConnectionString);

try
{
conn.Open(); // connect to the database

TreeView1.Nodes.Clear();
DataTable dt = new DataTable();
dt = conn.GetSchema("ProcedureParameters");
DataView view = dt.DefaultView;

view.Sort = "specific_name, ordinal_position";

string ProcedureName = "";

DataRowView dr;
IEnumerator ViewEnum = view.GetEnumerator();
while(ViewEnum.MoveNext())
{
dr = (DataRowView)ViewEnum.Current;
if (!dr["specific_name"].ToString().StartsWith("dt_"))
{
if (ProcedureName != dr["specific_name"].ToString())
{
TreeNode ProcedureNode = new TreeNode(dr["specific_name"].ToString());
TreeView1.Nodes.Add(ProcedureNode);
ProcedureName = dr["specific_name"].ToString();
}
StringBuilder sb = new StringBuilder(dr["parameter_name"].ToString());
sb.Append(" ");
sb.Append(dr["data_type"].ToString());
sb.Append(" ");
if (!dr.Row.IsNull("character_maximum_length"))
{
sb.Append("(");
sb.Append(dr["character_maximum_length"].ToString());
sb.Append(")");
sb.Append(" ");
}
sb.Append(dr["parameter_mode"].ToString());

TreeNode ProcedureParameterNode = new TreeNode(sb.ToString());
TreeView1.Nodes[TreeView1.Nodes.Count - 1].ChildNodes.Add(ProcedureParameterNode);
}
}
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
TreeView1.CollapseAll();

Someone's gotta be the last to know, but why is it always me?

QuestionAfter printing a Word Doc using C#, I cant print from Excel but i CAN print from notepad or anything else... Pin
g1b30-Apr-08 6:56
g1b30-Apr-08 6:56 
AnswerRe: After printing a Word Doc using C#, I cant print from Excel but i CAN print from notepad or anything else... Pin
Arjun Marwaha30-Apr-08 7:41
Arjun Marwaha30-Apr-08 7:41 
GeneralRe: After printing a Word Doc using C#, I cant print from Excel but i CAN print from notepad or anything else... Pin
g1b30-Apr-08 8:29
g1b30-Apr-08 8:29 
Questionitextsharp form fields Pin
Uyi30-Apr-08 6:31
Uyi30-Apr-08 6:31 
AnswerRe: itextsharp form fields Pin
carbon_golem30-Apr-08 6:57
carbon_golem30-Apr-08 6:57 
Question[Message Deleted] Pin
cs.it.tech30-Apr-08 5:16
cs.it.tech30-Apr-08 5:16 
AnswerRe: any one help me,please Pin
Gareth H30-Apr-08 5:45
Gareth H30-Apr-08 5:45 
AnswerRe: any one help me,please PinPopular
J4amieC30-Apr-08 5:46
J4amieC30-Apr-08 5:46 
GeneralRe: any one help me,please Pin
cs.it.tech30-Apr-08 7:24
cs.it.tech30-Apr-08 7:24 
GeneralRe: any one help me,please Pin
leckey30-Apr-08 8:09
leckey30-Apr-08 8:09 
GeneralRe: any one help me,please Pin
leckey30-Apr-08 8:10
leckey30-Apr-08 8:10 
GeneralRe: any one help me,please Pin
J4amieC30-Apr-08 22:14
J4amieC30-Apr-08 22:14 
GeneralRe: any one help me,please Pin
leckey1-May-08 3:03
leckey1-May-08 3:03 
GeneralRe: any one help me,please Pin
J4amieC1-May-08 4:32
J4amieC1-May-08 4:32 
GeneralRe: any one help me,please Pin
leckey1-May-08 4:54
leckey1-May-08 4:54 
AnswerRe: any one help me,please Pin
carbon_golem30-Apr-08 6:52
carbon_golem30-Apr-08 6:52 
GeneralRe: any one help me,please Pin
User 665830-Apr-08 8:26
User 665830-Apr-08 8:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.