|
It was working when I posted it. I think the hamsters stole the "x" from the end. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I am working with vs2013 to develop a console apps. how to add localdb to db folder of my console project. Please tell me the way to add localdb in db folder of my project? thanks
tbhattacharjee
|
|
|
|
|
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
So try explaining in more detail exactly what you are trying to do, and why it's causing you a problem.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
What do you mean? Add an access database? That's easy. Copy one to your folder and then use a connection string.
Do you mean a sql database? Also easy, don't copy it to your folder, access it via the server and the proper connection string.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
|
Ah, probably.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I am trying to receive values from a listbox and make a string which separates the items by ","
The following code does the job, but instead of the items, i get "System.Data.DataRowView" over and over.
Here is my code:
string[] items = listBox1.Items.OfType<object>().Select(item => item.ToString()).ToArray();
string result = string.Join(",", items);
label1.Text = result;
|
|
|
|
|
"Trying to receive values from a listbox"?
Are you trying to use a listbox to transfer values from one part of your program to another? This is bad practice.
Controls should never be used as a transport mechanism for data. Controls, like a ListBox, are a conduit through which you display parts of your data model to the user and are also used to get data from the user.
Since you're not getting the list of selected items from a user this leads me to believe you're doing something you should not be doing while trying to manage your data model.
A ListBox manages its items using a ObjectCollection class, which is essentially just a List<object>. What you did, when you added items to the ListBox, is added a bunch of DataRowView objects to it. When the ListBox displays these items, it called .ToString() on each of them to get some kind of text to display.
To convert the items in this list to a list of strings, you need to get an appropriate value of a field in each DataRowView. What happens in your code is that the objects in the ListBox are all cast to Object, which really doesn't have any methods or properties on them. The default .ToString() implentation of Object just returns the underlying type name. That's where you're getting the "System.Data.DataRowView" string from.
In order to treat these objects as a type you can actually do something with, you have to cast the objects to the type you can work with, instead of .OfType<object> it should be .OfType<DataViewRow>. Now you've got the methods and properties of a DataViewRow object to work with and your Select() code can be changed to pick an appropriate field/property to get a value from and return an actual value string instead of the type name.
|
|
|
|
|
Thank you Dave for your fast replay
I will learn your answer and hope
to finish my project
|
|
|
|
|
You're on the right track!
string items = string.Join(",", listBox1.Items.OfType<string>().Select(o => o));
Do not forget about Dave's notes.
|
|
|
|
|
No need for the trailing .Select(o => o) - OfType<T> already returns an IEnumerable<T>.
And since you're using .NET 4.5, you don't really need the .OfType<string>() either. There's an overload of string.Join which takes an IEnumerable<T>, and converts each item to a string.
string items = string.Join(",", listBox1.Items.Cast<object>());
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard, i agree with you, but i feel in duty to explain why a OfType<string>() has been used in my code.
Well, OP wrote:
Quote: The following code does the job, but instead of the items, i get "System.Data.DataRowView" over and over.
You're suggesting to use Cast<object>(), because string.Join() method is able to convert object to string.
The differences between OfType() and Cast() are well known. Using OfCast() is always safer way. That's way that method is much slower than Cast().
Cheers!
Maciej
Using Cast Or OfType Methods[^]
|
|
|
|
|
|
It's the note half a tone above C. It is also the name of the language Microsoft invented to go along with the .NET framework.
This space for rent
|
|
|
|
|
You could have easily answered this yourself simply by typing "What is C#?" into Google.
|
|
|
|
|
Now we wait for the follow-up question, "what is Google?" 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
"C# is an elegant and type-safe object-oriented language that enables developers to build a variety of secure and robust applications that run on the .NET Framework. " -- MSDN: Introduction to the C# Language and the .NET Framework[^]
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
it is the subject of this forum
|
|
|
|
|
Pithy as ever.
This space for rent
|
|
|
|
|
It's what you do after you eat a lot of carrots.
Java/javascript is what you do after your carrots are digested (my advice - be in a sitting position when you do it, and wash your hands afterwards).
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
I am using a model that to be converted into json with Newtonsoft Json as follows
MyCars[
Car{
Name:""
Model:""
}
Car{
Name:"",
Model:""
}
]
but I am getting
MyCar[
Car[
{Name:"",
Model:""
}
{
Name:"",
Model:""
}
]
]
how to get first format?
|
|
|
|
|
This has nothing to do with C#. You should try the Newtonsoft forums.
|
|
|
|
|
You'll need to fix your C# model, which you haven't shown.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
i add auser control which has aformview control to main page dynamically with c# code ,but i set in the page load of the main page the form view with read only mode to bind the data and when i press add section in main page the form view become in insert mode but when i click insert it doesn`t do insert because it make post pack and load the page load which set the form view mode to read only to bind the data which come from the database
the problem is how to set the default mode of form view to insert in the same page which i called the control dynamically with read only mode
find the code html of the user contrl form
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="skills.ascx.cs" Inherits="JobSeeker_skills" %>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional" >
<ContentTemplate>
<asp:FormView id="Formviewskills" runat ="server" style="width:100%" DataSourceID="FormViewskillsSDS"
umbDebugShowTrace="true" DataKeyNames="SkillsID" OnItemCreated="Formviewskills_ItemCreated" >
<EditItemTemplate>
<table style="width:100%">
<tr>
<td class="col-md-6">
<asp:label class="link_sgray" id="FirstName" runat="server" >Skills: </asp:label>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="Skills"
Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator>
<br />
<asp:Textbox style="width:100%" id="Skills" class="form-control" runat="server"
Text='<%# Bind("Skills") %>' >
</asp:Textbox>
</td>
</tr>
<tr>
<tr>
<td class="col-md-6">
<asp:label class="link_sgray" id="Label1" runat="server" >Proficiency: </asp:label>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="Proficiency"
Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator>
<br />
<asp:DropDownList style="width:100%" id="Proficiency" CssClass="dropdown" runat="server" selectedvalue='<%# Bind("Proficiency") %>'
DataSourceID="ProficiencyDDL" DataTextField="Value" DataValueField="ID">
</asp:DropDownList>
</td>
<td class="col-md-6">
<asp:label class="link_sgray" id="Label8" runat="server" >Years of Experience: </asp:label>
<asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="YearsofExperienceSkills"
Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator>
<br />
<asp:DropDownList style="width:100%" id="YearsofExperienceSkills" CssClass="dropdown" runat="server" selectedvalue='<%# Bind("YearsofExperienceSkills") %>'
DataSourceID="YearsofExperienceSkillsDDL" DataTextField="Value" DataValueField="ID">
</asp:DropDownList>
</td>
<%----%>
</tr>
<tr>
<td colspan="2">
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" CssClass="btn-primary" />
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" CssClass="btn-primary"/>
</td>
</tr>
</table>
</EditItemTemplate>
<InsertItemTemplate>
<table style="width:100%">
<tr>
<td class="col-md-6">
<asp:label class="link_sgray" id="Skillslbl" runat="server" >Skills: </asp:label>
<%----%>
<br />
<asp:Textbox style="width:100%" id="Skills" class="form-control" runat="server"
Text='<%# Bind("Skills") %>' ></asp:Textbox>
</td>
</tr>
<tr>
<td class="col-md-6">
<asp:label class="link_sgray" id="Label1" runat="server" >Proficiency: </asp:label>
<%----%>
<br />
<asp:DropDownList style="width:100%" id="Proficiency" CssClass="dropdown" runat="server" selectedvalue='<%# Bind("Proficiency") %>'
DataSourceID="ProficiencyDDL" DataTextField="Value" DataValueField="ID">
</asp:DropDownList>
</td>
<td class="col-md-6">
<asp:label class="link_sgray" id="Label8" runat="server" >Years of Experience: </asp:label>
<%----%>
<br />
<asp:DropDownList style="width:100%" id="YearsofExperienceSkills" CssClass="dropdown" runat="server" selectedvalue='<%# Bind("YearsofExperienceSkills") %>'
DataSourceID="YearsofExperienceSkillsDDL" DataTextField="Value" DataValueField="ID">
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Button ID="insertButton" runat="server" CommandName="Insert"
Text="Insert" CssClass="btn-primary" ></asp:Button>
<asp:Button ID="insertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" CssClass="btn-primary" ></asp:Button>
</td>
</tr>
</table>
</InsertItemTemplate>
<ItemTemplate>
<table style="width:100%">
<tr>
<td class="col-md-6">
<asp:label class="link_sgray" id="FirstName" runat="server" >Skills: </asp:label>
<br />
<asp:Textbox style="width:100%" id="Skills" class="form-control" runat="server" Enabled="false"
Text='<%# Eval("Skills") %>'></asp:Textbox>
</td>
</tr>
<tr>
<td class="col-md-6">
<asp:label class="link_sgray" id="Label1" runat="server" >Proficiency: </asp:label>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="Proficiency"
Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator>
<br />
<asp:DropDownList style="width:100%" id="Proficiency" CssClass="dropdown" runat="server" Enabled="false" selectedvalue='<%# Eval("Proficiency") %>'
DataSourceID="ProficiencyDDL" DataTextField="Value" DataValueField="ID">
</asp:DropDownList>
</td>
<td class="col-md-6">
<asp:label class="link_sgray" id="Label8" runat="server" >Years of Experience: </asp:label>
<asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="YearsofExperienceSkills"
Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator>
<br />
<asp:DropDownList style="width:100%" id="YearsofExperienceSkills" CssClass="dropdown" Enabled="false" runat="server" selectedvalue='<%# Eval("YearsofExperienceSkills") %>'
DataSourceID="YearsofExperienceSkillsDDL" DataTextField="Value" DataValueField="ID">
</asp:DropDownList>
</td>
<%----%>
</tr>
<tr>
<td>
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="True" CommandName="Edit" Text="Edit" CssClass="btn-primary" />
<asp:LinkButton ID="DeletelButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" CssClass="btn-primary"/>
</td>
</tr>
</table>
</ItemTemplate>
</asp:FormView>
</ContentTemplate>
</asp:UpdatePanel>
<asp:SqlDataSource ID="ProficiencyDDl" runat="server" ConnectionString="<%$ ConnectionStrings:crms%>"
SelectCommand="SELECT [ID]
,[Value]
FROM [dbo].[StringMap]
where [AttributeName]='Proficiency' "> </asp:SqlDataSource>
<asp:SqlDataSource ID="YearsofExperienceSkillsDDl" runat="server" ConnectionString="<%$ ConnectionStrings:crms%>"
SelectCommand="SELECT [ID]
,[Value]
FROM [dbo].[StringMap]
where [AttributeName]='Years of Experience Skills' "> </asp:SqlDataSource>
<%----%>
<asp:sqldatasource id ="FormViewskillsSDS" runat="Server" ConnectionString="<%$ ConnectionStrings:crms%>"
SelectCommand="
SELECT SkillsID,
[Skills] ,
[Proficiency] ,
[YearsofExperienceSkills]
FROM Skills
inner join StringMap SMSP on SMSP.ID= Skills.Proficiency
and SMSP.AttributeName='Proficiency'
inner join StringMap SMYOES on SMYOES.ID= Skills.YearsofExperienceSkills
and SMYOES.AttributeName='Years of Experience Skills'
where ApplicantID=@ApplicantID and
SkillsID= @SkillsID
"
InsertCommand="Insert into [Skills] ( Skills ,
Proficiency ,
YearsofExperienceSkills
, ApplicantID ) VALUES ( @Skills, @Proficiency , @YearsofExperienceSkills , @ApplicantID); select @SkillsID = SCOPE_IDENTITY() "
DeleteCommand="DELETE FROM [Skills] WHERE [SkillsID] = @SkillsID"
UpdateCommand="UPDATE Skills
SET
Skills= @Skills
,Proficiency= @Proficiency
, YearsofExperienceSkills= @YearsofExperienceSkills
WHERE ApplicantID = @ApplicantID and
SkillsID= @SkillsID">
<SelectParameters>
<asp:SessionParameter Name="ApplicantID" Type="Int32" SessionField="ApplicantID" />
<asp:Parameter Name="SkillsID" Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:ControlParameter Name="Skills" ControlID="Formviewskills$Skills" Type="string" PropertyName="Text" />
<asp:ControlParameter Name="Proficiency" ControlID="Formviewskills$Proficiency" Type="int32" PropertyName="SelectedValue" />
<asp:ControlParameter Name="YearsofExperienceSkills" ControlID="Formviewskills$YearsofExperienceSkills" Type="int32" PropertyName="SelectedValue" />
<asp:SessionParameter Name="ApplicantID" Type="Int32" SessionField="ApplicantID" />
<asp:parameter Direction="Output" Name="SkillsID" Type="Int32" />
</InsertParameters>
<DeleteParameters>
<asp:SessionParameter Name="SkillsID" Type="Int32" SessionField="SkillsID" />
</DeleteParameters>
<UpdateParameters>
<asp:ControlParameter Name="Skills" ControlID="Formviewskills$Skills" Type="String" PropertyName="text"/>
<asp:ControlParameter Name="Proficiency" ControlID="Formviewskills$Proficiency" Type="int32" PropertyName="SelectedValue" />
<asp:ControlParameter Name="YearsofExperienceSkills" ControlID="Formviewskills$YearsofExperienceSkills" Type="int32" PropertyName="SelectedValue" />
<asp:SessionParameter Name="ApplicantID" Type="Int32" SessionField="ApplicantID" />
</UpdateParameters>
</asp:sqldatasource>
and the dynamically code add in the page load of main page is
Session["FormMode"] = false;
da = new SqlDataAdapter("select SkillsID from Skills Where ApplicantID='" + ApplicantID + "'", con);
con.Open();
ds = new DataSet();
da.Fill(ds, "Jobs");
DataTable SkillsTable = ds.Tables[0];
if (SkillsTable.Rows.Count > 0)
{
int i = 1;
foreach (DataRow row in SkillsTable.Rows)
{
DataColumn col = SkillsTable.Columns["SkillsID"];
Session["SkillsID"] = row[col].ToString();
HtmlGenericControl DivSkills = new HtmlGenericControl("div");
DivSkills.Attributes.Add("class", "class=panel - body");
DivSkills.Attributes.Add("id", (i).ToString());
Skillspnl.Controls.Add(DivSkills);
System.Web.UI.UserControl uc3 = (System.Web.UI.UserControl)Page.LoadControl("~/JobSeeker/skills.ascx");
FormView SkillsFV = uc3.FindControl("Formviewskills") as FormView;
SkillsFV.DefaultMode = FormViewMode.readonly;
SqlDataSource SqlSkills = uc3.FindControl("FormViewskillsSDS") as SqlDataSource;
SqlSkills.SelectParameters["SkillsID"].DefaultValue = row[col].ToString();
SqlSkills.DataBind();
DivSkills.Controls.Add(uc3);
i++;
}
}
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
