|
i have one dropdownlist suppose: ddl_Technologytype and a textbox: txt_technology.
i have a database name: tech .
and 2 tables in this database : tb_techtype and tb_ tech
ddl_technology have some items , such as ASP,C, VB,JAVA.. and one item as OTHERS .
Now the issue is that when i select the item OTHERS from ddl it shows the textbox ie txt_technology.
and now i have to enter some text to the textbox. So, i will enter the text and then i will click submit button, at this time if the text that is entered in textbox is already present in the ddl then we have to show a message popup "Value is already present in the list" and if text in textbox is not present in ddl then should get added in ddl items when next time i open the page .
and we have to use the database, and would also like to know the process without database .
Please can anyone help me out since i am a beginner , i want solution from both using database and without database.
Thank you.
|
|
|
|
|
listen, if you can´t get an anser shortly i can tell you that later 
|
|
|
|
|
please nelson send the reply fast , if posible then by today .
thank you
|
|
|
|
|
listen, what you request it´s not hard, but it takes lots of time to code and debug!!!
So, read the following and if you became stuck ask here in the forum anyone can help you there stay cool.
(i assume you mean that dropdownlist = combobox)
private void Form1_Load(object sender, EventArgs e)
{
textBox1.Visible = false;
comboBox1.Items.Add("ASP"); //0
comboBox1.Items.Add("C#"); //1
comboBox1.Items.Add("VB"); //2
comboBox1.Items.Add("Javascript"); //3
comboBox1.Items.Add("PHP"); //4
comboBox1.Items.Add("Other"); //5
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == 5)
{
textBox1.Visible = true;
}
else
{
textBox1.Visible = false;
}
}
private void button1_Click(object sender, EventArgs e)
{
comboBox1.Items.Add(textBox1.Text);
}
Try that easy exemple but that´s not enought! The solution without using a database doesn´t exist!
How and where would you store the data from new values added to the textbox?
And as you can see, each time you load your application your combox will only have the old values not the new added items. You noticed it already, right?
What you have to do instead is this:
create a table (if you don´t have one already) to fill up the combobox, so when you press button new values from the textbox will be added to the table.
1) create table tech with: id int, name varchar(50)
id | name
1 | ASP
2 | c#
3 | VB
4 | HTML
5 | PHP
6 | C++
...etc
2) create a SQL store procedure to fill up/load your combox (trigger it with a load_form event)
SQL:
create procedure tech_all
as
begin
select id, name from dbo.tech
end
go
C#:
this is what i do to connect to database and fill combobox:
string CONNECTION_STRING = "..."; // you know this
SqlConnection con_sql = new SqlConnection(CONNECTION_STRING);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con_sql;
cmd.CommandText = tech_all; // the store procedure above
cmd.CommandType = CommandType.StoredProcedure;
con_sql.Open();
SqlDataAdapter sql_da = new SqlDataAdapter();
sql_da.SelectCommand = cmd;
DataTable dt = new DataTable();
sql_da.Fill(dt);
con_sql.Close();
COMBOBOX1.DataSource = dt;
COMBOBOX1.DisplayMember = "name"; // table tech variable
COMBOBOX1.ValueMember = "id"; // table tech variable
3)create a SQL SP to add values to your combobox (trigger it with button_click event)
SQL:
create procedure tech_add
@name as varchar(50)
as
begin
insert into dbo.tech (name)
values (@name)
end
go
C#:
this is what i do to connect to database and add values to combobox:
(check this part i didn´t have time to test)
string CONNECTION_STRING = "...";
SqlConnection con_sql = new SqlConnection(CONNECTION_STRING);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con_sql;
cmd.CommandText = tech_add; // the store procedure above
cmd.CommandType = CommandType.StoredProcedure;
//
command.Parameters.Add("@name", SqlDbType.VarChar).Value = textbox1.text; // your input textbox!!!
//
con_sql.Open();
SqlDataAdapter sql_da = new SqlDataAdapter();
sql_da.SelectCommand = cmd;
DataTable dt = new DataTable();
sql_da.Fill(dt);
con_sql.Close();
COMBOBOX1.DataSource = dt;
COMBOBOX1.DisplayMember = "name"; // table tech variable
COMBOBOX1.ValueMember = "id"; // table tech variable
Change anything you like to fit what you have in mind!
Good Luck 
modified on Thursday, July 24, 2008 7:54 PM
|
|
|
|
|
I'm working on a venue booking system.This system allows a person to make a booking for any period during the year(for a whole month or week).My problem is getting my system to check and display available time slots between a specified range.for example: a person may book from 12 August to 30 August,now how do i get the system to check and display available or unavailable slots.i'm using a grid to display all of this so what i want is my grid to shade with a color the booked time slots on a particular day and allow a person to select the slots they prefer on the grid with a different colour.Any help with this will be appreciated.(code,sql statements)
Thanx
|
|
|
|
|
Hi,
you could loop over the days from date1 to date2, by "incrementing" a DateTime, using
DateTime.AddDays(1); and check that each of these days is still free.
And of course you would use DateTime.Date to get rid of the time component when performing
comparisons.
|
|
|
|
|
I think I'll need to do some wizard controls in the future to accommodate for the short-comings of certain users.
I'd need something that supports some databinding, or at least makes it simple to perform databinding actions myself. I did a quick search on CP and found a good deal of Wizard controls, most of them somewhat dated.
Does anyone have any suggestions for a wizard control that's flexible and easy to implement? Any that are packed with features but a pain to implement?
|
|
|
|
|
Sounds like a candidate for an article. Why not write one of your own, and share it with us, especially as you get to define the features you feel you need? If you have specific problems, or just want advice on features, we'll be glad to help. I look forward to seeing this article.
|
|
|
|
|
Indeed, a great article idea. If people wouldn't mind my writing style (that tends to get off topic and so interjected that it reminds me of a heavily nested, maybe a recursive algorithm) and vocabulary, or lack thereof. And don't get me started on tangents... which reminds me of one of my calculus profs for some reason. He always stopped to talk about his statistician friend who counts insects in the woods and looks like a sasquatch... anyway, that sounds like a great idea.
But I'm not sure if I have time to re-invent the wheel. Which is why I wanted to know what people liked to use.
Now that you got me thinking about it though, I'm getting some design thoughts running through my head. It'd be a fun project to do in my off time after I finish my wife's joint story authoring web-app (she's writing a story in conjunction with her friends and one of them is going crazy with her character so she asked me to make something that forced a kind of co-author approval before it can be appended to the main story). My only problem would be coding for the designer. It's not something I've done before. Fortunately, I've got a lot of sample code to go off of and a great community on CP.
|
|
|
|
|
Sounds good. I'm really looking forward to it now though.
|
|
|
|
|
I'm implementing the XmlSchemaProvider attribute and am having some issues defining my XSD. I've created a XSD file which will be an embedded resource in an assembly. I'm attempting to import the MS WSDL types schema so that I can provide a defintion for char datatype, but every way I try and add the namespace and import the schema I get resolution errors. I'm VERY new to XSDs and have some working knowledge of XML so I'm not 100% positive I can do what I want to here, but this is the basic pattern I have seen in many WSDLs for adding support for char datatypes.
I posted this question in the XML message board as well, but was hoping some C#ers out there have come across this same issue while implementing the XmlSchemaProvider attribute.
Any answers or shoves in the right direction would be appreciated.
Below is a sample format for my XSD:
<?xml version="1.0" encoding="utf-8"?>
<xs:schema targetNamespace="http://tempuri.org/XMLSchema.xsd"
elementFormDefault="qualified"
xmlns="http://tempuri.org/XMLSchema.xsd"
xmlns:mstns="http://tempuri.org/XMLSchema.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:xs0="http://microsoft.com/wsdl/types/"
>
<xs:import namespace="http://microsoft.com/wsdl/types/"/> <!--cannot resolve "http://microsoft.com/wsdl/types/" error here-->
<xs:complexType name="MyComplexType">
<xs:sequence>
<xs:element name="Value" nillable="true">
<xs:complexType>
<xs:choice>
<xs:element name="boolean" type="xs:boolean" />
<xs:element name="byte" type="xs:byte" />
<xs:element name="unsignedByte" type="xs:unsignedByte" />
<xs:element name="short" type="xs:short" />
<xs:element name="unsignedShort" type="xs:unsignedShort" />
<xs:element name="int" type="xs:int" />
<xs:element name="unsignedInt" type="xs:unsignedInt" />
<xs:element name="long" type="xs:long" />
<xs:element name="unsignedLong" type="xs:unsignedLong" />
<xs:element name="float" type="xs:float" />
<xs:element name="double" type="xs:double" />
<xs:element name="decimal" type="xs:decimal" />
<xs:element name="dateTime" type="xs:dateTime" />
<xs:element name="string" type="xs:string" />
<xs:element name="char" type="xs0:char" /> <!--Type http:=
</xs:choice>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:schema>
|
|
|
|
|
I write a windows service. This program copy file to another location. Program is properly working in on local disk. If I want to copy file between cliend and server i get error: ERROR 5 (0x00000005) Accessing Source Directory \\server\sharedFolder\ Access is denied.
Same code properly working on windows application, but not work in windows service application. I think this problem related about account permission. Windows application use current user name and password, but maybe windows service application use different account information. What can I do?
|
|
|
|
|
|
I use this code for Impersonate
private const int LOGON_TYPE_INTERACTIVE = 2;
private const int LOGON_TYPE_PROVIDER_DEFAULT = 0;
[DllImport("advapi32.dll", CharSet = CharSet.Unicode, SetLastError = true)]
static public extern bool LogonUser(string userName, string domain, string passWord, int logonType, int logonProvider, ref IntPtr accessToken);
IntPtr accessToken = IntPtr.Zero;
LogonUser("boran", "IZON\boran", "96587", LOGON_TYPE_INTERACTIVE, LOGON_TYPE_PROVIDER_DEFAULT, ref accessToken);
WindowsIdentity identity = new WindowsIdentity(accessToken);
WindowsImpersonationContext context = identity.Impersonate();
Ok service is running, but I can't stop this service. And not work properly.
|
|
|
|
|
Probably your service is running under the system account which usually has no network rights. Either you give the system account the access rights needed (not recommended because then any other service or virus running under the system account will be able to fiddle with the network), or you use impersonation as Marc suggested, or you create a user account with exactly the rights needed and install your service to run under this very user account. I seem to recall that when deploying your service with msi you can create this user on the target machine as well.
|
|
|
|
|
I solve my proplem.
right click to my computer --> select manage --> select Services
after that select my service --> right click and select properties
click LogOn tab --> select "This Account" --> write my user name with .\ operators. For example my user name is boran and I type .\boran and type my password. Thats it, its work...
|
|
|
|
|
hello, I need to control the loudspeakers... I need to send frequencies (Hertz) to the loudspeakers and they need to broadcast it
hope you understand what I want to do
is it possible?
thanks
|
|
|
|
|
|
actually it's not wav files,.. I need to find a way to control the frequency - the amount of Hertz
|
|
|
|
|
|
Hi,
Not sure how accurate the duration would be, I wrote an article on timer accuracy,
and your message makes me consider adding a Console.Beep duration test to it!
|
|
|
|
|
I would love to see the article
|
|
|
|
|
Then go ahead and read it. The link is near.
|
|
|
|
|
thank you!
who would have thought that a simple console.beep would do the charm?
|
|
|
|
|
is it possible to send 1 console.beep to one loudspeaker and another to the second loudspeaker?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
