Better To Have A Reply Table For Each Category Orhave Only One Reply Table For Whole Site
May 10, 2009
Using Vb.net 2003 Sql Server 2005 Asp.net 1.1..If I were to make a forum site and I had alot of visitorsdaily, like 300,000.I also had many categories such as this site.Would it be better to have a Reply table for each category orhave only one Reply table for the whole site.The same for Question table, although the questions would be numerousit would be smaller than the Reply table.Also if anyone has a Database Diagram,or Schema of a large forum I like to take a lookat one have'nt seen any online for a forum.
I'm having problems with parsing the XML results that a webservices is sending me. Mostly due to the format this result is sent in. I can succesfully send a request and I get the response back in a string. Now the (truncated) result looks like this:
This is where my problem starts. Because I've found various pieces of code that let me take out the nodes I need. So in the above example <Office> and <code> come out perfectly. But the problem appears when reading the other lines because they start with <td SPACE field=> etc etc. When I readout those lines all I get back is TD.
I need to specifically filter the results based on those TR/TD fields. I'm using an XMLreader and xmlnodetype to filter out the results, but maybe I'm using the wrong method.
I receive info requests through email, generated from a web form, which I cant touch, I would, but I can't cos it's an external service. These emails have assigned differents template replies, which I, manually, use to answer them. For this company, this is obvious. For me is a machine work, it¡s totally automatic. So, why don't I set up a rule in Outlook? Because the reply-to address doesn't match with the real one. As it comes from our own server, the reply-to address is our own address.
i just have to answer with different specific templates I already have depending on different fields in the message and send this to an address that is also in one of these message fields. For more data, here is one of the messages I could receive:
I have to set our support email to send an out of office reply between 6pm and 8am every day and then for the entire weekend. I come to find out exchange does not support this. Is it possible to write a "service" that I can load up on a machine that monitor the support email then send an auto reply if it is between 6pm and 8am? Basically it would just be a lite weight email client that only does anything outside of business hours.
i have the code below to ping an ip address, it works fine but Is there anyway i can include the reply times in the display or return the ping reply times in any shape or form for that matter ? preferable the average round trip time in ms is what i would like returned along with the ping result. anyone have any ideas or is it even possible to do within vb ?
I am developing a vb.net program which shells to SmartRipper to do the actual ripping process and I need the process to run unattended. The problem I've just spent 4 days trying to resolve is to simply respond to a message box that pops up when SmartRipper starts but I'm not having much success at all.
When I try SendKeys.Send("{ENTER}") while debugging the program I get an error "changes are not allowed while code is running or if the option "break all processes when one process breaks is disabled". I don't know why the error message shows but I do have the option enabled as indicated how to eliminate it from showing.
I've been working on this for 4 days and now I'm just spinning my wheels.
' Declares Private BM_CLICK As Integer = &HF5 Declare Auto Function SendMessage Lib "user32" (ByValhWndAsIntPtr,
I've an old vb6 ocx in order to show an msgbox with autoreply in n seconds.
rm = waitMsg("can't connect to host...",9,"*Retry","Cancel") if rm = 2 then exit sub 'cancel
acts in same way of msgbox, but after 9 seconds (in the example) then auto click the Retry button (the default button, the one with * prefix). maybe I could convert this old ocx to net, but wondering if there is not an better alternative using messagebox.
currently i doing a sms service system using vb , can anyone tell me how or what code i can use to make the system auto reply when recieve an sms from a phone no
I'm working on a VB.Net application that extracts emails from an Exchange inbox and then does various things with them. I want it to treat out-of-office auto-replies differently to everything else, so I was hoping someone might know how to identify them.
Obviously, I could simply look to see if the message subject starts with "Out of Office:", but that seems a bit sloppy to me. There's clearly a more accurate way to identify them, because in Outlook, an auto-reply has a different icon to a normal email that simply has "Out of Office:" at the beginning of the subject.
I'm using the component Independentsoft.Webdav.Exchange.dll to handle the email side of things, but I couldn't find anything obvious there.
I'm trying to create a program that calls the command prompt, runs a line of text, needs to wait for a specific reply then moves on. Using the sleep command doesn't really apply in this particular situation because I need to wait for either reply A or reply B and move on accordingly. Most of the resources I find on this all refer to the sleep command. Sure there is a way to view a reply in the shell command and if reply A then do the rest...etc.
I am trying to make a program that will stop people on the same network being able to tale if im online by pinging my i.p adress aparantly the only way of doing this is to "drop icmp packets and not reply to them"
dose anyone know how to do this? and can anyone provide me with a basic script that will do this?
i use visual basic 6 i already try making a button to play sounds. by clicking the button and the sound will out. so that i want to know were could i start, when you input words in textbox the program will speak what you have type in the textbox. _
I have a data table whose one column is related to a column of another table. I have a listbox in a form which shows a column (which is sorted by another column value by ORDER clause) of the parent table and other columns are in textboxes. The child table is represented by a datagrid. When I add a new item in parent table and click save, the newly created item is listed at the bottom of the listbox violating my ORDER clause. When I wrote some codes to fill data again after updating, it shows an error message[code]...
I was using ContentType="application/vnd.ms-excel" on my web site to display a datatable in an excel workbook on the client. It worked great. Now that I have upgraded to Office 2007 and vb.net 2010, I get a warning saying that the file is in a different format than specified by the file extension (.xls). I googled new ways of exporting data to excel, but have yet to find a good example. I usedMicrosoft.Office.Interop.Excel which worked great, except I read that you are not supposed to use this on a web server.
Let's say, I have something like a table in the WebBrowser component, it's not actually a table, because the data organized in flash, but, it's organized like a table, it has like rows and columns. You can see more in the attached file. Can I transform this text organized as table into DataGridView or some another tool that serves as table. like_a_table.JPG
I have a large form that is set up from master-detail datasets in Visual Studio 2008.I havene master table with a large amount of detail tables. Several of the detail tables also have detail tables linked.Now I need to add a master table that sits on top of my existing master table making it a detail table.
I have a login form that consists of 2 text boxes: txtUser, txtPass. Now these are not bound to any data table & I don't what them to be bound. When a new user enters his user name & password, I want to add these on a data table that has two columns: User, Pass. Data table information: Data Source = Login.accdb, Data table = LoginTable, Connection = LoginCn. I use visual basic 2010. So how do I do this?
I created a function that creates a global temporary table to stage data from a excel sheet I need the table to persist for me to map the columns using a form. The table is still there when the code goes back to the sub that calls the function until I call the form where I do the mapping. I am trying to avoid create/drop table scenario with a perm stage table.How can I get this table to persist until the data gets loaded into the perm table?
I have this code to edit the datarow of my table adapter but t doesnt update the table. I think i have a missing code that's why but i cant figured it out. by the way im using vb2008 and SQL as my database. [code]
I have a database that has two tables in it. One is a table of items (table1) and the other is the table of current items (table2).On form load I need to generate a random amount of the items from table1 and populate table2 with them. I was trying to do something like this:
I currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error. Imports System.Data.SqlClient Imports System.Data Imports System Imports System.Data.OleDb
I have a query that I have to run that requires me to get rows from a table based on the value of a field in another table (which I have gotten earlier). I currently have it done like this (simplified).
I have a project which contains a large number of lookup tables, and I have all of these lookup tables represented in a single typed DataSet, which contains TableAdapters for each lookup. I've designed an editor for these lookup tables, which should allow editing of one of these at a time. My front-end is written in VB and WinForms, the back-end is a SOAP web service; I can successfully pass the changes to the DataSet back to the web service, but can't find a way to use a TableAdapter to update the single table that has been changed.
What I'm trying to do is instantiate the appropriate TableAdapter for the updated DataTable by sending the name of the table back to the web service along with the DataSet, then referring to the TableAdapter with a dynamic name. The normal way to instantiate a TableAdapter is this:
Dim ta As New dsLookupsTableAdapters.tlkpMyTableTableAdapter
What I'd like to do is this, but of course it doesn't work:
strTableName = "tlkpMyTable" Dim ta As New dsLookupsTableAdapters(strTableName & "TableAdapter")
Is there any way to achieve this, or am I taking the wrong approach altogether? My other alternative is to write separate code for each table, which I'd prefer to avoid!
An unhandled exception of type 'System.InvalidOperationException' occurred in system.windows.forms.dllerror in line: dbAdp.Update(dbDset) in btnSave_Click, (elseif editflag = true) blockdescription: Update unable to find TableMapping['Table'] or DataTable 'Table'I was also wondering if I could simply use the ExecuteNonQuery for the delete statement, but since I've placed my data in a datarow, I'm not sure if i can actually use it. Any thoughts on this? Btw, this is my first time using a datarow, and I've recently been studying how to use ADO.net.
dr = dbDset.Tables(0).Rows(CurIndex) dr.Delete() dbAdp.Update(dbDset.Tables("addresses"))
I have two tables Employees and CafeLogs. Some employees can be cashiers and also customers at the Cafe shop.
Table structures:
Employees: EmployeeId(PK) , FirstName, LastName CafeLogs: LogId (PK), CashierId, EmployeeId, Value, => CashierId and EmployeeId are the data from column EmployeeId of Empoyee table
Table relationship:
Employees 1:N CafeLogs (CashierId (FK))
[code]....
Right now I know how to select only LogId, Employee's name, and , Value, not with Cashier name yet.
Dim query = From log In db.CafeLogs _ Join emp In db.Employees On emp.EmployeeId Equals log.EmployeeId _ Select log.LogId, emp.FirsName, emp.LastName, log.Value
