|
|
i had seen it before. but that is a very simple case just count the products against a category, while i am storing tags in a single column seprated by space first need to get the indivisual tag and then its weight but got problem in making query.
need guidance regarding how to fetch tags and their weight from single column of a table
shezi
modified on Monday, January 21, 2008 2:36:47 AM
|
|
|
|
|
shah zad wrote: while i am storing tags in a single column seprated by space first need to get the indivisual tag and then its weight but got problem in making query
Well, if you normalise your data model you won't have that problem. You should only ever store a single piece of data in a column value. You should not be storing multiple tags in a single row.
You need to create a new table and split the tags out into the new table. Then set up a many-to-many join between your original table and your tags table. A many-to-many join requires the setting up of an intermediate table.
shah zad wrote: need guidance regarding how to fetch tags and their weight from single column of a table
While it is possible, it is increadibly inefficient and goes against decades of guidance on how to define relational databases.
|
|
|
|
|
Is it possible to enter data into a grid directly when a project is run.
|
|
|
|
|
SreejithAchutan wrote: Is it possible to enter data into a grid directly when a project is run.
Yes. But GridView does not support it directly. You have to manually make it editable. Use TemplateColumns and add controls and try.
|
|
|
|
|
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:ButtonField DataTextField="DeptName" CommandName="Select" HeaderText="DepartmentName" ></asp:ButtonField>
<asp:TemplateField>
<ItemTemplate>
<asp:TextBox ID="txt1" runat="server"> </asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
protected void Button1_Click(object sender, EventArgs e)
{
int DeptID;
string ID;
foreach (GridViewRow gr in GridView1.Rows)
{
ID = Gdv_Dept_List.SelectedDataKey.Value.ToString();
DeptID = int.Parse(ID);
TextBox tx = (TextBox)gr.FindControl("txt1");
insDept.up(DeptID,tx.Text);
BindGrid();
}
}
I gave the above design code and also in button click event above code is given.but when we tried to save it the selected field is updated to empty.what is the reason.
|
|
|
|
|
Are you trying to populate/defining value to the GridView on Page Load event?
|
|
|
|
|
Hi all,
I want to check whether a system is connected with a LAN or not? How can i do it using .Net either VB or C#.
Second thing is after detecting the network connection i want to find the IP address OR Machine name of the Local Area Network Server. And using that LAN server IP/Name i want to listout all the machines that are connected at this moment. How can i do this?
What way i can achieve the above needs? What are the namespaces should i require to achieve these things done?
Expecting ur reply. Please anyone help me?
regards
saravanan
Known Is Drop.Unknown Is Ocean
|
|
|
|
|
saravanan05 wrote: I want to check whether a system is connected with a LAN or not? How can i do it using .Net either VB or C#.
I am not sure about checking the LAN connection.
saravanan05 wrote: Second thing is after detecting the network connection i want to find the IP address OR Machine name of the Local Area Network Server. And using that LAN server IP/Name i want to listout all the machines that are connected at this moment. How can i do this?
Try the below code. You get the computer's list in a DataTable.
public DataTable GetComputers
{
DataTable dtComputers = new DataTable("Computers");
DataColumn dc;
DataRow dr;
dc = new DataColumn("ComputerName");
dc.DataType = System.Type.GetType("System.String");
dc.MaxLength = 50;
dtComputers.Columns.Add(dc);
dc = new DataColumn("IPAddress");
dc.DataType = System.Type.GetType("System.String");
dc.MaxLength = 50;
dtComputers.Columns.Add(dc);
Process p = new Process();
p.StartInfo.FileName = @"net.exe";
p.StartInfo.Arguments = "VIEW";
p.StartInfo.CreateNoWindow = true;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.UseShellExecute = false;
p.Start();
p.WaitForExit();
while (!p.StandardOutput.EndOfStream)
{
string readLine = p.StandardOutput.ReadLine();
string computerName = "";
if (readLine.IndexOf("\\") == 0)
{
dr = dtComputers.NewRow();
computerName = readLine.Substring(2, readLine.IndexOf(" ")).Trim();
Console.Write("\n" + computerName);
dr["ComputerName"] = computerName;
dr["IPAddress"] = Dns.GetHostEntry(computerName).AddressList[0];
dtComputers.Rows.Add(dr);
}
}
if (!p.HasExited) p.Kill();
return dtComputers;
}
|
|
|
|
|
hi friends
Am not getting EndOfStream after StandardOutput what namespace should be used for this.
what namespace should be used to get DNS.
Known Is Drop.Unknown Is Ocean
|
|
|
|
|
Add,
using System.Diagnostics;
along with other namespace
|
|
|
|
|
|
Hello all. I'm an intermediate programmer, but relatively new to the web end of things and was wondering about the best way to go about scheduling an occasional task to run on the server... say every day or a certain number of hours/minutes.
"So what's the future like? Are there flying cars and everything's clean?"
"No, the cars are still on the ground and it's even dirtier, but we're working on it."
From: Quantum Leap (not verbatim)
{o,o}.oO( Want a great RSS reader? Try FeedBeast! )
|)””’) ( Check out my profile for a special CodeProject deal! )
-”-”-
modified on Sunday, January 20, 2008 9:53:14 PM
|
|
|
|
|
Windows service is good one for this.
|
|
|
|
|
Can you be more specific? How does one go about writing/installing a Windows service on a web server? I am hosted with 1&1, and do not have direct access to IIS.
"So what's the future like? Are there flying cars and everything's clean?"
"No, the cars are still on the ground and it's even dirtier, but we're working on it."
From: Quantum Leap (not verbatim)
{o,o}.oO( Want a great RSS reader? Try FeedBeast! )
|)””’) ( Check out my profile for a special CodeProject deal! )
-”-”-
|
|
|
|
|
Aha, disregard that last message, I think I found what I need:
http://msdn.microsoft.com/msdnmag/issues/05/03/SchedulingASPNETCode/default.aspx[^]
Thanks!
"So what's the future like? Are there flying cars and everything's clean?"
"No, the cars are still on the ground and it's even dirtier, but we're working on it."
From: Quantum Leap (not verbatim)
{o,o}.oO( Want a great RSS reader? Try FeedBeast! )
|)””’) ( Check out my profile for a special CodeProject deal! )
-”-”-
|
|
|
|
|
Hi,
I have developed an ASP.Net Website,
and now I have published it,
in first page there is no code to run, only a login page but when I want to open my website in web a Runtime Error, but yet no code is runned.
it's the first time I upload an asp.net web site.
should I do any changes in my web.config for upload?
my web.config:
<?xml version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings>
<add name=".." connectionString="Data Source=.;Initial Catalog=..;User ID=..;PWD=.." providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
<compilation debug="false">
</compilation>
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
-->
<authentication mode="Windows"/>
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
</system.web>
</configuration>
Best wishes
|
|
|
|
|
mehrdadc48 wrote: when I want to open my website in web a Runtime Error
If you provide details of the error message, someone might be able to assist.
No information = no help.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
mehrdadc48 wrote: I have developed an ASP.Net Website,
and now I have published it,
* Published in a Third Party server?
* What framework version you have developed your website?
* Does the Server has the same Framework installed?
|
|
|
|
|
Hi, i have a rookie question. how do i link asp.net and silverlight so that i can set properties or values on asp.net page and be able to access those values with a silverlight client?
i started a asp.net web application project. then i added a silverlight project. in asp.net, i selected "add silverlight link". at this point, i think i should be able to somehow move any data back and forth between asp and silverlight, and this is where i'm stuck. any suggestions what i can try ?
thanks !!
|
|
|
|
|
If you're talking about having a Silverlight object and other server controls on the same ASP.NET page, and have them share data back and forth, I think this proof of concept[^] will point you in the right direction.
If you're talking about having a silverlight component that should communicate with an ASP.NET web service, take a look at this QuickStart tutorial[^].
|
|
|
|
|
smashguitars wrote: how do i link asp.net and silverlight
You can use "Add Silverlight Link" in VS 2008 if you have Silverlight Tool for VS 2008 installed.
smashguitars wrote: how do i link asp.net and silverlight so that i can set properties or values on asp.net page and be able to access those values with a silverlight client?
No. You won't be able to get the properties of ASP.NET page from Silverlight project. The main reason why we should use "Add Silverlight link" is that ~
1. To prevent the cross-domain error. For example, you won't be able to access the database from Silverlight directly. So, you have to create the webservice for that. then you have to invoke that service to get the data from database. If you are using two different projects for web service and silverlight project, you will get the cross-thread.. So, what we used to do is that we put the webservice in ASP.NET project and add the silverlight link to ASP.NET project.
Let me know if you need more help on Silverlight 1.1 with ASP.NET. I'm willing to help you..
|
|
|
|
|
Hi all....
i have an excel sheet with images, now i want to read the images from excel sheet and save in to a folder using c#...
please help me....it is urgent....
thanks
Pradeep K.
Pradeep Reddy
|
|
|
|
|
pradeep kumarappagari wrote: please help me....it is urgent....
That is considered impolite on this site.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Hi
Try the Below code
you have to add one DLL or COM Obeject I dont remember exactly Named Microsoft Excel 11.0 Object
//INCLUDE
using Excel; //For Excel LOCATION DLL Microsoft Excel 11.0 Object Library
using System.Reflection; //For Missing
using System.Runtime.InteropServices; //For Marshall
//CODE:::::
Excel.Application oXL;
_Workbook oWB;
_Worksheet oSheet;
object oMissing = Missing.Value;
Range oRng;
oXL = new Excel.Application();
oWB = oXL.Workbooks.Open("EXCEL LOCATION", oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
int TotalSheetsinExcel = 0;
TotalSheetsinExcel = oWB.Sheets.Count - 1;
oSheet = (_Worksheet)oWB.Sheets[1];
Picture pic = (Picture)oSheet.Pictures(1);
//pic object will have PICTURE
//Close Objects
oWB.Save();
oWB.Close(null, null, null);
oXL.Workbooks.Close();
oXL.Quit();
Marshal.ReleaseComObject(oXL);
Marshal.ReleaseComObject(oSheet);
Marshal.ReleaseComObject(oWB);
GC.Collect();
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
