|
//i have not tryed the code so it might have some errors but i think you can get the idea
//SQL_COMMANDS (this commands will work only if you have a SQL Database)
//this command will return all the non system tables
SELECT Table_Name AS NOMBRE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE '
//this will return all the column names from a given database and table
SELECT COLUMN_NAME as column FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME
string Query = "SELECT COLUMN_NAME as column FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME LIKE 'the_name_of_your_table'
//first you have to get all the column names of your table
Cache = new System.Data.DataSet();
using (SqlConnection Conn = new SqlConnection(this.Conexion))
{
SqlDataAdapter SqlDs = new SqlDataAdapter(Query,Conn);
Conn.Open();
SqlDs.Fill(Cache,NombreTabla);
}
//now you have all the column names and you have to iterate as many times as columns you have creating and adding to your form a lavel
//note that in your case the location will have to be assign dinamicly
foreah(DataRow row in Cache.DataTable["NombreTabla"].rows)
{
System.Windows.Forms.Label MyLabel = new System.Windows.Forms.Label();
MyLabel .Location = new System.Drawing.Point(64, 64);
MyLabel .Name = row[0].tostring();
MyLabel .Size = new System.Drawing.Size(376, 64);
MyLabel .TabIndex = 0;
MyLabel .Text = row[0].tostring();
//here we add the new label to the form
this.controls.add(MyLabel)
}
//i hope the code above can help you
NOthing by now;)
|
|
|
|
|
Hi everybody
First i need to now if in a given intranet there is a domain server and if yes be able to connect to it in order to get information about the domain.
I've been looking for this but i've not find anything about.
My code is done in C# using the 2.0 framework, but any help even in other language will be great
pleeeease. anyone can help me??
thanks everyone.
NOthing by now;)
|
|
|
|
|
Not an AD expert by any means, but have been doing somework with it lately.
Doing a dsquery server on the command line will return a list of comain controllers for your domain. I think this is a subset of cn=configuration,dc=yourdomain,dc=com. Of course, if you have no DC, that will not work  .
Ryan
"Michael Moore and Mel Gibson are the same person, except for a few sit-ups. Moore thought his cheesy political blooper reel was going to tell people how to vote. Mel thought that his little gay SM movie about his imaginary friend was going to help him get to heaven."
- Penn Jillette
|
|
|
|
|
i am working on windows application. i have used cystel report in my program. and using microsoft access as a database.i have put password on access file. problem is that every time i press on button to open crystel reports database login dialog appears.it asks for login id and password. by putting these report work fine.
i don'nt want this database login dialog. but i also don'nt want to remove password from database.
what code i should make so that database login not appear and crystel report work fine without entering password again and again
Amit Grover
CDAC R&D
|
|
|
|
|
Is it have any Optional parameter in C#
If it have, How to declare in a method
Tell me please\\
thanx
-
|
|
|
|
|
Nope, they took out optional parameters for C#.
Instead you have to make multiple overloaded methods, each for which ever parameters you want to use.
|
|
|
|
|
public void MyMethod() {
// for example you can call your second function
MyMethod(true);
}
public void MyMethod(bool param1) {
// for example you can call your third function
MyMethod(param1, "");
}
public void MyMethod(bool param1, string strParam2) {
// do something
}
now you just can call the method by
MyMethod(); //or
MyMethod(oMyVar); //or
MyMethod(oMyVar, strMyString);
this is a good way to do this.
|
|
|
|
|
Hi,
I have two problems.
first, I am looking for some API or library in C# that can help me to extract the motion vector stored in the MMEG4 video files.
Secondly, I am also looking for the API that construc a MPEG4 video file with the I-frame and motion vector.
Thanks for your help.
|
|
|
|
|
FFmpeg and Xvid are opensource projects. They are the only ones I can think of.
|
|
|
|
|
I've added a table and a couple of textboxes dynamically to my .aspx page.
When I want to loop through the controls on the page, it just displays the text "control", irrespective of how many text boxes were generated.
Here is my loop to display the controls:
protected void btnInsert_Click(object sender, EventArgs e)
{
foreach (Control control in Page.Controls)
{
if (control.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox"))
{
Response.Write("contol " + control.ID + "<br />");
}
}
}
Please can someone help.
Regards,
Brendan
|
|
|
|
|
Hi,
Have you verified that whether you are having the TextBox control in Page.Controls, because i have used like this and this is giving me correct result:
foreach (Control control in Page.Controls)
{
if(control.GetType().ToString()=="System.Web.UI.HtmlControls.HtmlForm")
{
for(int i=0; i<control.Controls.Count; i++)
{
if(control.Controls[i].GetType().ToString()=="System.Web.UI.WebControls.TextBox")
{
Response.Write(control.Controls[i].ID + "<br>");
}
}
}
}
Hope this will help you.
Best Regards,
Apurva Kaushal
-- modified at 7:31 Friday 19th May, 2006
|
|
|
|
|
Take a look at how you are adding the TextBoxes. If you're adding them to a panel or some other control that's in the Page.Controls collection, then Page.Controls won't contain your control, but panel1.Controls will (for instance).
|
|
|
|
|
Hi,
Something really weird is happeneing here, and I can't explain why.
Let me give you a brief explanation what happens. When the pages loads for the first time it loads all the hub groups into a dropdown control, that's all. Each hub group can have 0, 1, or many hubs. I don't know how many hubs there are per hub group. When the user selects a hub group, it sets a panel to true, and loads all the related hubs, with textboxes. The textboxes are generated automatically. I give the ID of each textbox "txt" plus the ID of the hub (from the database).
This is my code in the .aspx file (just some of it):
<asp:Content id="cntBodyContent" ContentPlaceHolderID="cphBodyContent" Runat="Server">
<h5>Hub Group</h5>
<asp:DropDownList id="cboHubGroup" AutoPostBack="true" OnSelectedIndexChanged="cboHubGroup_SelectedIndexChanged" runat="server" />
<asp:Panel id="pnlHubCommissions" Visible="false" runat="server">
<asp:Table id="tblHubCommRates" BorderWidth="1" Width="100%" runat="server"></asp:Table>
<asp:Button id="btnInsert" Text="Insert" CssClass="FormButton" runat="server" OnClick="btnInsert_Click" />
</asp:Panel>
</asp:Content>
When I generate the textboxes for each hub, this is my code:
string strHubs = string.Empty;
TextBox tb;
List<Hub> lstHubs = Hub.GetHubsByHubGroupID(Int32.Parse(cboHubGroup.SelectedValue));
foreach (Hub h in lstHubs)
{
TableRow tRow = new TableRow();
tblHubCommRates.Rows.Add(tRow);
TableCell tCell1 = new TableCell();
TableCell tCell2 = new TableCell();
tCell1.Text = "<h5>" + h.HubName + "</h5>";
tCell1.Width = Unit.Percentage(15);
tRow.Cells.Add(tCell1);
tb = new TextBox();
tb.ID = "txtHubCommRate" + h.HubID;
tb.Width = Unit.Pixel(44);
tb.MaxLength = 6;
tb.CssClass = "InputText";
tCell2.Controls.Add(tb);
tCell2.Width = Unit.Percentage(85);
tRow.Cells.Add(tCell2);
}
My button event handler:
protected void btnInsert_Click(object sender, EventArgs e)
{
// It does nothing yet
}
Everything displays well, 100% in fact. But this is where I am having my problem. When I click on the buttion, then table with the results generated disappears. Not sure why this happens. This is why I think it can not display the controls, because it is not there. Is there a reason for this??
I hope someone can help. If I have left out something, please let me know. If I can get this to work, then I can think about trying to display the textbox values.
Regards,
ma se
|
|
|
|
|
can anybody tell me
How to Increase the header height of datagrid in c# windows application??
Thx
Qutub
Qutub
|
|
|
|
|
Hi
u can try b changing the proper in the property window.
The property that u've to change is "PreffredRowHeight"
Regards,
Mukesh
|
|
|
|
|
Hi, I'm new to the code project. I'm 16 and I am working on my major work for year 11. I want to make an instant messenger similar to msn, but simpler. I'm fairly new to C# and all programming, but know the basics.
I have created a form with 2 text box (tbName, tbSpeech) a list box and a send button. You type your name in to tbName and then type your message in to tbSpeech. The program then adds " Says: " to your name, then adds your name (including the extra bit) and your message to an array, the array is then displayed in the list box.
I was wondering if you could help me with the whole getting the array to display on both computers bit. I have been looking around on this site and the only way I have seen it done, is with a console program set up as a server (this was for a messenger service based on a local network).
In the final project I plan to have the main form containing a list of people logged on (being anyone who is running the program) and you can click on their names and it opens the form that I decribed earlier (very similar to msn). I need help working with the internet though. What is the best way I should go about it?
Cheers in advance guys
-- modified at 6:00 Friday 19th May, 2006
|
|
|
|
|
Hi,
have a look at this article[^]. It doesn't have really good votes because the demo and code comments are in spanish but the article is in english and should give you the basic idea.
You definitely need a server. Whether this is a console program, a service or just another mode of the client GUI doesn't matter.
|
|
|
|
|
rev `ed wrote: to your name, then adds your name (including the extra bit) and your message to an array, the array is then displayed in the list box.
I don't know where are you going. Use comma seperated string (eg. user, message). You will then send this comma seperated string to the other computer. There create a string array based on the comma seperated string. Does this help?
<italic>Work hard, Work effectively.
|
|
|
|
|
hi ppl,
I am using a gridview,where i have 5 columns with a drop down list in 1 column.
Salary No_months TotalSal are the 3 columns among 5.
When i select a value from dropdown list in no_months column,i.e,On selcted index changed,i should get the calculated TotalSalary which is a product of (Salary * No_months) displayed in the next column i.e,in TotalSal column.
I could do this using functions to calculate totalSal(Salary*No_months)to get my result dispalyed in TotalSal column.To do this i hav used Edit item template,such that i can change values in Salary & No_months columns while using Edit & update.Update is used to update the changed value & calculated product(result).
But instead of straightly editing no_months value as used so far,I want to use Dropdownlist in place of nO_months column to select a value
thank u for any help
rita
|
|
|
|
|
In "Office Development 2005" ,the above said fnction is working with "excel workbook" project, but when tried out in "Excel Template" Project we are getting one error message as "Attempted to read or write protected memmory". Please give help in this regard as soon as possible.
|
|
|
|
|
Hi guys,
I need to select multiple cells of datagrid control at same time.
I have tried a lot of stuff withouth success. Please help meeee!!!
Thankyou in advance.
Mirko (buzzy84)
|
|
|
|
|
Short answer: It doesn't work. Only single cells or whole rows.
You are better of using another grid component (like SourceGrid[^])
|
|
|
|
|
You can use checkboxes for that.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi all, i want to create a control that does just like a panel into Visual Studio.
If i want to set a background image i go on open file dialog at the voice background image and load the image.
I know how create this property for my cotnrol but when i laod the image it doesn't is set in my resource project directory as Visual Studio does.
How can i do?
|
|
|
|
|
Is your problem runtime or design time related? In design time Visual Studio should handle it automatically if its a public property. In runtime you will have to store the bitmap yourself. You could either save the bitmap as a file (image.Save()) or serialize it like Visual Studio does it. For this have a look at the System.Runtime.Serialization namespace.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
